Forums
Lawson S3 Financials
how to extract different legder into excel
Author
Messages
Sdcaqd
New Member
Posts: 1
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
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"