Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Balance account number on General Ledger Entries

Posted on by 43
Greetings,
 
Please how can i make Balance account number available on the general ledger entries for all transactions?
 
Categories:
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 64,181 Super User on at
    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
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 7,264 Super User on at
    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. 
     
     
  • Oluwseun Abati Profile Picture
    Oluwseun Abati 43 on at
    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 Profile Picture
    YUN ZHU 64,181 Super User on at
    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 Profile Picture
    Valentin Castravet 7,264 Super User on at
    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.
     
     
  • Martin Dráb Profile Picture
    Martin Dráb 225,610 Super User on at
    Balance account number on General Ledger Entries
    Moved from D365 general forum.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans