Notifications
Announcements
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
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.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 843 Super User 2025 Season 2
André Arnaud de Cal... 467 Super User 2025 Season 2
Martin Dráb 338 Most Valuable Professional