Reporting Invoice Date with GL Trans

Sort:
You are not authorized to post a reply.
Author
Messages
muffntuf
Advanced Member
Posts: 41
Advanced Member

    HI,

    What is the best way to get Invoice Date added to a report with GLTrans?  I have looked at APInvoice and HCHISTDTL with ACHISTHDR.

    They just want a basic listing of GLTrans, but with the Invoice date in the same Accounting Period.

    I am pretty new to this stuff.


    Thanks!

    Derek Czarny
    Veteran Member
    Posts: 63
    Veteran Member
      You can join GLTRANS (OBJ_ID) to APDISTRIB (GLT_OBJ_ID) and APDISTRIB (API_OBJ_ID) to APINVOICE (OBJ_ID).
      John Henley
      Senior Member
      Posts: 3348
      Senior Member
        ACHISTDTL & ACHISTHDR are for invoicing customer receivables (i.e. AR, not AP).
        APINVOICE & APDISTRIB are for invoicing vendor payables (i.e. AP, not AR).

        You want to go from GLTRANS to APDISTRIB to APINVOICE to get the invoice date.
        Thanks for using the LawsonGuru.com forums!
        John
        muffntuf
        Advanced Member
        Posts: 41
        Advanced Member
          Thank you.

          Next question - for these joins, this would only give one record back for one invoice, or do I need to know how to deal with a one-to-many relationship here? If so, how do I make sure I only have one invoice accounted for?

          Thanks!
          Ruma Malhotra
          Veteran Member
          Posts: 412
          Veteran Member
            GLTRANS to APDISTRIB has a one to many relationship. Again APDISTRIB to APINVOICE has a many to one relationship.

            On one invoice you may have multiple lines of items you are ordering that may hit diffrent GL Accounts. So there is a many to one relationship between APDITRIB to APINVOICE.

            Again if you run the GL190 depending on whether you summarize your subsystem entries there may be one journal entry with multiple transactions on it. This explains a ONE to MANY relationship between GLTRANS and APDISTRIB.
            John Henley
            Senior Member
            Posts: 3348
            Senior Member
              Posted By muffntuf on 07/09/2009 09:03 AM

              HI,

              What is the best way to get Invoice Date added to a report with GLTrans?  I have looked at APInvoice and HCHISTDTL with ACHISTHDR.

              They just want a basic listing of GLTrans, but with the Invoice date in the same Accounting Period.

              I am pretty new to this stuff.


              Thanks!


              Just buy this report

              www.lawsonguru.com/Store/p/Crystal-...ID/16.aspx

              Thanks for using the LawsonGuru.com forums!
              John
              muffntuf
              Advanced Member
              Posts: 41
              Advanced Member
                So you have multiple lines of items for one invoice, but you just want the summary of the invoice, or do you mean the GL will bring in line item details as well?

                "GLTRANS to APDISTRIB has a one to many relationship. Again APDISTRIB to APINVOICE has a many to one relationship.

                On one invoice you may have multiple lines of items you are ordering that may hit diffrent GL Accounts. So there is a many to one relationship between APDITRIB to APINVOICE.

                Again if you run the GL190 depending on whether you summarize your subsystem entries there may be one journal entry with multiple transactions on it. This explains a ONE to MANY relationship between GLTRANS and APDISTRIB."
                You are not authorized to post a reply.