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: 3353
    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.