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 :
Small and medium business | Business Central, N...
Answered

Non-deductible VAT Amount isnt recalculated when direct unit cost excl VAT is updated to 0

(1) ShareShare
ReportReport
Posted on by 313
Hello, 
 
I have a purchase order that needs to be archived. The PO is for qty = 9, it has been fully receipted, but only 1 has been invoiced. As qty received> qty invoiced, the system will not allow me to delete the PO so I've thought about creating a manual invoice, get the receipt lines, update the direct unit cost to 0, post the invoice and then PO will be fully receipted and fully invoiced and we'll be able to delete it . I have created a manual invoiced and then used the Get receipted line to get the remaining 8, see screenshot below
 
 
Now, I have removed the direct unit cost excluding VAT, PO value is 0. However, the non-deductible vat amount is not recalculated and it's stopping me from posting the invoice as I'm getting this message "The transaction cannot be completed because it will cause inconsistencies in the G/L Entry table. Check where and how the CONSISTENT function is used in the transaction to find the reason for the error".

Does anyone know why and how to fix it?
 
Thanks
 
Alejandra
I have the same question (0)
  • Verified answer
    Stafa365 Profile Picture
    11 on at
    Hello, 
     
    After editing direct unit cost try to update or delete value from the VAT Product Posting Group for that line. I think that the calculation of the non-vat amt field is done when you modify the VAT product group on lines.
     
    Greetings

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,796 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 965 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 664 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans