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

Announcements

No record found.

News and Announcements icon
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,334

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)
  • Giorgio Bonacorsi Profile Picture
    1,572 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
  • Verified answer
    MYGz Profile Picture
    2,334 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.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 545 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 408

#3
Adis Profile Picture

Adis 267 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans