Small and medium business | Business Central, N...

Item Aging Report

(1) Share

Report

Posted on by Community member

Hello,

Is there a report, either in BC or some app in Extension Marketplace that has item aging reports? Currently I am using the Analyze feature on the item ledger entries to do an item ageing by location.

Thanks,

Victor

All responses (8)

Answers (0)

Suggested answer

YUN ZHU 75,802 Super User 2024 Season 2 on at

Like (0)

Report

Item Aging Report

Hi, you can also try the free extensions below.

https://appsource.microsoft.com/en-us/product/dynamics-365-business-central/PUBID.entifyoutechnologiesopcprivatelimited1682039191501%7CAID.inventory_aging_analysis%7CPAPPID.743e0f99-bf66-404b-925b-de2fa8a43c5f?tab=Overview

Hope this helps.

Thanks.

ZHU
Community member 14 on at

Like (0)

Report

Item Aging Report

Thank you everyone for the fast feedback! Looks like we will need to create custom report as these reports have a little of everything but not all.
Suggested answer

T.yahya 109 on at

Like (1)

Report

Item Aging Report

Consult the standard reports mentioned:

Item Age Composition - Quantity

Item Age Composition - Value

These reports display the quantity and value of items based on their age, utilizing the Qty-in-Hand as of the report date.

Also, Check this

https://learn.microsoft.com/en-us/dynamics365/supply-chain/cost-management/inventory-aging-report

You may consider creating a custom report if these reports do not align with your specifications.

This report can be designed to filter the Item Ledger Entry based on the Remaining QTY and posting date, which is the date you received the item. This approach will provide you with the duration each item (with remaining QTY from a specific production order, etc...) has been in inventory.

However, you may also be interested in knowing the last time an item (for that particular production order) was used. To obtain this information, you will need to access the Item Application Entry table (339) and look for inbound and outbound entries to establish the relationship and design your report accordingly.

Hope this will help.

Best regards,
Touil Yahya
Jun Wang 7,440 Super User 2024 Season 2 on at

Like (0)

Report

Item Aging Report

if you explain what the report is used for with example, it will be easier to make recommendations.

Jun Wang
Suggested answer

Valentin Castravet 25,120 Super User 2024 Season 2 on at

Like (0)

Report
Item Aging Report

There are several pages/reports you can use:

Item Age Composition - Value Report

Item Age Composition - Quantity Report

Item Turnover Page

Item Turnover Report

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
Community member 14 on at

Like (0)

Report

Item Aging Report

Thanks for the replies but the aged reports are for vendors and Customers, I need it for items.
T.yahya 109 on at

Like (1)

Report
Item Aging Report

Hi

Check these Two Reports

Aged Accounts Payable

Aged Accounts Receivable

Hope this will help.

Best regards,
Touil Yahya
Suggested answer

Mohamed Amine Mahmoudi 10,479 Super User 2024 Season 2 on at

Like (0)

Report

Item Aging Report

Hi,

Maybe you can refer to the Inventory - Availability Plan report

Best regards,

Mohamed Amine MAHMOUDI