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.