ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> ARTARTNOT grid
http://www.istechforum.com/YaBB.pl?num=1321646298

Message started by maggie on 11/18/11 at 12:58:17

Title: ARTARTNOT grid
Post by maggie on 11/18/11 at 12:58:17

The ARTARTNOT grid is based on the BKART file. The check number which displays on the grid is a reference number. The actual check number is in the MKECLASS file. I would appreciate if the programmers would write a function field which would show us the actual check number instead of the reference number. The reference number has no meaning to the customer.

Title: Re: ARTARTNOT grid
Post by Dennis Wilkinson on 11/29/11 at 08:13:56

Maggie,

In the latest release (11/19/11 - not sure if sooner), the check number is now visible in the grid. It is listed as "Invc#" in the "PAYMENT" column.

Title: Re: ARTARTNOT grid
Post by maggie on 11/29/11 at 09:57:33

I just loaded the Nov 2011 update. The "Invc#" in the PAYMENT column is the actual invoice number. I am looking for the customer check number that paid that particular invoice. I ran SU-D grid maintenance and checked "replace". Do we have different grids?

Title: Re: ARTARTNOT grid
Post by Dennis Wilkinson on 11/29/11 at 10:10:08

Maggie, my fault. I was using some test data and the invoice number was the same as the check number. If you want, send me an email and maybe I can explain how to fix for you.

Title: Re: ARTARTNOT grid
Post by maggie on 11/30/11 at 08:50:22

Lynn Pantic helped me with a the User Defined Function. It works great! If anyone is interested, the code is as follows:

//UDF6 will get the customer check number for the ARTARTNOT grid
func UDF6
define mkeclass.h type I size 5
if mkeclass.h = 0
openv 'MKECLASS' fnum mkeclass.h lock N
endif
findv M fnum mkeclass.h key mkeclass.num val bkart.check
ret mkeclass.desc

Just follow the "User Defined Function" instructions on the ISTECH website. Thank you Lynn!!