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

Tables Needed to View Spend for Activity

 2 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
MChism
Basic Member Send Private Message
Posts: 15
Basic Member
6/21/2018 12:56 PM
My Director is requesting report that will show all spend for a particular activity. I can't look at a canned report as I need to pull data from our expense management system. I need to look at the fields on paid invoices as this will capture both Lawson data and Expense management data. What fields do I need to build a Crystal report for this?
JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
6/21/2018 2:09 PM
I have a report that shows all posted transactions for an activity. These are the tables it uses.

ACACTIVITY
ACTRANS
APDISTRIB
GLTRANS

Attachments
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
Chesca
Veteran Member Send Private Message
Posts: 490
Veteran Member
6/25/2018 12:17 PM
Hi, would you be able to email me or attach the report?