GL Trans Obj-ID

First, you should probably have a look at the Data Definition files for Lawson. Login to Lawson support and search the KB for the desired subsystem, in your case search for GL Data Text File. You should be sure you have the right Lawson version and platform.

Obj-Id is the unique identifier for what ever table you are pulling. If you want to pull AP Invoice postings youll first need to specify the system. The field for this is JE-TYPE. Depending on what type you identify your join to the related tables will be different, if you want the source system info.

this should get you started but ultimately you want to get comfortable with the Data Text Files (essentially data dictionary) supplied by Lawson.

hth
matt

Matthew,

Thanks, I have been looking on the forum's data dictionary. I know about the JE-Type, but you clarified that I need to ask about whether they only want to pull AP Invoices. The sample data I am looking at is just AP Invoices, but in the report I am pulling everything.

Thanks for the tip!

I meant to say the JE Type I am pulling in for the sample data is Normal. But have no filter for the Je Type.

On GLTRANS there is a SYSTEM field, sounds like you would be looking for journal entries with a SYSTEM=AP.

Brad