GL Sub Account Validation

Sort:
You are not authorized to post a reply.
Author
Messages
Jan
Veteran Member
Posts: 55
Veteran Member
    Does any one know of a small Lawson table that contains valid SUB-ACCT values?

    I'm creating a Crystal Labor Utilization Report to be published into LBI.  In my Crystal sql, I'm trying to find a smaller Lawson table where I can query for a list of valid Sub Accounts.  I have to categorize these sub accounts using logic I'll include in the sql.  I could query PRDISTRIB for a unique list DST-SUB-ACCTs but that table is very large.
    muffntuf
    Advanced Member
    Posts: 41
    Advanced Member
      Could you use a inner select query that will derive only the unique sub accounts within your sql? (Or move the whole thing to a view or sp depending on frequency of use).
      Matthew Nye
      Veteran Member
      Posts: 514
      Veteran Member
        The IF subsystem is what you want to use. Specifically you can pull this listing from GLCHARTDTL.
        If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
        You are not authorized to post a reply.