Prev
Next
Forums Financial Management Lawson S3 Financials

Summarized transactions in GL for AP / AC,VP,AP source codes

 2 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Venkatarajamani Raman
Basic Member
Posts: 7
Basic Member
4/10/2009 12:39 AM

    Hi,

    Our customer has configured the setup in such a way that summary of transactions should only go to GL from AR, BR, AP, AP, CB, AC and AM sub systems. I am in the process of building a program that would print all the detail transactions for the given GL account.  While doing so, I am able to identify the detail records for AR, AC, AM and CB records from ARDISTRIB, ACTRANS, AMTRANS and CBDISTRIB respectively using GLT-OBJ-ID. For invoice distribution records in AP (system code AP, source code AD) , I can do so by using GLT-OBJ-ID with APDISTRIB table.  I am stuck with the source codes AP, VP, AC (Vendor Payment, Void Payment and Accrual) of AP system and BR system as I do not know how I can drill around details for the summarized GLTRANS recrds.  Lawson is recommending to use GL45 or GL90.  But I need to build a logic in my customization to pick up records. Can someone throw light on the relationship between GLTRANS and other AP table for source codes AC, AP and VP and for BR system ?

    Thanks/Venkat

    k-rock
    Veteran Member
    Posts: 142
    Veteran Member
    4/10/2009 3:18 PM
      You will need APINVOICE and possibly APPAYMENT in addition to APDISTRIB to get all AP data. These tables go from detail to summary so working back from GLTRANS it should go APDISTRIB > APINVOICE. I don't remember the joins off hand, but I believe they are fairly obvious from INVOICE to DISTRIB. The real trick is understanding the flags of R_STATUS in each table and how they relate to the status of the same field in the other table.
      Venkatarajamani Raman
      Basic Member
      Posts: 7
      Basic Member
      4/13/2009 5:27 AM
        Thanks very much. I shall try this out.