Skip to main content

Notifications

Announcements

Forum Structure Changes Coming Soon!
Give Back to the Community this Month
News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Sales Tax difference o...
Business Central forum
Unanswered

Sales Tax difference on Posting and Invoice

(1) ShareShare
ReportReport
Posted on by Ramiz 275
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

  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,812 Super User 2024 Season 2 on at
    Sales Tax difference on Posting and Invoice
    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).
  • Ramiz Profile Picture
    Ramiz 275 on at
    Sales Tax difference on Posting and Invoice
    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. 

  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,812 Super User 2024 Season 2 on at
    Sales Tax difference on Posting and Invoice
    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.

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

Forum Structure Changes Coming Soon!
Give Back to the Community this Month

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Replay: Dynamics 365 Community Call ERP Edition | October 9, 2024

Another great gathering of our Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,129 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans