PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/09/2017 12:04 PM by  rhorn01
how to extract different legder into excel
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Sdcaqd
Finance executive
Private
New Member
(1 points)
New Member
Posts:1


Send Message:

--
10/06/2017 11:32 PM
    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
    Director of Accounting
    Private
    Basic Member
    (11 points)
    Basic Member
    Posts:7


    Send Message:

    --
    10/09/2017 12: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"
    You are not authorized to post a reply.