web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Project Advance tax component not settling with the Invoice on deduction

(0) ShareShare
ReportReport
Posted on by 2,097

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.

Categories:
I have the same question (0)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 776 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 606 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 402 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans