Hi all,
Can anyone advice me how to adjust items quantity in stores thru headquater manager? i tried worksheet style 307-adjust quantity items and it solved the matter by adjusting the items quantity one by one but i want to adjust ALL the items quantity in one time to 0 quantity, is this possible ?? advice me plz..
and thanks in advance :)
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,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. ;-(
Have something to add? Share your thoughts — no account required.
Ask the community — no account required