Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Drew Kipfer]

Hello, 

We have a situation where we received a customer payment against the wrong customer. Here’s some background info. Their payment was made via credit card, which gets handled by a third party payment processing service. The third party service deposits all the CC payments for a particular day as one lump sum to our bank account. When we receive these payments, we balance them against one line, which is the deposit into our bank account for reconciliation purposes. 

Back to the issue. It seems the correct way to fix this would be to unapply the payment, then reverse the transaction, and receive a payment for the correct customer. The problem being that this payment was made as part of a lump deposit to the bank. If we reversed the transaction would we need to go back and redo all the other payments that were part of that deposit?

Any suggestions or advice appreciated! Thanks!

——————————
Drew Kipfer
EMP Technical Group
——————————

[Kim Dallefeld]

Can’t actually test out your scenario but I have some thoughts…

First, why not just unapply the payment in the customer ledger and don’t reverse the entire transaction. This will open the invoice and the payment ledger entries and leave the lump sum deposit in the bank ledger for reconciliation.
Second, do a journal to debit the wrong customer, applying this to the payment and probably leave the document type field empty.
Finally, do a journal to credit the correct customer, document type payment, apply to invoices that should have been paid.

Note: second and final steps can be done in one journal.

——————————
Kim Dallefeld, Kim@Dallefeld.com, Ft Worth, TX
Dallefeld Consulting, LLC
Member of Dynamics Consulting Group

New View Strategies, – training and consulting.

NAVUG All-Star
NAVUG Programming Committee
——————————
——————————————-

[Drew Kipfer]

Thanks Kim! The system required us to have the same Document Type when posting, so we left both document type fields empty.

——————————
Drew Kipfer
EMP Technical Group
——————————
——————————————-