Question Status

Suggested Answer
Janey asked a question on 21 Nov 2012 3:17 AM

Can anyone offer any insight into Inventory Aging reports for Dynamics AX 2009?

The standard reports don't seem to give what you might expect for inventory aging requirements e.g serial / batch number (if appropriate), FIFO, quantity, value, within one report. 

Inventory by item group aging report, is only of limited value in this instance as it displays inventory value / levels within a given period, but no batch / serial option

I would be interested to hear of any suggested customisation / workaround done in this area?

 

Reply
Janey responded on 21 Nov 2012 3:18 AM

Also, apologies for my bad spelling of Aging!

Reply
mm123 responded on 21 Nov 2012 8:36 AM

Janey,

We have done a similar customization for our client, please drop an email to learn more.

nj.tech@hotmail.com

Reply
Ricardo Lara responded on 23 Aug 2013 4:18 PM

Hi,

We recently changed the costing method in the company from Average to FIFO, and now I have a request for developing an Inventory Aging report. Could you point me in the right direction on how to do this?

Thanks

Reply
Suggested Answer
Robert Mohammed responded on 26 Aug 2013 5:54 AM

I have had to design an SSRS report (using Visual Studio 2008 BIDS) to age inventory with age buckets from 1 mth to over 2 years.

You are correct. The standard AX2009 report is not very useful.

RM

Reply
Suggested Answer
magic1949 responded on 26 Aug 2013 7:04 AM

ABC anaysis can also tell you a lot about slow moving inventory.

Another approach might be to run the min max proposal and extract that data - the proposed min max is based on the  history for the selected data range.

if inventory has a shelf life/fashion life then there is functionality in process manufacturimg you can use

if an item has no expiry/shelf life data then arguably  its age is really irrelevant and only its future sales potential matters

-

Comemercail options:

An inventory turns report maybe more useful than an aging report - we can provide

Llook at BI4 Dynamics the in built aging reports for AR, AP and inventory are very good.

(We have also developed in Ax some inquiry screens for comparison of various order tpes s for both quanity and value and actual and % differences etc for any two specified periods - but this is chargeable.- we can also supply BI4 Dynamics which i think is excpeitonal value.)

Reply
Suggested Answer
Robert Mohammed responded on 26 Aug 2013 5:54 AM

I have had to design an SSRS report (using Visual Studio 2008 BIDS) to age inventory with age buckets from 1 mth to over 2 years.

You are correct. The standard AX2009 report is not very useful.

RM

Reply
Suggested Answer
magic1949 responded on 26 Aug 2013 7:04 AM

ABC anaysis can also tell you a lot about slow moving inventory.

Another approach might be to run the min max proposal and extract that data - the proposed min max is based on the  history for the selected data range.

if inventory has a shelf life/fashion life then there is functionality in process manufacturimg you can use

if an item has no expiry/shelf life data then arguably  its age is really irrelevant and only its future sales potential matters

-

Comemercail options:

An inventory turns report maybe more useful than an aging report - we can provide

Llook at BI4 Dynamics the in built aging reports for AR, AP and inventory are very good.

(We have also developed in Ax some inquiry screens for comparison of various order tpes s for both quanity and value and actual and % differences etc for any two specified periods - but this is chargeable.- we can also supply BI4 Dynamics which i think is excpeitonal value.)

Reply