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

Crystal Report utilizing Account Attribute Lists

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
JeanneS
Veteran Member
Posts: 49
Veteran Member
7/28/2010 1:58 PM
Has anyone created a Crystal Report using Account Attribute Lists? I want to use the GLAMOUNTS table but don't know how to join the account attributes to this table.
John Henley
Posts: 3362
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
7/28/2010 3:42 PM
The table you want is GLACCMXVAL. You would need to join from GLAMOUNTS to GLCHARTDTL on CHART_NAME, ACCOUNT, and SUB_ACCOUNT, then from GLCHARTDTL to GLACCMXVAL on OBJ_ID and MATRIX_CAT =
Thanks for using the LawsonGuru.com forums!
John
JeanneS
Veteran Member
Posts: 49
Veteran Member
7/28/2010 5:59 PM
John - Thank you! It worked great....you saved me so much time.