Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 389
	Members: 0
	Total: 389

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

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

Posts: 15

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

Posts: 1163

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

Posted Transactions for an Activity (screen shot).jpg

Chesca

Veteran Member

Posts: 490

6/25/2018 12:17 PM

Hi, would you be able to email me or attach the report?