Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

Specific AU's not showing in Crystal Reports

Sort:
You are not authorized to post a reply.
Author
Messages
Whitney Johnson
New Member
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.
    Adam Jacobson
    Veteran Member
    Posts: 69
    Veteran 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
      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.
        You are not authorized to post a reply.