Setting Item Tax and barcode type on items

If you can find out the values for the ItemTax ID and the barcode type you want to use, you could use the following SQL script substituting the values in the declared variables.

DECLARE @BarcodeType int

DECLARE @ItemTaxID int

/*Change the variables below*/

SET @BarcodeType = 0 --The type of the barcode

SET @ItemTaxID = 0 --The ID of the ItemTax

/*Leave code below this line alone*/

UPDATE ITEM

SET BarcodeFormat = @BarcodeType

TaxID = @ItemTaxID

Keep in mind this will update all items, if you need to filter on some criteria you will have to add a where clause to this.

As with all SQL Queries, please make sure you do a backup before running this script. This script is provided as is and used at your own risk.

Thanks for the response,

Here is what I entered in the query window in Administrator

DECLARE @BarcodeType int DECLARE @ItemTaxID int SET @BarcodeType = 3 SET @ItemTaxID = T UPDATE ITEM SET BarcodeFormat = @BarcodeType SET TaxID = @ItemTaxID

However, I got this result:

An error occured while executing query:

Incorrect syntax near '='

"Phil V" wrote:

hi Phil, Well with the below you can also use the Direct Method as I can see no use of these varialble, however if you still want then you can use it by the way the correct method is:

DECLARE @BarcodeType int DECLARE @ItemTaxID int SET @BarcodeType = 3 SET @ItemTaxID = 0 -- wrong above you specify the variable type to int but you entered as character UPDATE ITEM SET BarcodeFormat = @BarcodeType , -- comma was missing TaxID = @ItemTaxID -- YOu specify two set whereas it require one set statement.

Direct method without the variable:

UPDATE ITEM SET BarcodeFormat = 1, TaxID = 0

Rate please. "Phil V" wrote:

I have a case with microsoft on a problem the wizard in the RMS Manager producing the error "Run-time error '457': This key is already associated with an element of this collection." on Task 170: Assign item sales tax.

So if I can run a script to change the tax id for the database items that would greatly help, but I have never used a SQL script before. Do I understand you correctly that if I wanted to change the Taxid=0, all I would have to do is type "SET TaxId = 0" , is this correct?

"Akber Alwani" wrote:

Yes you are right. the T and F flag means 1 and 0 these are the off set use in bascially programs to eavlaute true and false , however when running the update you wont do with SET TaxId = T instead SEt TaxId = 0 which is the correct.

Thanks

"akpetsh> I have a case with microsoft on a problem the wizard in the RMS Manager

I was able to use this to update all the items, but there are some items that need to not charge sales tax. Is there a way to add a filter to this command that would only apply to a certain supplier or Department?

Thank-you > Yes you are right. the T and F flag means 1 and 0 these are the off set use

hi, yes youc an limit by supplier or department, i am giving you below an example:

UPDATE ITEM SET TaxID = 0 WHERE SUPPLIERID=XX -- What if you not know the ID but the code then apply below:

UPDATE ITEM SET TAxId=0 WHERE SupplierID IN (Select ID From Supplier where CODE='DATUM')

UPDATE ITEM SET TaxID = 0 WHERE DepartmentID=XX -- Now here how do you know the ID and suppose you perfer to go with code of deparmtment then apply below:

UPDATE ITEM SET TAXID=0 WHERE DepartmentID > I was able to use this to update all the items, but there are some items that