Business Central forum

Balance account number on General Ledger Entries

(1) Share

Report

Posted on by Oluwseun Abati

Greetings,

Please how can i make Balance account number available on the general ledger entries for all transactions?

Categories:

Other Functionality

All responses (6)

Answers (0)

Suggested answer

YUN ZHU 62,742 Super User on at

Like (0)

Report

Balance account number on General Ledger Entries

Hi, In this case, you can enable the function below, and then the Debit Amount GL will be on the left, and the Credit Amount GL will be on the right in your report, or vice versa.

More details:

Dynamics 365 Business Central: “Show Amounts” in General Ledger Setup

https://yzhums.com/4985/

Hope this helps.

Thanks.

ZHU
Suggested answer

Valentin Castravet 6,225 Super User on at

Like (0)

Report

Balance account number on General Ledger Entries

As far as I know its not really possible to get that sort of report out of the box. You can run the G/L Register report - that will show you a list of transaction to the GL and the associated entries for each transaction. Perhaps you can export this report to excel and filter it for a specific GL. If you use the system filter when running the report to a specific GL then the report wont show the associated transactions.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
Oluwseun Abati 43 on at

Like (1)

Report

Balance account number on General Ledger Entries

Hello Valentin,

Thank you for your response.

I'm trying to generate a report that shows all associated entries for a specific GL account within a particular period.

Using document number would not work for this because i'm trying to filter by a specific G/L account to see all its entries and corresponding entries.
Suggested answer

YUN ZHU 62,742 Super User on at

Like (0)

Report

Balance account number on General Ledger Entries

As Valentin mentioned, there is no way to do this.
This is also the biggest difference between BC and some local systems in Asia. If you choose this system, you have no choice but to accept it. . . .

Thanks

ZHU
Suggested answer

Valentin Castravet 6,225 Super User on at

Like (1)

Report

Balance account number on General Ledger Entries

You can't.

Can I please confirm what you're trying to achieve or why do you need this column? If you're trying to find all associated credits/debits for a transaction I would look at the G/L Account No. field instead and look at all entries that have the same document no.

The system populates the Bal. Account No. field depending on how the transaction is setup. In a journal such as the general journal, or the payment journal, if both the credit and debit are in the same line - when the transaction is posted in the general ledger entries you will see the Bal. Account No. field populated.

However, if in a journal your debit are credit are in separate lines (i.e. in 2 lines) - when the transaction is posted the general ledger entries will have the Bal. Account No. field not populated. It will be empty.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
Martin Dráb 225,302 Super User on at

Like (0)

Report

Balance account number on General Ledger Entries

Moved from D365 general forum.