Small and medium business | Business Central, N...

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?

I have the same question (0)

All responses (6)

Answers (0)

Martin Dráb 238,149 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Moved from D365 general forum.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,586 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

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/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 96,039 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Oluwseun Abati 82 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,586 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 96,039 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No