Tables Needed to View Spend for Activity

Sort:
You are not authorized to post a reply.
Author
Messages
MChism
Basic Member
Posts: 15
Basic Member
    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
    Posts: 1162
    Veteran Member
      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
      Posts: 490
      Veteran Member
        Hi, would you be able to email me or attach the report?
        You are not authorized to post a reply.