• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

Balance Sheet Report

 7 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
vickimorris1
New Member Send Private Message
Posts: 0
New Member
6/16/2008 3:01 PM

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 Send Private Message
Posts: 97
Veteran Member
6/16/2008 3:15 PM
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
Send Private Message
Posts: 3351
6/16/2008 4:22 PM
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
New Member Send Private Message
Posts: 0
New Member
6/16/2008 5:48 PM

Thanks Tracy,

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

vmorris@mcvh-vcu.edu

 

Ruma Malhotra
Veteran Member Send Private Message
Posts: 412
Veteran Member
6/16/2008 5:51 PM
The quickest way is to create an RW100 report. This would be the easiest.
k-rock
Veteran Member Send Private Message
Posts: 142
Veteran Member
6/17/2008 12:58 AM
I'll provide you with the information...for free.

kdgreen311@gmail.com

I can walk you through RW100 or tables.
vickimorris1
New Member Send Private Message
Posts: 0
New Member
6/17/2008 5:36 PM

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 Send Private Message
Posts: 8
Basic Member
9/23/2014 7:37 PM
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