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

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Sales Tax, Maximum Amo...
Microsoft Dynamics NAV (Archived)
Answered

Sales Tax, Maximum Amount/Qty. CONSISTENT function message

(0) ShareShare
ReportReport
Posted on by John Bellinger 834

I’ve these tax details;

Tax Jurisdiction Code

Tax Group Code

Tax Type

Effective Date

Tax Below Maximum

Maximum Amount/Qty.

Tax Above Maximum

Expense/Capitalize

GA

MATERIALS

Sales and Use Tax

1/1/2015

6.00

0.00

0.00

FALSE

GAATLANTA

MATERIALS

Sales and Use Tax

0.00

0.00

0.00

FALSE

GAFULTON

MATERIALS

Sales and Use Tax

1/1/2015

1.50

5,000.00

0.00

FALSE

 

Assigned to this Area Code;

ATLANTA, GA

If I create a one line sales order, type G/L Account, qty. 1, unit price 5074.25, tax liable = true, tax area code ATLANTA, GA, tax group code Materials, and try to ship/post, I get the message “The transaction cannot be completed because it will cause inconsistencies in the G/L Entry table. Check where and how the CONSISTENT function …”

Yet, if I change my one sales line to 5074.24, the transaction posts as expected.

Seems to be a bug?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,280 Super User 2026 Season 1 on at

    An issue fixed in CU 4 for the below scenario, not sure if it applies to you.

    363253 The posting of a sales order as Invoiced generates an inconsistency error when using the Excise Tax feature with tax on tax due to an issue with rounding of the calculated tax amount in the North American version.

    Codeunit 398 is updated, worth getting this version and try again.

  • Verified answer
    John Bellinger Profile Picture
    John Bellinger 834 on at

    With the help of my VAR, we got this response from Microsoft;

    I replicated the issue and this appears to be a tax rounding issue. The issue would seem to be that the US Country Tax Area Code controls Rounding. Each Line in the Statistics is rounded individually by Tax Jurisdiction, so it appears that the issue is that the Sales Order line properly rounds the tax based on the total for the Tax Area Code, but the Statistics show each line rounded for each Tax Jurisdiction. On the Tax Area Code, when I have Round Tax set 'To Nearest' the tax amount for tax jurisdiction GA is 304.455. The tax amount for GAFULTON is 75.00. The Sales Order shows 379.45 worth of sales tax while Statistics shows 379.46, a penny difference. If I change the Round Tax to 'Down' or 'Up', we no longer run into the Inconsistency error.
    I am not sure how often the user runs into this so another workaround is to invoke the Tax Difference functionality by entering a Max Tax Difference of say 1.00 in General Ledger Setup and enable the Allow Tax Difference in Sales & Receivables Setup. Then, manually override the Tax Amount on the Tax Jurisdiction line in the Statistics to force rounding so that the Statistics and Lines show the same value for certain.
    One thing I would like you to check is if the following bug fix is applied to Codeunit 398. This was a bug that was triggered in NAV 2015 and looking at the version the customer is on they may not have it applied. Here is the bug:
    Bug 375560 "Sales Tax Rates with small decimal percentages results in a difference in calculated amount on the Sales Lines from what shows in Sales Statistics".
    CODEUNIT 398 - Sales Tax Calculate


    Bug 375560 did not impact my specific scenario.  However this suggestion;

    If I change the Round Tax to 'Down' or 'Up', we no longer run into the Inconsistency error.


    Will work for me.

    Thank you for your response.

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

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans