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… 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…
The below scnario will be helpful in understanding the client requirement;
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 quantites as follows;
April= 30 (100-50-10-10)
May= 50
Would appreciate if you can suggest how to resolve this issue asap…Thanks!!!