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

how to extract different legder into excel

 1 Replies
 0 Subscribed to this topic
 45 Subscribed to this forum
Sort:
Author
Messages
Sdcaqd
New Member
Posts: 1
New Member
New Poster
New Poster
Congrats on posting!
10/7/2017 3:32 AM
Hello, everyone!

I'm new to Lawson and I have the following questions:

1.How to extract the whole general ledger into excel (not in PDF)?

2.I'd like to see sales ledger based on customer name, e.g. all the sales invoices issued to customer A.How to generate that report ?

3.How to generate AP aging report ?

4.How to create accounts and sub accounts ?

Thanks a lot !:)
rhorn01
Basic Member
Posts: 9
Basic Member
New Poster
New Poster
Congrats on posting!
Engaged Poster
Engaged Poster
Wow, you're on a roll!
10/9/2017 4:04 PM
I'm not sure I can answer all your questions, but as a fairly new user I've found that searching in the flow charts is a good way to navigate the system. Just type "GLFL" or "APFL" in the navigator/search bar & they will come up. You can do that for any module you have security to access.

Accounts/subaccounts are created in GL00.1 & I think you can access your chart in GL200. If you've run the GL290 to view your GL transactions, there should be an option to export it to excel in the Print Manager. Just right-click the report or selected the option under "Actions"