Sales Order prepayment cancellation is applied to wrong ledger account

Hi there. Running D365 F&O and using mPOS (running version 10.0.30 (10.0.1362.150)). We have an issue that I cannot seem to sort out or understand why it is happening. We allow customer prepayments (aka deposits) so they pay for the product in advance and it ships to them later or they can pick it up in-store later. We have a customer posting profile set up and the correct ledger accounts are there when a prepayment is taken we see the transaction flow correctly (note, we do have two posting profiles, one for general payments and one specifically for prepayments). The prepayment hits our Customer A/R ledger correctly, we see the prepayment against that customer account and on their balance, and we see the prepayment shown in the Open Transactions Report from the A/R reporting menu. When the item is picked up or "sold" to their account, the prepayment is consumed and clears the ledger correctly, it clears from their account balance correctly, and it clears off the report correctly.

The issue is when the sales order is canceled for whatever reason (customer changed their mind, the product is no longer available, etc). In the POS the sales order is brought up on screen and canceled and the refund is issued. From the POS perspective, this all happens correctly. We can then see the prepayment clear from the customer account balance as expected. However, the amount is not cleared from the Customer A/R ledger and it remains there, and it remains on the Open Transaction Report (because it's still in the ledger). Instead, the prepayment cancellation hits an A/R clearing account only and I cannot determine how this is happening.

Has anyone else experienced this or know why this might be happening? Unless I am mistaken, there is nowhere I can find where you would configure which account for a prepayment cancellation to apply - it should just go to the account as configured in the posting profile.

Quick Links