Welcome, Guest. Please Login.
04/28/24 at 22:05:33
News:
Home Help Search Login


Pages: 1
Send Topic Print
Add field to SOLINES Grid for IN-A (Read 928 times)
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Add field to SOLINES Grid for IN-A
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
Back to top
 
 

Val Feehan
  IP Logged
NovaZyg
Administrator
*****


When all else
fails.. Read the
instructions.

Posts: 789
Gender: male
Re: Add field to SOLINES Grid for IN-A
Reply #1 - 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.
 
Back to top
 
 

Allen Landry
Evo~ERP

EvoERP and DBA Classic always Beta's of the Latest versions.

WWW   IP Logged
NovaZyg
Administrator
*****


When all else
fails.. Read the
instructions.

Posts: 789
Gender: male
Re: Add field to SOLINES Grid for IN-A
Reply #2 - 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.
 
 Wink
Back to top
 
 

Allen Landry
Evo~ERP

EvoERP and DBA Classic always Beta's of the Latest versions.

WWW   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: Add field to SOLINES Grid for IN-A
Reply #3 - 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.)
Back to top
 
 

Val Feehan
  IP Logged
Pages: 1
Send Topic Print