Welcome, Guest. Please Login.
05/18/25 at 04:38:54
News:
Home Help Search Login


Pages: 1
Send Topic Print
Sales Tax won't calculate on a Sales Order invoice (Read 547 times)
fstickel
Browser
*


I love YaBB 1G -
SP1!

Posts: 38
Sales Tax won't calculate on a Sales Order invoice
04/17/07 at 14:27:35
 
I have 3 line items in a sales order, all are the same non-inventory taxable Item.  The first was the original Sales Order amount (over $1million), the second was a minor addition to the sales order, and the third entry was a credit for an amount removed from the original order.  
 
When I go to release the lines, the first line shows taxable Y but no tax is calculated.  When I release the second and third lines, tax is calculated.  Since the third entry is a credit, I end up with the pre-tax sales order as the subtotal and a negative sales tax.
 
Any ideas on why DBA won't calculate the correct sales tax?
 
Thanks in advance for any help.
Back to top
 
 
  IP Logged
RAGINE
Full Member
***


I love YaBB 1G -
SP1!

Posts: 150
Gender: female
Re: Sales Tax won't calculate on a Sales Order inv
Reply #1 - 04/17/07 at 15:43:41
 
It looks like maybe to many numbers to fit in the sales tax area. I don't know how to fix that if thats the problem?
Back to top
 
 

Ragine Hendrickson
Manufacturing Systems Inc/TRU-CATCH TRAPS
ISTECH 2004.1 10/31/06 UPDATE
Email WWW   IP Logged
fstickel
Browser
*


I love YaBB 1G -
SP1!

Posts: 38
Re: Sales Tax won't calculate on a Sales Order inv
Reply #2 - 04/17/07 at 16:42:35
 
I tried breaking the first line into two pieces, both under $1 million, but that didn't make any difference.
Back to top
 
 
  IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: Sales Tax won't calculate on a Sales Order inv
Reply #3 - 04/18/07 at 08:22:10
 
Check the item number to see if it is set as Taxable.  A yes in this field will allow it to be taxed, a no will never add tax even if you say yes to taxable on the sales order.  I believe this is also true for the taxable field in the customer set up.  Although with the customer set to no, I don't think you even get a chance to say yes.
 
Or maybe it can't handle tax on 1/2 a million either.....
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
fstickel
Browser
*


I love YaBB 1G -
SP1!

Posts: 38
Re: Sales Tax won't calculate on a Sales Order inv
Reply #4 - 04/18/07 at 09:57:08
 
All 3 Items are Item Number "OTHERS", a Type N, non-inventory item.  IN-B is set to taxable Y, AR-A for the customer is set to taxable Y.  I've deleted and re-entered these lines several times trying to get this to work.  I have had various results, including sometimes getting the tax calculated on the second and third entries of the Item, and other times getting no tax calculated whatsoever.
 
I will try some other variations to see if there is a field width limitation on the taxable amount and also on whether there is a field width limitation on the sales tax amount.  If  anyone has any other suggestions, I would appreciate hearing them.
Back to top
 
 
  IP Logged
dorner
Browser
*


I love YaBB 1G -
SP1!

Posts: 48
Re: Sales Tax won't calculate on a Sales Order inv
Reply #5 - 04/18/07 at 10:01:55
 
You mentioned that you can see the line items having a "Y" in the tax column.  Also, on the first page of the SO there is a field named "Taxable" which needs to be set to "Y" and a tax code selected in the "BY" field.
 
Mikeb
Back to top
 
 
  IP Logged
fstickel
Browser
*


I love YaBB 1G -
SP1!

Posts: 38
Re: Sales Tax won't calculate on a Sales Order inv
Reply #6 - 04/18/07 at 10:48:41
 
This is really bizarre.  
I changed the price of the first item so that the sales tax would be 99,999.99.  It printed correctly on the Acknowledgment, SO-E screen, and the Invoice.  
I added $0.50 to the price to make the sales price exceed 99,999.99 and it printed correctly on the Acknowledgement, but the SO-E screen showed a 0.00 tax amount when that line item was released, but when I printed the invoice, it was correct.  
Finally, I went back to the original price on the first item.  The Acknowledgement printed correctly, the SO-E screen showed a zero tax amount on that item and showed an incorrect total tax and total amount.  When I printed the Invoice, however, it didn't even show a line for sales tax!  There is no logic to this.
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print