Skip to main content
Post a question

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id : F0GhifN/O7k+h/JDIdkvPh
Finance | Project Operations, Human Resources, ...
Suggested answer

Sales Order prepayment cancellation is applied to wrong ledger account

Like (0) ShareShare
ReportReport
Posted on 24 Mar 2023 10:27:36 by

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. 

  • Peter191 Profile Picture
    on 24 Mar 2023 at 10:46:04
    RE: Sales Order prepayment cancellation is applied to wrong ledger account

    Thanks for the quick response. See the images below showing the prepayment and the reversal vouchers.

    pastedimage1679654823385v1.png

     pastedimage1679654842171v2.png

  • Suggested answer
    saurabh bharti Profile Picture
    15,033 Super User 2025 Season 1 on 24 Mar 2023 at 10:33:09
    RE: Sales Order prepayment cancellation is applied to wrong ledger account

    Hi,

    Did you check when the reversal is posted, it just posted in Ledger not in subledger? What is the posting type it is picking when it is reversed. 

    That might be one issue.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,760 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans
Loading complete