Small and medium business | Business Central, N...

Sales Tax difference on Posting and Invoice

(4) Share

Report

Posted on by Ramiz

597

I am trying to post an invoice with Sales Tax in Spanish version of Business Central. The sales tax is getting calculated correctly on the Invoice but when I try to post it, it gives an error on the Tax Amount .

Tax Amount on Invoice = 1071.43 which is correct and on posting the system calculates it 1756.13 which is without Maximum Amount/Qty from Tax.

The sales tax amount for the TXA2409.8747 Tax Area Code and the STMB Tax Group Code is incorrect. The calculated sales tax amount is -1.756,13, but was supposed to be -1.071,43.

What I have figured it out so far is that, on posting the invoice the system is not considering the Maximum Amount/Qty of Tax and applying it on the full TaxBaseAmount

Tax Details

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Sort by

KasparsSemjonovs 4,821 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

For the 7% tax You don't have any Maximum amount provided..

I would suggest, to experiment a bit - and try to change all of those involved tax percentages to 0, and then put them back one by one, and try to do Preview Posting after each. That way you will now for sure if one of these are setup wrongly, or the problem is in totally different area of setups.

Was this reply helpful? Yes No
Ramiz 597 on at

Like (1)

Report
Copy link

Link copied!

7% tax is 0 because I want to apply it to the whole amount but the rest needs to be applied on specific amount as per US Taxes.

I tried different hit and try and it worked if I put 0 in Tax Maximum Amount/Qty of 2.75% Taxes but its wrong becasue it will be posting more Tax amount in the system.

Also, whats strange for me when I release the Sales Invoice it calculates the sales tax correctly but only when I am posting it the error appears.

Upon debugging it, I found this condition is always true in Sales Tax calculate codeunit.

Was this reply helpful? Yes No
KasparsSemjonovs 4,821 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

TaxLiable I think is a checkmark on each document, and is coming from Customer/Vendor card.
If this has to be False, then just take this checkmark out of customer card (and from the prepared document).

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,421 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello,

Thanks for the detailed explanation and the screenshot — that’s very helpful.

From what you’ve described, it seems the issue arises because the Maximum Amount/Quantity setting for the tax is not being respected during posting, even though it appears correctly on the invoice preview.

Here are a few things to check:

Tax Jurisdiction Setup: Ensure that the Maximum Tax Amount or Maximum Taxable Base is correctly configured in the Tax Jurisdiction or Tax Area setup for the TXA2409.8747 code.

Posting Setup: Sometimes, the posting logic bypasses certain validations or limits if the tax calculation method is inconsistent between the invoice calculation and the posting routine.

Localization Layer: Since this is the Spanish version, verify if there are any localization-specific extensions or updates that might affect tax behavior during posting.

Rounding or Calculation Method: Check if the rounding precision or calculation method differs between the invoice and posting stages.

If the issue persists, it might be worth raising a support ticket with Microsoft, especially if this is a regression or a known issue in version updates.

Let me know if this helps!

Was this response helpful? Feel free to mark it as such or reply with more details if needed.

Best regards,
Daniele

Was this reply helpful? Yes No