You’re offline. This is a read only version of the page.
20
Hello all,
We are using the new 'Global withholding tax' functionality which calculates WHT on customer payments. So my scenario is the same I imagine is the same for most companies.
So the customer has an open invoice INV-001 with a balance 100 (just for ease of description there is no sales tax) and there is WHT of 10%. So on customer system, they decide to settle 60 of the outstanding invoice. So their system they enter the 60, and it calculates 6 as WHT and payment amount of 54. So the customer transfers 54 to their suppler bank account. The Supplier has D365 F&O, they see the 54 payment from their customer in the bank account and enters that on a customer payment journal and they are going to settled it against Inv-001.
Is there any way in F&O that 54 can be entered and the system back calculates the settlement amount of 60 with WHT of 6. I have only be able to do it off system where you divide the payment amount by 90 (100-10 %WHT) and multiple the answer by 100, so that in this example I get 60 ((54/90)*100) and I enter that in the 'Amount to settle' in the Settlement screen (via payment journal) and then the 6 and 54 are calculated.
Basically, following the steps that you would do if you were making a vendor payment (which is not how you should have to process customer payments).....
Any suggestions?
Share
Report
All responses (
Answers (
