Item Ageing Report

Business Central/NAV Developers Forum
1

Hi,

My requirement is to get the Item Ageing report as per the actual bucket . I know there is a standard report Item Age Composition - Value, and quantity, but the problem with this report is that it runs as per the current date. i.e based on Remaining quantity.

But what i want is too see the actual ageing similar to AR/AP.

Example :- If increase for month of march is 100 and out of this 100 i have a decrease of say 20 then whenever i run a report with ending date as 31st Match then it should 80 as balance in that bucket .

Currently working on modifying the Item Age Composition - Value report by taking Item application entry table as dataitem.

Just require your suggestion , if there is other to generate the report.

Regards,

Faisal Bukhari

2

We have designed that .

3

Thanks a lot.

Regards,

Faisal Bukhari

4

Hi,

I am also going through the same difficulties with the standard reports. (Report 5807 and 5808). Once the transfer order is raised, the aging is incorrect. Can you please share the object?

Thanks in advance.