Prev
Next
Forums Financial Management Lawson S3 Financials

Unique Identifer from GLTRANSREL to GLTRANS

 4 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Sam Mathew
New Member Send Private Message
Posts: 4
New Member
7/26/2019 2:25 PM
Hi Everyone, I am trying to uniquely pin point transactions from GLTRANSREL table to GLTRANS , how can we achieve this? is there a column where you can add a unique identifier which gets populated in GLTRANS once journals are posted? Thanks Sam
John Henley
Send Private Message
Posts: 3351
7/26/2019 2:47 PM
You’re really limited to using a custom system code,source code, and the 10-char reference field which you’ll probably want to code as a unique sequence number. Also don’t rely on fiscal year and period as part of your uniqueness since a user can move a transaction between periods
Thanks for using the LawsonGuru.com forums!
John
JimY
Veteran Member Send Private Message
Posts: 510
Veteran Member
7/26/2019 2:49 PM
What are you trying to accomplish? Not sure that you want to add a field to the table. You might try populating the REFERENCE field.
Sam Mathew
New Member Send Private Message
Posts: 4
New Member
7/26/2019 5:15 PM
Excellent, i was able to do the same populate a alphanumeric string in reference field in GLTRANSREL and it showed up in GLTRANS table and we are able to match the transactions. Thanks you very much for the info. Have a great weekend! Thanks, Sam
Sam Mathew
New Member Send Private Message
Posts: 4
New Member
7/26/2019 5:16 PM
Thank you JimY- Reference field was the way to go! appreciate the help!