Item Type Query

My customer would like to change the item type in the item property from one type to another for all his items. What is the query statement I need to type in the SO Admin. Thank you very much

Reply to
normbest
Loading thread data ...

Reply to
convoluted

This customer is a discount grocery/dollar store. He does not sell Gasoline. He would like to change all items from Gasoline to Standard because of the receipt problem. He wanted to use the gasoline because it gives him the ability to do the three digits after the decimal which is needed for quantity discount such as 3 for $5 with out creating the mix and match since he only has one flavor for most of his items and it would be too much work to create mix and match for hundreds of items. He will still create mix and match for some items such as 2L Pepsi products. Reading one of the Microsoft document it suggested using item type Gasoline to give him the 3 digits ability after the decimal. The problem is at the pos when a purchase is made for example on something that is set in the item property to $1.99 each and with quantity of 3 is setup for $1.666 using the quantity discount so that it come up to $5.00 at the pos. When a purchase of quantity 3 of that item is made the amount does come up to $5 total at the pos screen but when the receipt prints it shows total of $5.01 instead of $5 even though it tenders fully for $5 Is there a way to make the receipt print correctly when using the Gasoline type items and setting up quantity discounts from the item property? So the customer does not have to change to standard. He would rather keep the Gasoline type so he can setup the quantity discount to sell more products and increase his profits. Thank you

Reply to
normbest

Reply to
normbest

Hi normbest...sorry, been offline for a few days....

the standard itemtype is zero....

Here is your update query, BACKUP YOUR DATABASE FIRST, in case you need to revert back to the original database, also suggest you try after hours so you can do any testing necessary; the following query will set ALL of your items to STANDARD

UPDATE ITEM SET ITEMTYPE = 0

H> Convoluted

Reply to
convoluted

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.