ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> System Manager >> Global change to Taxable field
http://www.istechforum.com/YaBB.pl?num=1254502380

Message started by gtladmin on 10/02/09 at 09:53:00

Title: Global change to Taxable field
Post by gtladmin on 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?

Title: Re: Global change to Taxable field
Post by GasGiant on 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 ;)

Title: Re: Global change to Taxable field
Post by Lynn_Pantic on 10/02/09 at 19:11:26

UT-K-B on BKICMSTR, field BKIC.PROD.TXBLE replace N with Y will do it.

Title: Re: Global change to Taxable field
Post by gtladmin on 10/06/09 at 13:15:30

Thanks, Lynn and Colin! Appreciate the help with this one.

Val