In a fixed price project I collected 55 USD as advance [50 Advance amount + 5 Tax Amount (10% Tax)]
Voucher below:
Prepayment Voucher.jpg
https://pasteboard.co/5VPJojPIUZhe.png
Now I create an on account transaction of 100 USD (with 10% Tax) so Total invoice Amount = 110 USD
In the invoice proposal when I settle the Advance Amount I get the follow calculation:
100 + 10 (10%Tax on 100) - 50 (Prepaid Amount)= 60 USD
Voucher below:
Invoice voucher.jpg
https://pasteboard.co/FO1joRDlZmo0.png
So now Accounts Receivable is debited with 60 + 55 = 115 USD but it should have been debited only 110 which is the total invoice value. The problem is during invoice + advance application, instead of deducting 50 first and then applying tax on only 50 it is applying tax on 100 and then deducting 50.
Is there any setup to control this behaviour? I want the advance with Tax Amount not without it.


Report
All responses (
Answers (