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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Bank Reconciliation Allocation issue

(0) ShareShare
ReportReport
Posted on by 14
I have a client that had their system set up that when a vendor invoice was posted, based on the payment method, BC automatically created the payment entry and posted.  In this instance, the actual payment was not sent to the vendor.  Since this was not created from a journal entry, I am unable to reverse the payment.  I have unapplied it to the invoice on the vendor ledger and created a Cash Receipt "Refund" to apply against the auto-generated payment, but BC still has odd amount showing as remaining on the bank ledger entry side.  Here's the breakdown of what happened.
 
  • Invoice received and posted for $7473.10
    • Auto payment created for $7473.10 but not sent to vendor - can't reverse due to not being created from a journal
    • Created a Cash Receipt "Refund" for the auto-payment of $7473.10. 
      • BC bank ledger entries show that the payment entry has $30.61 remaining even after applying the full amount of the "refund"
Actual Vendor transactions:
  • Invoice received for $7473.10
  • Vendor re-issued invoice for $7442.49
    • Credit Memo created for $30.61 and applied against the invoice
    • Payment by check was issued to vendor for $1140.20
      • payment created in BC and showing in the vendor ledger entries and bank ledger entries
    • Final payment issued for vendor for balance $6302.29
      • payment created in BC and showing in the vendor ledger entries and bank ledger entries
I am trying to complete a bank reconciliation, but receiving an allocation error from that auto created payment.
 
Any idea on how I can get this to clear out so I can post the bank reconciliation?
I have the same question (0)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,948 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,048 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 727 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans