Hello everyone,
I'm sorry but I just come here for asking a rather "odd" question. Mind if I'm asking how this D365 F&O calculate its inventory aging ? Is there any table dedicated to this ?
I'm actually an external consultant and making a report but with source of this D365 F&O, so not really familiar on how it is operate, but the past months has been work with some of F&O tables.
Back to the issue, I'm given table like InventTrans for the inventory transactions, but it seems this is not the correct table for me to build my inventory aging report.
What I know now is :
- F&O have Physical and Financial date to acknowledge its On-hand.
- By sum all of it, I can get it's total qty in current (the actual On-hand)
But then I can't use those dates since there are some of this are merely a transaction date which maybe just an in and out movement, which in the end the actual qty now is not for that particular date. Like for example : for current On-hand ItemA is 100, there is Financial date of January of 20 then February -20, then March is 50, April 50. So wondering whether there are other table that I can use ? Or mind to share how D365 F&O usually calculate its inventory aging report ?
Thanks,
