1. Home
  2. Point-Of-Sale Software
  3. SQL to mak all items TAX and CODE 128A

SQL to mak all items TAX and CODE 128A

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.

Reply to
geokar
Loading thread data ...

geokar,

formatting link
SO Manager | Wizards | Task 170 Assign Sales Tax

Must have access to CustomerSource

Reply to
Jeff

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:

Reply to
Jocelyn

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.