Quantity Adjustment

Abba,

Normally you would have the store update HQ as they should be more accurate.

Process a 190 and then a 501.

:S

190 ??? i d> Abba,

190 is not a Worksheet but an Inventory Wizard Task. In HQ Manager go into Maintenance Mode, then go to the Wizard menu --> Inventory Wizard, from the drop down list choose Task 190.

Rob

Anna,

Sorry for the confusion as it was a long day.

I had the order wrong, you should do a 501 first and then a 190. The 501 sends a request for the stores to send their inventory levels to HQ and then the 190 reconciles the HQ database as to what the stores say they have. If the stores info is wrong, then HQ will be wrong too. Have the stores do an inventory count before sending.

As Rob mentioned, the 190 is a wizard and not a worksheet.

Thank u all for ur helps but i found a better and easier idea to adjust quantity. Go to HQ admin

-new query and type down:

UPDATE item SET quantity = 0 WHERE quantity 0

"Jeff" wrote:

Anna,

I'm curious, why do you think setting the HQ quantity to 0 is more accurate that what the stores _really_ have in stock?

Why don't you just set it to 526 instead? That's just as inaccurate. ;-(