Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
1 Balas
1248 Tampilan

New and first installation...  We are setting up our database and have loaded a few hundred products into the products database via Excel import.  I am now ready to set the current stock quantities for each (our on hand quantity), and at the same time, specify which location the stock is in.  I have done this through Inventory > Inventory Adjustments.  I create a new adjustment, specifying one of the store locations (I have set up 100 or so locations), then specify the product and enter the Counted Quantity.  I click 'Apply' and the updated quantity shows correctly.

When I go back to the Kanban products view the On Hand quantity still shows 0.  If I go to the details form for the product, there is no field on the form showing the on hand quantity but the smart button at the top shows 0.  When I click the smart button, the listing that pops up showing a filter for on hand shows 0, but removing this filter to show all internal locations then does show the manually entered quantity.

Is there some relationship or method required to let the system know that the stock manually adjusted to a location is to be considered as on hand?  I have been down another rabbit hole led by documentation that says a putaway rule is needed to set the default location for products - but when trying to create the putaway rule, there are only 4 locations shown from on the store to location - which are like the top-level ones.

All I want to do is to set my stock quantities, where each product is located and how many are on hand.  I would also want to see this quantity at a glance from the products kanban, list and details view.

Appreciate any assistance, thanks.

Avatar
Buang
Penulis Jawaban Terbai

I may have fixed this...  My locations were not set up with parent location path and each individual location.  I had set them up with the \ separator so my locations were like this:  HQ\Stock\Shelf1 without a parent location.  Changing this to parent location HQ\Stock and the location name to Shelf1 allows the separate locations to be seen in the drop-down in putaway rules.  So with the putaway rule in place, stock in this default location shows on hand.

Avatar
Buang

Thank You so much for sharing your finding, I just lost 3 hours with the same problem before I found you :)