We are trying to build a predictive inventory model and was wondering if anyone out here has done this. We know what we want to ship, we have a baseline for po receipts, and we know what jobs need to be run. Does anyone have anything built as a dashboard, baq, or XLConnect file that would help? Thanks.
I don’t think there is anything within Epicor to give you what you want.
I have previously built a SQL stored procedure that runs daily after MRP to calculate inventory levels of components based upon expected PO receipts and job demand for specified number of days into the future )in this case it was 365). The procedure populated a table in a custom schema and SQL views were created to show things like below zero, below 80% minimum, but this depends upon the requirements.
The views were queried via external BAQ’s and dashboards created.
It’s not ideal from a support perspective, mainly due to the upgrade issues if the database model changes, but it still works after three upgrades.
Cheers,
Andrew.
Thanks Andrew. Is there any code that you can share with me? You can email me directly at jimphillips@valcor.com
Sorry Jim - it covered by ip rights.