Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

Crystal Report utilizing Account Attribute Lists

Sort:
You are not authorized to post a reply.
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
    Senior Member
    Posts: 3348
    Senior Member
    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 =<whatever>
      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.
        You are not authorized to post a reply.