Notifications
Announcements
No record found.
*This post is locked for comments
Hi,
I think there is no standard report available that gives you this information. However you can query the inventtrans to obtain the last purchase date for each item and calculate the time (days/months etc) (up to systemdate) if the item also has an inventsum record. At some customers of mine I have created a function that queries the inventtrans for the last purchase date and writes the found date to the inventtable. Secondly I adjust the report physical inventory per itemgroup and add a new field to the report to show the number of days (report date -/- last purchase date). This information can be used to calculate slow/obsolete inventory.
I hope to have pointed you in the right direction.
Kind regards,
Dennis
This is exactly what I want. We want to know how long slow moving items has stayed in the store/warehouse.
Do you have codes/scripts that I could use or build upon?
Another thing, please what is the relationship between inventtrans and inventtable?
You mentioned something about writing to an inventtable.
Thank youin advance
The itemid is the relationship between inventtable and inventtrans. Again to create the function and the report is customization. I cannot give code but can point you in the right direction.
Now each item has the last receipt date on the item master.
Now use the InventdimPhys report to add an extra columns which should print the age bucket, the percentage of provision and provision amount. I use the inventory report by inventory dimension so the report can be used to specify per site/warehouse etc. Please note that the category is based on Item level (not per inventdim).
Hopefully you can create this or have this created.
I was wondering if somebody can share the results. I think it is quite basic report missing in AX and I also would like to have it.
J.
Hi denis,
We are trying to use Business intelligence function in dynamics to create the report. We have created the report using the last purchase date of items. The issue we have now is if the report is based on last purchase date it means some products will not be properly aged. For instance is we bought 500 units of a particular item on 3rd of November and we have not fully sold before the next batch arrives yesterday, does it mean if an age report is ran today all the item will have one day as age considering the fact that we are using phisical date for this report. We are not using the batch neither the serial number dimension. How can we separate same item with different receipt dates.
HI Dare,
the solution I suggested is based on the last purchase (based on DatePhysical or DateFinancial) of all inventory transactions of an item. I assume that if an item is purchased recently there probably was a need for it and therefore the entire stock quantity of that particular is supposed to be from a moving item (why purchase if you have already enough stock). So my solution does not calculate the age per incoming purchase batch.
If you really have the need to calculate the age per item/batch than you would need to use the batch inventory dimension. In this case you would still need a function to calculate the last receipt/purchase date but now per bartch and store this value into the Inventbatchtable (new field).
Another element for such reporting calculation is ItemId > ItemGroup > Inventory model group. Different inventory model settings, such as FIFO or LIFO, might lead to different reporting results.
What is wrong with these standard reports?
Stock Management - Reports - Status - Stock by Item Group Ageing Report or Stock by Stock Dimension Ageing report.
Hi there,
AX Inventory Ageing report is using the 1st transaction date to calculate the stock ageing, which will be issue when we upload inventory balance during go-live data migrating.
To use stock date of birth(Manufacturing date) to calculate stock ageing, i have modified InventoryReport_Age class to get stock manufacturing date from Inventbatch table, and set to be InventTrans.datefinancial. In this way, report will show the correct aging and meet my company's stock ageing report requirement.
JX
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
