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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Revearsal of prepayment invoice with VAT

(2) ShareShare
ReportReport
Posted on by 16
  1. We have done a PO for example-001 for amount 3000/-plu Tax 10% 3300/-
  2. We have defined prepayment- 3300 with Tax.
  3. we have done prepayment invoices 1 - 1000+10% tax 1100
  4. we have done prepayment invoice 2- 1000+10% tax=1100
  5. we have  paid (vendor payment journal) for prepayment invoice 1-1100
  6. we have paid (vendor payment journal) for prepayment invoice 2-1100
  7. we have done prepayment invoice 3 for 500 + tax=550.
  8. Now we have done GRNs for PO, and we want to post standard vendor invoice- without completing the remaining prepayment invoice (550) and payment for prepayment invoice 3 (550)
  9. we are not able to post the standard invoice as system is showing an error.
  10. we are not able to remove the prepayment as well due to same error.
  11. the error is linked to VAT (Tax) GL.
  12. Below is the screen shot of error
  13. Now posting standard invoice - system is throwing the same error- whether we apply prepayment or remove prepayment.

     

Categories:
I have the same question (0)
  • Suggested answer
    SajeedMullaji Profile Picture
    500 on at

    @CU22080533-4 
    The VAT GL error is caused by a subledger tax imbalance — Prepayment Invoice 3 was posted to the GL and VAT books but never paid or applied, so when you try to post the standard invoice the tax engine cannot reconcile the outstanding prepayment liability. You cannot directly reverse a PO-linked prepayment invoice once tax distributions are locked by the procurement lifecycle.

    Exact resolution — 4 steps:

    Step 1 — Post a corrective Vendor Credit Note for Prepayment Invoice 3
    Create a negative invoice or vendor credit note for 500 + 50 tax — use the exact same tax code and posting profile as the original prepayment invoice. This offsets the VAT GL entry that was posted but never settled.

    Step 2 — Settle the credit note against Prepayment Invoice 3
    Go to Accounts payable > Vendors > All vendors > select the vendor > Transactions — locate Prepayment Invoice 3 and the credit note — click Settle transactions — mark both and update. This clears the open balance and neutralizes the unpaid prepayment liability and its tax impact.

    Step 3 — Adjust the prepayment on the PO
    Open the Purchase Order > Prepayment fasttab — confirm the prepayment configuration now reflects only what was actually paid — Invoices 1 and 2 totalling 2000 + 200 tax.

    Step 4 — Post the standard vendor invoice
    On the invoice posting form click Prepayment > Select prepayments — explicitly select Prepayment Invoice 1 and Prepayment Invoice 2 only — leave Prepayment Invoice 3 out. The VAT engine will now calculate the remaining net tax balance correctly and the standard invoice will post without error.

    If it helps , mark as answered.

  • CU22080533-4 Profile Picture
    16 on at

    Thanks for reply, its really helpful, for the credit note for prepayment invoice-3 -it will still remain open  for application. as system will treat this as a payment settlement only.

    How will I close this.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

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

#1
SajeedMullaji Profile Picture

SajeedMullaji 494

#2
Martin Dráb Profile Picture

Martin Dráb 291 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 267 Super User 2026 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans