Prev
Next
Forums Financial Management Lawson S3 Financials

GL Information (New to Lawson)

 3 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
joe_oregon
New Member
Posts: 3
New Member
2/22/2008 6:50 PM
    Hi…
     I am new to the Lawson and have a couple of question if someone in the group could answer them.

    The questions deal with finance GL entries and how to obtain financial information from the Lawson tables.

     The information is specifically about the following:
    1) All GL information in the GLMASTER table, but I also need the assets and the liabilities also. Please correct me if I am wrong, but I am not able to produce liabilities and assets from the GLMASTER. If not… where do I find this information so that I can map the information back to the GLMASTER table and have a complete list of: Assets, liabilities, revenue, deductions, expenses, and hours?  (For a single year)
     
    2) Accrued Receipts accounting… where would I generally find this information for department/unit detail information. What tables hold this information at a department/unit level?
     
    3) Black box technology… does Lawson have canned reports that a person can pull from, via SQL or another method, besides the Lawson client. I haven’t researched this out, but I’ve been told that Lawson has Black Box reports. (Input / refined output)
     
    Thanks…
    k-rock
    Veteran Member
    Posts: 142
    Veteran Member
    2/22/2008 7:14 PM
      If you want account level detail, the balances are kept in GLAMOUNTS (dollars) and GLUNITS (units). This table should answer both 1 and 2.

      Once you see a canned Lawson report, you'll stop wanting to use them. Crystal has the ability to use Lawson reports as a data source. If you want to use SQL, it is fairly easy to write reports against the tables directly.

      For more table info, check out the ERDs link at the top of the page.
      John Henley
      Posts: 3353
      2/22/2008 7:24 PM
        The way the GL is structured in Lawson:
        GLCHART defines a chart of accounts.
        GLCHARTSUM contains "summary" accounts in that chart.
        GLCHARTDTL contains detail accounts for the chart. The records in GLCHARTDTL are what would traditionally be called "natural" accounts.

        GLNAMES is used to define Accounting Units (i.e. your organization structure).

        Finally, GLMASTER is used to store valid accounting unit / account combinations, and can include all account types (Assets, liabilities, revenue, & expenses). One of the key decisions you probably made in your implementation was how to set up the balance sheet. Some companies create balance sheet accounts for each operating accounting unit. Others use a single balance sheet accounting unit.
        Thanks for using the LawsonGuru.com forums!
        John
        joe_oregon
        New Member
        Posts: 3
        New Member
        2/25/2008 3:02 PM

          Perfect.. thank you guys.