Balance Sheet Report

Sort:
You are not authorized to post a reply.
Author
Messages
vickimorris1
Basic Member
Posts: 8
Basic Member

    I am new to Lawson  but knows Crystal Reporting.  I was asked to create a balance sheet report that contains current

    and prior year balances.  I am not familiar with the General Ledger tables.  Can someone get me started on which

    tables to use to create this report??

    TracyO
    Veteran Member
    Posts: 97
    Veteran Member
      There are several tables needed. IT all depends on how many charts you have also. We have more than one chart so we have to make sure to do a selection on the chart name or we get duplicate entries. You also need to create a formula field to get the balance as Lawson holds it in seperate buckets by period and by credit or debit. I do have an example of that I could send you if you would like. But to get the balances for GL we used the following tables:
      GLNAMES, GLMASTER, GLSYSTEM, GLAMOUNTS,GLCHARTDTL,GLCHARTSUM. You may not need all of these if you only have one chart name.
      John Henley
      Senior Member
      Posts: 3348
      Senior Member
        Re: Balance Sheet Report (9018a425-15c2-408d-a4e3-4037787a1fdd) <!-- Converted from text/plain format -->

        I have one for sale on the LawsonGuru.com store. 
        John Henley

        Thanks for using the LawsonGuru.com forums!
        John
        vickimorris1
        Basic Member
        Posts: 8
        Basic Member

          Thanks Tracy,

          Please send me all the information that you have to the email below!!

          vmorris@mcvh-vcu.edu

           

          Ruma Malhotra
          Veteran Member
          Posts: 412
          Veteran Member
            The quickest way is to create an RW100 report. This would be the easiest.
            k-rock
            Veteran Member
            Posts: 142
            Veteran Member
              I'll provide you with the information...for free.

              kdgreen311@gmail.com

              I can walk you through RW100 or tables.
              vickimorris1
              Basic Member
              Posts: 8
              Basic Member

                Thanks Tracy, I got your information.  K-rock if you can provide me with more information and  on the tables and sample sql  it will be appreciated!!  I have to used the tables to create this report not rw100.

                vmorris@mcvh-vcu.edu

                Alise
                Basic Member
                Posts: 8
                Basic Member
                  Hi Tracy,

                  Just reading an older post regarding the Balance Sheet.

                  I was able to create the formula field to get the balance.

                  I was unable to generate a report using the summary accounts (that is, have a list of accounts (account descriptions) and then subtotal at "Total Assets."

                  If you are able to share any documentation, I'd greatly appreciate it.

                  Thank you,

                  Alise

                  You are not authorized to post a reply.