We need some advice on what would be the best way to manage the restocking process of our consignment inventory.
We have consignment inventory of around 40 items in 10 of our clients, every client is set up as a warehouse in GP and we transfer the products to their warehouses based on an Order Point Quantity that we set in GP for each product/warehouse combination. When our clients report the consumptions, we issue the invoice and replace all consumed products once every week. To set up the OPQ we analyze the monthly sales of each product per warehouse, every three months, to catch up with the demand trends.
For the restocking process we use the PO Generator functionality. We run the transaction weekly for each consignment warehouse and the suggested order quantities (Order Point QTY-On Hand QTY) will be what we'll need to transfer to our clients, but we don't generate the PO, we just print the suggested order and manually type each item in the transfer transaction. The items that could not be fulfilled are included in the PO for the main warehouse (which also has it's OPQ) and this will be the PO that goes to the supplier.
Our problem (besides the manual work that we want to eliminate), is that the PO Generator doesn't always work smoothly. We've seen cases in which it doesn't suggest any PO for a specific warehouse or product line, but when we run an inventory smartlist we realize that the majority of the items are below the OPQ. Given that situation we have lost trust in the functionality and we're seeking for another option.
Please give us any suggestion or thoughts... Thanks in advance!
