Print General Ledger

1

Hi, how to print general ledger for all the account in one short? The existing one only can select one account at a time.

Thanks

2

If you don’t select any it will print all of them.

3

Thank you so much for the information. It is correct.

4

As for the GL report, can we split the date and the descriptions into separate column in excel when we copy the clipboard into excel?

5

No you cannot

6

You can use the LEFT(A9,10) function to extract the data into a separate column

or

the Text to Columns feature of Excel to separate out the individual items in the description field

image
image1356×509 37.3 KB

or use the

7

Google, or DuckDuck :wink: [ASAP Utilities]
It has a lot of features to use in Excel.
Home&Student edition of ASAP Utilities is free to use.

8

Hi , May I know if the Accounts Receivables and Accounts Payable Aging report can show total sum of all the Debtors and Creditors. Is that possible.

Thank you.

9

Have you created a report to see?

10

The scenario would be customer aging with currency A , there is subtotal for total customer under currency A. There is also a subtotal for customer group under currency B. However, there is no Grand Total for total customer group in currency A and in currency B.

I hope if the grand total can be there in the customer aging report or creditor aging report.

Thanks.

11

You cannot add one currency to another. The result would be meaningless. The best you will be able to do is look at Accounts Receivable in the Summary, where foreign currencies are converted to base currency.