Hi,
My client needs to run the item ageing report for a back date, then they compare that with the standard inventory valuation report. There is no issue in running the valuation report for a back date, but an issue arises when the standard item age composition quantity report is run for a back date #-o It does not calculate correct values for age buckets. This is because it considers applied entries until the current date, regardless of the given back date!!!
We have developed a report using item ledger entry and item application entry tables, but that was not so successful..The client urgently needs this report done
and we have tried every possible way..All items should be issued on FIFO basis..
Do you have any suggestions of resolving this issue?? Would appreciate if someone can provide guidance on how to develop this report..
Thanks
Comments
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
Pls clarify how the method used in inventory valuation can be used for the ageing report. According to the client requirement, items should be issued on FIFO basis.
Pls consider the scenario below;
04/01/09- Purchased 100 units
04/30/09- Consumed 50 units
05/01/09- Purchased 50 units
05/20/09- Consumed 10 units
05/30/09- Consumed 10 units
06/01/09- Purchased 20 units
06/30/09- Comsumed 10 units
If the work date is 06/30/09 and the end date is provided as 05/30/09, the item ageing report should calculate the values as follows;
April= 30 (100-50-10-10)
May= 50
If we use the valuation report method, should that provide the above results???
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
Thanks for the reply!!
Does any one have other suggestions to resolve this??
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
hope this helps.
Will be trying this and would let you know whether that solves my issue..
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
Any suggestions would be greatly appreciated!!
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
The U.S version of the item age composition report did not meet the expected results..
The main issue with the standard item age composition report (WW version) is, it does not generate correct values if run for a back date.
Believe most of the experienced have faced the same issue with this report..Would appreciate if anyone can share your knowledge on modifications done to overcome this issue..Or any suggestions for workarounds?
Thanks