Material shortage report

[Djpejsen]

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

[v-jiascu-msft]

Hi @Djpejsen,

Can you share a dummy sample please?

Best Regards,

Dale

[Djpejsen]

Data modelReport mockup