Welcome, Guest. Please Login.
05/24/25 at 14:33:52
News:
Home Help Search Login


Pages: 1
Send Topic Print
Global change to Taxable field (Read 533 times)
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Global change to Taxable field
10/02/09 at 09:53:00
 
Accounting occasionally runs into an issue where  they are not allowed to tax a customer invoice because one or  more of the items on the SO were flagged as "taxable=N" in  EVO.  Is there a utility we can run to change the default to all items as "taxable= Y"?  This would obviously be much faster than going through each item one by one.  
 
Am I correct in that if we have the customer set correctly in AR, if they are set to tax exempt then even if the item is tagged taxable they won't be taxed?
 
Can anyone also tell me what would be some of the problems we could run into making this change?  
  
Back to top
 
 

Val Feehan
  IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1517
Gender: male
Re: Global change to Taxable field
Reply #1 - 10/02/09 at 10:10:34
 
You could use the Pervasive Control Center to run a SQL query or two...
 
starting with
 
SELECT bkic_prod_code FROM BKICMSTR WHERE bkic_prod_txble = 'N'#
 
which would give you a list of all items with this setting set to no. Mine reported "(13527 row(s) affected)"
 
You could then run  
 
UPDATE BKICMSTR SET bkic_prod_txble = 'Y'#
 
which would set them all to yes.  
 
Easy peasy  Wink
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Global change to Taxable field
Reply #2 - 10/02/09 at 19:11:26
 
UT-K-B on BKICMSTR, field BKIC.PROD.TXBLE replace N with Y will do it.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: Global change to Taxable field
Reply #3 - 10/06/09 at 13:15:30
 
Thanks, Lynn and Colin!  Appreciate the help with this one.
 
Val
Back to top
 
 

Val Feehan
  IP Logged
Pages: 1
Send Topic Print