ACTRANS has OBJ-ID = 0 - LawsonGuru.com

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Lisa

Basic Member

Posts: 9

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: 3366

New Poster

Engaged Reader

Avid Reader

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..

Lisa

Basic Member

Posts: 9

8/30/2012 8:38 PM

Yes, my mistake; it is GLT-OBJ-ID that has the 0 value.

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

8/30/2012 9:16 PM

What is the SYSTEM code?

Lisa

Basic Member

Posts: 9

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

Deleted User

New Member

Posts: 0

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

8/31/2012 8:15 PM

Thanks for the tips - I've figured out how to select the rows needed.