We are adding a new role (raw material handler) in our manufacturing department. Among other duties, this individual will be tasked with pulling the raw material needed for upcoming production orders and moving that material to a production staging area. In order to streamline this process we are looking for a report that they can use to direct them to the material they need to pull. My initial thought is that the report needs to contain the following information:
- Raw Material Inventory ID
- Qty of material on hand (broken down by Lot/SN & Inventory Location)
- Production Order driving demand
- Demand Qty on Production order
- Work Center on Bill of Material operation that is driving demand.
In a ideal world the report would be sorted by inventory ID with the other information flowing from there, but I am thinking we really need to drive this from the Production orders with released status, and then flow down to the inventory ID, qty, stock location etc.
Does anyone know if a report like this exists already in Acumatica? Has anyone created anything like this? Any feedback would be appreciated.