Good afternoon guys, I need to know how can I calculate this field to add it to my own dashboard. (I know that I need to use a calculated field but what fields do I need to use?) Any advice?
I think the filed is: Available to Fulfill. I need to know exactly how much inventory I have to sell.
The PartBin records have fields for the allocated qty’s. Subtract that from the OnHandQty.
Edit: if using PartBin.OnHandQty, you’ll need to sum them up as the part may have QOH in multiple bins.
Another option is the PartPlant or PartWhse (I forget which) which has the total Qohs summed up.
The standard epicor calculation is onhand - allocated.
Does anyone use this one though? Could there be benefits to using this calculation:
Available = on hand - allocated - reserved - picking - picked
