ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Add field to SOLINES Grid for IN-A
http://www.istechforum.com/YaBB.pl?num=1229976877

Message started by gtladmin on 12/22/08 at 13:14:37

Title: Add field to SOLINES Grid for IN-A
Post by gtladmin on 12/22/08 at 13:14:37

Is is possible to add a field from a different table (BKARINV) to the SOLINES grid? Our sales staff want to see the customer PO number show up in the sales order grid when they look up a part#.

Can you add fields from a different table (cust po field)?

If not, can we do this in an upcoming version?

Thanks,

Val

Title: Re: Add field to SOLINES Grid for IN-A
Post by NovaZyg on 12/22/08 at 14:22:24

Val,

Yes you can, but you will need the Dec. Update being posted today to do so.

And it will require a little TAS programming on your part, but easy enough to do.

Email me and I can walk you through it once you have the Dec. update put in.

Title: Re: Add field to SOLINES Grid for IN-A
Post by NovaZyg on 12/22/08 at 14:53:44

Val,

It would seem that the CUST PO was added to the Standard grid, and you will get it with the Dec update..
But I also did make this work too....

Here is an example of how to add a UDF (User Defined Function) to a grid.

Using SU-A open the grid you want add a field to. Add a new record and give it a header, then type into the field UDF1 (UDF1..25 are available) then specify the type and size in this example A 25. you can play with the number for the size on the grid.

then when you save it will tell you you need to create UDF1.SRC before this grid will work correctly.

So now make a file called UDF1.src in your DBAMFG folder. In it put.....

// UDF1 will get the last cost for WOBOM used in WOBOMMI grid
func UDF1
define icmstr.h type I size 5 // File handle to open BKICMSTR
if icmstr.h = 0
openv 'bkicmstr' fnum icmstr.h lock N // this will open the file once
endif
findv M fnum icmstr.h key bkic.prod.code val wobom.compcode // this find the correct record
// return the value
ret str(bkic.prod.lstc)

// = comments

and that should do it.. save the file and then test your grid..
Using the above method you can add fields from other tables, or add your own calculated fields.

;)

Title: Re: Add field to SOLINES Grid for IN-A
Post by gtladmin on 01/07/09 at 09:01:30

Absolutely awesome, Allen! You keep me in a good light with the end users.....muchas gracias!

Val

(I'm applying the update next week, after the Finance folks have finished their year end stuff.)