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

Notifications

Announcements

Community site session details

Community site session details

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

Project Advance tax component not settling with the Invoice on deduction

(4) ShareShare
ReportReport
Posted on by 2,259

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.

Prepayment Voucher.png
Invoice voucher.jpg
Categories:
I have the same question (0)
  • Verified answer
    MYGz Profile Picture
    2,259 on at
     
    Find Below:
     
    I'm using standard USMF 10.0.45
     
     
    Finally! Was able to work it out the numbers and tax part. Checked and changed a few things but what I remember fixed it was setting up item sales tax group in setup parameters.
  • Giorgio Bonacorsi Profile Picture
    1,031 on at
    Hello,

    Could you please share a screenshot of your Project group configuration? I’d like to run some tests.
    It looks like we’re hitting the Balance sheet (B&S) instead of the Profit & Loss (P&L).

    Thank you,
    Giorgio

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

News and Announcements

Season of Giving Solutions is Here!

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
Abhilash Warrier Profile Picture

Abhilash Warrier 843 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

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

#3
Martin Dráb Profile Picture

Martin Dráb 338 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans