Hi Guys
Is it possIble to make an inventory shortage report based on a data model with 3 tables
1. BOM items transactions. [ item Id, transaction date, Warehouse code, required quantity ]
2. Inventory Onhand snap shot [ Item Id, Onhand quantity per warehouse, Warehouse code]
3. Date table [Date, ISO week number, Month, Year, etc.]
Allocate onhand inventory for each BOM Item by FIFO principle
I would like to have an overview, when a BOM item have a shortage, based on transactions date and Onhand inventory for each item Id, in the BOM items transactions.
I would like to aggregate the inventory shortage quantity, per Date or per ISO Week, or per Month.
Regards Jan