I have had a request from the business to alter the Sales Order Pick List report to include the part demand next to the on hand quantity.
I have been looking into this and though that the simplest way would be to bring the PartWhse table into the report and use the demand qty from there. The problem is that, as the name of the table suggests, this only shows the demand at the warehouse level. Is there a way to actually get the demand at the bin level? I am suspecting this is likely to be way to complicated but if anyone has any ideas?
If you think about when you raise a sales order, when you add a part to the line it gives you the On hand Quantity and the quantity available. (i.e. On hand less demand qty).
When you print the sales order pick list it gives you the locations for the part, by warehouse and bin and displays the on hand quantity.
The team in the factory have asked that the sales order pick list report should reflect the quantity available on this report. The problem is that to identify the qty available you need to subtract the demand from the on hand qty. As far as I can tell, the demand is only available at the warehouse level int he PartWhse table. I think I could potentially get this data from the PartDtl table and joining it to the various jobs / orders etc. maybe?
logically Demand is for all warehouses there by you can not subtract demand from each warehouse On Hand, the right logic is to subtract the total demand from the total on hand qty
PartBin does contain 2 columns related to allocated qty, the issue is that you have to allocate/reserve inventory to show a demand on the bin. I believe this happens through sales order entry or possibly with AMM. Probably other ways too.
Thanks for the replies, and for confirming what I thought, always worth asking the question though! For what it’s worth EPICOR does separate the demand by warehouse:
Although I understand that this is not always 100% reliable and sometimes needs to be refreshed with the Refresh Part Quantities and Allocations process.
Any, I will feed back my findings to the factory ans see how they want to proceed.
