Reply
 
LinkBack Thread Tools Display Modes
Old 05-12-2008, 11:23 PM   #1 (permalink)
Junior Member
 
Join Date: Feb 2008
Posts: 1
gmknz01 is on a distinguished road
Unhappy NZ Tax (GST) calculation not correct

Has anyone had an issue with the way SI5 calculates tax for New Zealand?

Under Setup and Application Settings, I have the Tax Code set to New Zealand and the sales tax box is displaying 12.5% which is the correct tax %. In NZ GST is calculated on both equipment and labour at the same rate.

But when I run my proposals the GST (tax) calculation is incorrect for example

Proposal #1 prints as follows:
Equipment: $17,753.39
Equipment Adjustment: $ 621.41
Misc Parts: $ 621.41
Labour: $ 3703.79
GST: $ 2633.79 (Wrong and should be $2837.50)
Grand Total: $25 333.79 (not correct should be $25537.50)
Looks like it’s using a decimal of 0.1160259 instead of 0.125

Proposal #2 prints as follows:
Equipment: $2897.19
Equipment Adjustment: $ 57.98
Misc Parts: $ 57.98
Labour: $1505.79
GST: $376.64 (Wrong and should be $564.74)
Grand Total: $4895.58 (not correct should be $5083.11)
Looks like it’s using a decimal of 0.0833648 instead of 0.125

Why is it using different deccimal each time?

I have been through each of the products to check if they have the tax box ticked and they all have.

What am I doing wrong? Is there away to check the calculations in the
report settings or something?

Any input is appreciated.

Glen
gmknz01 is offline   Reply With Quote
Old 05-15-2008, 01:19 AM   #2 (permalink)
Rob99
Guest
 
Posts: n/a
Default

Yeah Glen im having the same GST issue, seems like it was ever since D-tools SP3 was installed...

Rob
  Reply With Quote
Old 05-27-2008, 07:35 PM   #3 (permalink)
Program Manager
 
RandyB's Avatar
 
Join Date: Mar 2006
Location: Concord, CA
Posts: 353
RandyB has a reputation beyond reputeRandyB has a reputation beyond reputeRandyB has a reputation beyond reputeRandyB has a reputation beyond reputeRandyB has a reputation beyond reputeRandyB has a reputation beyond reputeRandyB has a reputation beyond reputeRandyB has a reputation beyond reputeRandyB has a reputation beyond reputeRandyB has a reputation beyond reputeRandyB has a reputation beyond repute
Default Probable cause

Guys,

I found a bug in the NZ tax setup in the Navigator that is the likely culprit of this problem. Take a look at this document which describes the problem and the simple solutions. I'm pretty sure this has been around since the intial release of SI5.

http://downloads.d-tools.com/SI5/doc..._tax_setup.htm

Randy Bownds
Program Manager
D-Tools, Inc
RandyB is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to add sales tax to the Installed Price on an item basis Francisco Felix Reports and Reporting Center 6 04-01-2011 08:50 PM
Modify Sales Tax Bug fryeguy Bugs Section 1 07-11-2009 06:16 AM
Use Tax Suggestion Ahtinc Suggestions and Feature Requests 0 09-17-2008 12:11 PM
New Canadian PST? James McDowell General Section 9 05-22-2008 12:18 AM
Tax on - Tax off ASoundintheDesert 'How Do I' Questions 1 11-15-2007 11:48 AM


All times are GMT. The time now is 05:33 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.3.0
D-Tools, Inc.