Hi All,
I'm trying to set up basic inventory management for a retail business that purchases cartons over various units of measure but sell in each. Therefore for ordering they would like to know the sale units they have on hand.
A particular case is Chupa Chup Lollipops, they are sold by each but can be purchased in 500 or 1000 boxes, with each having a different barcode for sales and stocktake.
My first thought was to set up the sale Item as an Inventory Item with Purchase UOM of 1 and call it CC1. This item aligns with the POS systems's SKU and I will decrement it's SOH figure for daily sales per location.
Then add another Item to the with a Purchase UOM of 500 and set CC1 as its parent item, I'll call it CC500
Then add another Item to the with a Purchase UOM of 1000 and set CC1 as its parent item, And call it CC1000.
Then I do some purchases, receiving a unit of both CC500 and CC1000 for a location and then I look at CC1's Inventory it has 0 in stock for that location but the CC500 and CC1000 items have 500 and 1000 on hand respectively.
My question being:
- Is there any setting on items that will allow the on hand to roll up to CC1 from CC500 and CC1000. Ideally in the above scenario the CC1 would have shown 1500 on hand for the location after the 2 purchases of the CC500 and CC1000.
- Is there an alternative item setup that would achieve the desired result, how has the community achieved this?
- I'm happy to write script or workflows to achieve this if no out of the box functionality exists but any tips, tricks or insights would be highly appreciated?
Kind Regards,
Nick Henry