Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Sales Tax on Posting groups instead of the invoice - Why?
Josetxo
Member Posts: 92
Hello,
we are using a 4.01 spanish database, on which we have set the Sales Tax for the US.
It is working good, but we have this problem. We have an invoice on which Florida State and Miami Sales tax are applied.
The sales tax in Florida is like this (6%):
Tax Jurisdiction Code Tax Group Code Tax Type Effective Date Tax Below Maximum Maximum Amount/Qty. Tax Above Maximum
FLORIDA TAXABLE Sales Tax 01/01/09 6,000 0,00 6,000
The Sales Tax in Miami is like this (1% for the first 5.000$, 0% for the rest):
Tax Jurisdiction Code Tax Group Code Tax Type Effective Date Tax Below Maximum Maximum Amount/Qty. Tax Above Maximum
MIAMI TAXABLE Sales Tax 01/01/09 1,000 5.000,00 0,000
This should apply this tax for the whole invoice, am I right? So if the invoice exceeds 5.000$, only the first 5.000$ are taxed.
But when we try to post the invoice, NAV shows an error message that says "The Sales Tax for the FL-MIAMI Tax Area Code and the TAXABLE Tax Group Code is incorrect. The calculated sales tax amount is -204,6, but was supposed to be -177,57".
We have commented the lines that control this message in codeunits 398 and 12, in a test database to track the error. It seems that it is not applying the Maximum / Minimum criteria for the whole invoice: it is doing it on the Gen.Prod. posting groups!!
So if the posting group subtotal is less than 5000$, it applies a 7% on it (6 % for FL and 1 % for Miami).
How can we post this invoice? Is the Sales Tax setup incorrect?
Many thanks in advance,
Josetxo
we are using a 4.01 spanish database, on which we have set the Sales Tax for the US.
It is working good, but we have this problem. We have an invoice on which Florida State and Miami Sales tax are applied.
The sales tax in Florida is like this (6%):
Tax Jurisdiction Code Tax Group Code Tax Type Effective Date Tax Below Maximum Maximum Amount/Qty. Tax Above Maximum
FLORIDA TAXABLE Sales Tax 01/01/09 6,000 0,00 6,000
The Sales Tax in Miami is like this (1% for the first 5.000$, 0% for the rest):
Tax Jurisdiction Code Tax Group Code Tax Type Effective Date Tax Below Maximum Maximum Amount/Qty. Tax Above Maximum
MIAMI TAXABLE Sales Tax 01/01/09 1,000 5.000,00 0,000
This should apply this tax for the whole invoice, am I right? So if the invoice exceeds 5.000$, only the first 5.000$ are taxed.
But when we try to post the invoice, NAV shows an error message that says "The Sales Tax for the FL-MIAMI Tax Area Code and the TAXABLE Tax Group Code is incorrect. The calculated sales tax amount is -204,6, but was supposed to be -177,57".
We have commented the lines that control this message in codeunits 398 and 12, in a test database to track the error. It seems that it is not applying the Maximum / Minimum criteria for the whole invoice: it is doing it on the Gen.Prod. posting groups!!
So if the posting group subtotal is less than 5000$, it applies a 7% on it (6 % for FL and 1 % for Miami).
How can we post this invoice? Is the Sales Tax setup incorrect?
Many thanks in advance,
Josetxo
0
Comments
We have set it up like this:
Tax Jurisdiction Code Tax Group Code Tax Type Effective Date Tax Below Maximum Maximum Amount/Qty. Tax Above Maximum
MIAMI TAXABLE Sales Tax 01/01/09 1,000 5.000,00 0,000
Is there something else to be done with this kind of tax? Any help on this will be highly appreciated.
Many thanks in advance,
Josetxo