Hello,
I need to do the following:
The Item price must be copied to Pricelevel C as back-up. Next the price entered in Pricelevel A must be copied to Item price
Is this possible thrue an SQL statement? I don't have SQL knowledge, so I hope you can help me.
BACKUP FIRST. If at all possible, perform these operations when the store is closed.
In Store Operations:
UPDATE Item SET PriceC = Price
then...
UPDATE Item SET Price = PriceA
If you are in an HQ environment, you'll need a different set of queries.
Tom
Tom,
Thanks, i going to try it tommorow!
Tom,
Why would it be different for HQ?
Because each store can have separate prices, so ItemDynamic would have to be updated somehow. Actually, you would probably want to generate a worksheet to apply the new prices to each store, then let HQ Client & HQ Server take care of propagating the changes. The simple update to the item table would be meaningless in an HQ environment.
Glenn Adams Tiber Creek C> Tom,
Yes, but if you did the SQL you recomended to all of the the Store Ops databases, this would do the trick. Why does it matter to update the price in the HQ database at all?
"Glenn Adams [MVP - Retail Mgmt]" wrote in message news:OMcChF% snipped-for-privacy@TK2MSFTNGP03.phx.gbl...
Have something to add? Share your thoughts — no account required.
Ask the community — no account required