Hi All,
I have got a requirement to find the logic of the inventory aging report and replicate the same in fabric. I have debugged code and tried to find the logic it is creating 6(asof, qtyasof, receiptlines period 1..4)queries for calculating the values. I have taken help of ai to write the logic in sql, but I am unable to get the correct values for the inventory aging for all the items. Below is the sql query. Can anyone please help me in understanding this where it is going wrong and implementing it in sql/fabric.
Thank you.

Report
All responses (
Answers (