Prev
Next
Forums Financial Management Lawson S3 Financials

ACTRANS has OBJ-ID = 0

 6 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Lisa
Basic Member
Posts: 9
Basic Member
8/30/2012 7:21 PM
    In our ACTRANS table, there are many rows where the required key OBJ-ID has a value of 0, but other rows have a value that we can then link to the GLTRANS table. Why is this value sometimes 0, and what process updates it to a valid value?
    Thanks -
    John Henley
    Posts: 3353
    8/30/2012 7:35 PM
      Are you sure you're not referring to GLT-OBJ-ID? That would be used from ACTRANS to link back to the OBJ-ID in GLTRANS (e.g. ATN.GLT_OBJ_ID = GLT.OBJ_ID).
      By definition, OBJ-ID in ACTRANS cannot be zero unless you are missing indexes..
      Thanks for using the LawsonGuru.com forums!
      John
      Lisa
      Basic Member
      Posts: 9
      Basic Member
      8/30/2012 8:38 PM
        Yes, my mistake; it is GLT-OBJ-ID that has the 0 value.
        John Henley
        Posts: 3353
        8/30/2012 9:16 PM
          What is the SYSTEM code?
          Thanks for using the LawsonGuru.com forums!
          John
          Lisa
          Basic Member
          Posts: 9
          Basic Member
          8/31/2012 2:24 PM
            System Code = AC

            So I can't join to GLTRANS table with the GLT-OBJ-ID because it is 0
            Bob Canham
            Veteran Member
            Posts: 217
            Veteran Member
            8/31/2012 2:46 PM
              If you check the TRANS_TYPE column for the records, if they are A records, then they are AC only transactions created on the AC40. if this is the case, then there is not a related GL journal.
              Lisa
              Basic Member
              Posts: 9
              Basic Member
              8/31/2012 8:15 PM
                Thanks for the tips - I've figured out how to select the rows needed.