• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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
Send Private Message
Posts: 3351
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 Send Private Message
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
Send Private Message
Posts: 3351
8/30/2012 9:16 PM
What is the SYSTEM code?
Thanks for using the LawsonGuru.com forums!
John
Lisa
Basic Member Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 9
Basic Member
8/31/2012 8:15 PM
Thanks for the tips - I've figured out how to select the rows needed.