web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Total Balance on Payme...
Small and medium business | Business Central, N...
Suggested Answer

Total Balance on Payment Journal

(5) ShareShare
ReportReport
Posted on by olegvi 831

Hi,

We are on the latest version of BC 22.1

On the Payment Journal there are Balance and Total Balance fields that show $0.

Should there be values? Is there an easy way to see the total amount of payment, short of extracting the data to Excel and summing it there?

I have the same question (0)
  • Stewart G. Profile Picture
    Stewart G. 24 on at

    The balance will populate once you select the Applies-to Doc. Type. This will be the total of the Amount line that you have entered.

  • olegvi Profile Picture
    olegvi 831 on at

    Hi Stewart,

    The Applies-to Doc. Type is populated:

    Is there anything else I'm missing?

    Thank you.

  • Stewart G. Profile Picture
    Stewart G. 24 on at

    You need to also add the payment method!

  • olegvi Profile Picture
    olegvi 831 on at

    Added Payment Methods:

    Still the same result.

  • Suggested answer
    Niki Profile Picture
    Niki 439 on at
    Need to remove the Bal. Account No. because It shows the total balance of  single entries.
     
    Screenshot 2025-04-22 145134.png
  • Suggested answer
    M0HAN SINGH Profile Picture
    M0HAN SINGH 372 on at
    Hi you can try the Reconcile Feature of business central.  May be this will solve your query.
    Fields you mentioned is used when you entering the payment entry in 2 different lines. 1 line of account Type(ex. vendor) 2. line account type(ex. G/L, Bank) Balancing A/c in different lines with same document no.
     
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 23,136 Super User 2026 Season 2 on at
  • Suggested answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 17,045 Super User 2026 Season 2 on at
    May this can help : https://yzhums.com/11138/

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 572 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 331 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 330 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans