Use Tax Calculation Problem

matias_jaure
Member Posts: 157
We are handling Sales Tax with W1 and we have a problem for Purchases. When we enter a Purchase Invoice for a Fixed Asset, for instance, to which we want to apply USE TAX, then the system debit to the Fixed Asset Account only the base amount (Amount excl. Tax) and debits also an account Consumption tax (Purchases) for the amount calculated for taxes. We had expected the system to debit the whole amount to debit in a single account, that for Fixed Assets.
Nevertheless, the system calculates right the tax amount and applies correctly those accounts that it has to credit.
So the problem is that we would expect the system to capitalize the tax amount in the Fixed Asset account in it does not do it this way. What can be the cause for this problem?
In the image below we have our situation upside and the desire situation downside.
Nevertheless, the system calculates right the tax amount and applies correctly those accounts that it has to credit.
So the problem is that we would expect the system to capitalize the tax amount in the Fixed Asset account in it does not do it this way. What can be the cause for this problem?
In the image below we have our situation upside and the desire situation downside.

0
Comments
-
My guess is that what has happened here is that you have set the item and vendor up for VAT, and used Sales Tax rates. If you need to set up US vendors, you need to use the Sales tax setup tables (318,319,320,321 and 322) I think what you did is you used VAT Posting groups (tables 323, 324 and 325) which are not used for Sales Tax.
Then on the purchase order My guess is that you used FULL VAT which is very different to US USE TAX.
Note that even if you tick the USE TAX box, then unless Sales Tax data is set up, it will ignore this field.
Hope this helps.David Singleton0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions