Update Quantity to ZERO


A

Anna

Hi all,

My customer wanted to update his HQ and SO quantities to zero,
i wrote him a query which was
UPDATE item SET quantity = 0
WHERE quantity <> 0

up to now everything was ok, all quantities in Hq and stores were Zero.
i did also worksheet 501 and 190 and everything was ok too,
but today he came back to me and told me that, the quantities returned back
to the previous records....


Can Anyone help me in that please ?
i keep on facing this problem and i never get a solution for it..
Thanks in advance
 
Ad

Advertisements

R

Rob

At the store levels get them to create a Physical Inventory Count for all
items. Then Calculate and Commit the count with all items still equal to 0.
Once that is done at HQ run your 501 worksheet and upload the new
quantities. Lastly run your Task 190.

Rob
 
A

Anna

Thanks Rob,

physical inventory count, helped me to make the quantities in the store 0
and i did 501,190 in HQ level.

but again when i make workshseet 401 the quantities in HQ goes to the
previous count but in negative -

i can not update the quantities one by one in the HQ cuz it is more than
1000 records..

Tell me What to do please....
 
A

Anna

ooh ok i solved the negative quantity matter..

see what else i found !!!
weird things happening to me
i make inventory physical count
and all quantities show as 0.
but when i make 501 and again 190, in the 190 statement i see items with
huge quantities in the stores
but when i go back to the SO manager i dont even find those items and their
quantities ??!!
Can you please tell me what to do..
i faced this problem with 2 customers of mine..

Thanks in advance.......
 
A

Anna

couldnt anyone help me ?

Anna said:
ooh ok i solved the negative quantity matter..

see what else i found !!!
weird things happening to me
i make inventory physical count
and all quantities show as 0.
but when i make 501 and again 190, in the 190 statement i see items with
huge quantities in the stores
but when i go back to the SO manager i dont even find those items and their
quantities ??!!
Can you please tell me what to do..
i faced this problem with 2 customers of mine..

Thanks in advance.......
 
J

Jeff

Anna,

If you are a RMS reseller, why are you posting here instead of one of the
two or both, RMS reseller newsgroups? One of them even has an real live MS
employee answer your RMS questions!!

Do you always ask your customers (this newsgroup) how to fix your other
customer's problems?



couldnt anyone help me ?
 
Ad

Advertisements

A

Anna

advice me with the link....


Jeff said:
Anna,

If you are a RMS reseller, why are you posting here instead of one of the
two or both, RMS reseller newsgroups? One of them even has an real live MS
employee answer your RMS questions!!

Do you always ask your customers (this newsgroup) how to fix your other
customer's problems?

--
*
Get Secure! - www.microsoft.com/security

You must be using Outlook Express or some other type of newsgroup reader to
see and download the file attachment. If you are not using a reader, follow
the link below to setup Outlook Express. Click on "Open with newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz

**********

couldnt anyone help me ?
 
Ad

Advertisements

J

Jeff

Anna,

For starters, http://tinyurl.com/8mvwy and select PartnerSource on the left.
Once logged into PartnerSource, Solutions on the left and select Retail
Management for lots o' RMS info.

Select Discussions on the left for all 3 newsgroups and info on how to join
them.



advice me with the link....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top