• Search Forums
    Advanced Search
Prev
Next
Forums Financial Management Lawson S3 Financials

Tables needed to view PO and financial activity

 3 Replies
 0 Subscribed to this topic
 45 Subscribed to this forum
Sort:
Author
Messages
Chesca
Veteran Member
Posts: 490
Veteran Member
New Poster
New Poster
Congrats on posting!
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
New Poster
New Poster
Congrats on posting!
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
New Poster
New Poster
Congrats on posting!
6/26/2018 6:11 PM
Ok, thanks.
Kat V
Veteran Member
Posts: 1020
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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.