Prev
Next
Forums Financial Management Lawson S3 Financials

how to extract different legder into excel

 1 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Sdcaqd
New Member
Posts: 1
New Member
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
    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"