Hi, I have seen this before, but cannot find it now. I need a query to make all items Code 128A and also need to set all items as TAX (taxable). Thanks for your help.
SQL to mak all items TAX and CODE 128A
Jun 21, 2006
2 Replies
geokar,
formatting link
SO Manager | Wizards | Task 170 Assign Sales Tax
Must have access to CustomerSource
I know half of what you need to update your Barcode format. You will need to find out what position number Barcode Format 128A is, my query is for Barcode format 128C, thus a different number.
Once you know the number associated with Barcode 128A, you should backup your database before executing.
UPDATE Item SET BarcodeFormat = 'x'
Note: 'x' equals the number associated with the particular barcode. For our example of using barcode format 128C, that query would read:
UPDATE Item SET BarcodeFormat = '8'
Maybe you could ask someone on here what the number is, but, I am not really sure what you technically refer to that number as.
Jocelyn
"geokar" wrote:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required