GL Trans Obj-ID

 4 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
muffntuf
Advanced Member
Posts: 41
Advanced Member

    An invoice can have mulitple lines.  When posted to the GL does each line item get posted, or the whole invoice?

    Obj-Id is different for each line I pulled into a report.

    Thanks!

    (Yes I am a newbie!)

    Matthew Nye
    Veteran Member
    Posts: 514
    Veteran Member
      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
      If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
      muffntuf
      Advanced Member
      Posts: 41
      Advanced Member
        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!

        muffntuf
        Advanced Member
        Posts: 41
        Advanced Member
          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.
          Brad Schauer
          Veteran Member
          Posts: 76
          Veteran Member
            On GLTRANS there is a SYSTEM field, sounds like you would be looking for journal entries with a SYSTEM=AP.

            Brad