Prev
Next
Forums Financial Management Lawson S3 Financials

Tables needed to view PO and financial activity

 3 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Chesca
Veteran Member
Posts: 490
Veteran Member
6/25/2018 1:04 PM
    We are trying to extract AP and PO data for financial reporting and not sure what tables would give me purchase order info including accounting unit/account/sub account, fiscal year/month, number of units order, cost per item, invoice number, invoice date, invoice status, PO number, line number, line description, vendor code/name, check number, journal number, journal entry ID, line number, and check date/payment date

    Thanks in advance for your assistance
    JudeBac
    Veteran Member
    Posts: 129
    Veteran Member
    6/26/2018 1:58 PM
      Go to the form and place the cursor on the field. Do CTRL-SHIFT-O and take note of the message at bottom bar. Example GLM-ACCOUNT-UNIT. In GEN table FILEDEF and field PREFIX, GLM is GLMASTER.

      I always involve my functional user when making reports on which form they need the report and start there.
      Chesca
      Veteran Member
      Posts: 490
      Veteran Member
      6/26/2018 6:11 PM
        Ok, thanks.
        Kat V
        Veteran Member
        Posts: 1020
        Veteran Member
        7/9/2018 2:10 PM
          You might want to look at the canned MM280 report. That should show you what hits the GL and when.