Adjusting invenmtory quantities

Posted by John G on January 26, 2006, 1:48 pm

Please log in for more thread options

Can this be done in HQ item properties? If so, does the corrected info get to
the store by the 401 worksheet or does something else have to be done? Thanks
for any input

John G at the Tradewinds Shops

Posted by Glenn Adams [MVP - Retail Mgmt on January 26, 2006, 3:29 pm

Please log in for more thread options

On hand quantity is really store data. You can run a worksheet to adjust
item quantities for a store ( 3xx - I forget the exact worksheet type), but
normal proceedure is to run a Physical Inventory at the STORE, then request
a 501 for that store, and finally use Inventory task 190 at HQ to reconcile
the Store and HQ quantities. In theory, the store has the most correct data
for local quantity...

--
--
Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information

> Can this be done in HQ item properties? If so, does the corrected info get

> to

> the store by the 401 worksheet or does something else have to be done?

> Thanks

> for any input

> John G at the Tradewinds Shops

Posted by Jeff on January 26, 2006, 5:34 pm

Please log in for more thread options

Glenn and John G,

According to Todd last week on the private ng, there is no longer a need to
run a 501 and 190 as he claims the 401 takes care of it.

--
*
On hand quantity is really store data. You can run a worksheet to adjust
item quantities for a store ( 3xx - I forget the exact worksheet type), but
normal proceedure is to run a Physical Inventory at the STORE, then request
a 501 for that store, and finally use Inventory task 190 at HQ to reconcile
the Store and HQ quantities. In theory, the store has the most correct data
for local quantity...

--
--
Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information

> Can this be done in HQ item properties? If so, does the corrected info get

> to

> the store by the 401 worksheet or does something else have to be done?

> Thanks

> for any input

> John G at the Tradewinds Shops

Posted by John G on January 27, 2006, 1:56 pm

Please log in for more thread options

Thanks Glen, I understand what you are saying and that is the way we normally
do it. But one of our store managers accessed HQ checked store quantities in
HQ and noticed that the Quantity box was white an appeared to accept manual
changes in HQ. She asked if the program allowed this in HQ which is why I
posted. I agree the best source is the store but at the same time I didn't
know why the RMS program seemed to allow this and why the box wasn't grayed
out.
--
John G at the Tradewinds Shops

"Glenn Adams [MVP - Retail Mgmt]" wrote:

> On hand quantity is really store data. You can run a worksheet to adjust

> item quantities for a store ( 3xx - I forget the exact worksheet type), but

> normal proceedure is to run a Physical Inventory at the STORE, then request

> a 501 for that store, and finally use Inventory task 190 at HQ to reconcile

> the Store and HQ quantities. In theory, the store has the most correct data

> for local quantity...

> --

> Glenn Adams

> Tiber Creek Consulting

> http://www.tibercreek.com

> glenn@tibercreek.com

> ----------------------------------------------

> Please DO NOT respond to me directly but post all responses here in the

> newsgroup so that all can share the information

> > Can this be done in HQ item properties? If so, does the corrected info get

> > to

> > the store by the 401 worksheet or does something else have to be done?

> > Thanks

> > for any input

> >

> > John G at the Tradewinds Shops