Unique Identifer from GLTRANSREL to GLTRANS

Sort:
You are not authorized to post a reply.
Author
Messages
Sam Mathew
New Member
Posts: 4
New Member
    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
    Senior Member
    Posts: 3348
    Senior Member
      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
      Posts: 510
      Veteran Member
        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
        Posts: 4
        New Member
          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
          Posts: 4
          New Member
            Thank you JimY- Reference field was the way to go! appreciate the help!
            You are not authorized to post a reply.