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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Credit Memo Doesn't Balance with Applied Payment

(0) ShareShare
ReportReport
Posted on by 10

I'll start by saying I've spent days searching for a way to fix this issue and even created a new company from scratch due to this same issue... and have spent weeks re-creating all my historical records. 

2020_2D00_04_2D00_23-14_5F00_45_5F00_29_2D00_View-_2D00_-Customers-_2D00_-Dynamics-365-Business-Central.png

I created a document detailing the issue and I'm hoping someone can help me figure out how to correct the Payment total.

[View:/cfs-file/__key/communityserver-discussions-components-files/758/Problem-Correcting-Payment-Record-when-using-Payment-Method-linked-to-a-Bank-Account.pdf]

Thanks,

I have the same question (0)
  • Suggested answer
    Brian Wick Profile Picture
    Microsoft Employee on at

    Hi John,

    I think part of the problem is the Cash/CC Payment created at the time of posting the Invoice shares the same document # & posting date and therefore has the same applications.  It is not separated out like a normal payment/invoice transaction.  Then when you drill back on the Payment LCY flow field on the Customer List you get no application Detail Ledgers.  I would be willing to write this up as a bug to see if Development would review it.  I just need a support incident created.  You can reference this Forum and I will try to pick it up.  The case would be no-charge since I would be submitting a writeup.  Thanks.

  • JohnCFitzpatrick Profile Picture
    10 on at

    Thanks Brian,  I'm working to get a support ticket created but am in a strange land as I'm in the middle of moving from a grandfathered CSP plan to a new Indirect Partner.  I've asked my new partner if they can help create a support ticket but so far no response.  Is it possible to move forward or do we need to wait?

    Also, do you know of any way to fix the payment balance for my company?

  • Suggested answer
    Brian Wick Profile Picture
    Microsoft Employee on at

    Hi John,

    If your Customer Card shows a figure in the Balance ($) field due to the unapplied CC payment, what you could do is go to a Sales Journal and enter a Refund.  Then apply that refund against the payment.  That should zero out the Balance($)/LCY field on the Customer Card.  Things should look good from a Balance LCY perspective.

    If you are strictly talking about the Payments ($) part, the Payment($) flow field on the Customer List & Stats drills back to Detailed Ledger Entries, not Customer Ledger Entries like most of the other fields (i.e. Balance ($)).  When you drill back, you are unable to see any 'Application' detailed ledger entries associated with the payment to offset the balance to 0.00, so it just shows the payment's 'Initial Entry' amount in the Cust. List.  

    There are actual Application detailed ledger entries for the payment, problem seems to be that since this payment shares the same document # as the invoice it is not able to display properly to zero out the amount.  It looks like a calculation issue with the field that Dev needs to investigate...just my initial assumption.  If your new partner submits the case, references this post, then I can have Dev look into the issue.  Thanks.

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

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,344 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,742 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,231

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans