• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

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 Send Private Message
Posts: 6
New Member
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 Send Private Message
Posts: 0
New Member
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 Send Private Message
Posts: 412
Veteran Member
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.