Who's On?

	Membership:
	Latest: Steve G
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5242

	People Online:
	Visitors: 124
	Members: 0
	Total: 124

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

Specific AU's not showing in Crystal Reports

2 Replies

0 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

Whitney Johnson

New Member

Posts: 6

5/24/2012 11:36 AM

I have two separate Crystal reports, report (A): is pulling AU’s by Attribute and report (B): is a P&L pulling revenue and expense accounts. For some strange reason I’m not able to get data for two specific accounting units to pull into these reports. Does anyone have an idea what may be causing this? Could it be the setup of these AU's in Lawson? All other AU data is being captured in the reports.

Deleted User

New Member

Posts: 0

5/24/2012 1:47 PM

Without seeing the SQL, it's hard to know.
However, as a thought, make sure that all your accounting units have the attributes set up in GL20.7.
A blank attribute means there's no record in the table (AUMXVALUE). So, the accounting units may not show up.

Ruma Malhotra

Veteran Member

Posts: 412

5/24/2012 8:14 PM

If you have all the attributes setup and the accounting units are still not showing up, and the number of accounting units are a large number, there may be a crystal registry key that you might need to change where you are increasing the upper limit of the field.

There is an article on Lawson support that walks you how to change the registry key.