Hey Raheel - We had this same scenario. We elected to create a charge code that posts to the appropriate tax ledger and customer account. We would post this charge code when a EDI order with sales tax was processed. We set the order with a new sales tax code that would not calculate sales tax (again).
This allowed us to match the prepaid order accordingly.
------------------------------
Johnny Ingram
Recreational Group
Dalton GA
------------------------------
Original Message:
Sent: Jan 24, 2023 05:53 PM
From: Raheel Rao
Subject: Handling Sales Tax Amount Updates for Prepaid Orders
Hi all,
I am looking into a scenario where suppose an ecom sales order came with a sales tax $3 however at the time of fulfilment, due to origin change for the shipment the new tax calculated is different then amount paid by the customer towards tax. For this example the updated calculated tax now is $2. In this case I would like to be able to get a report of orders with all those differences and be able to refund back customer if there was an over-payment of tax. If it was just a matter of tax over ride where actual tax would different the calculated tax, I could have easily used the Posted Sales Tax report.
Also, this would not be an issue if I was just authorizing the payment on a credit card and capturing the updated amount. In this scenario, the payments are already captured or pre-paid.
Anyone else in direct to consumer space with D365 ran into this scenario? If yes, how did you handle it especially from reporting point of view?
Let me know please.
Thanks,
Raheel