web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Item Age Composition

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

Unanswered

Item Age Composition

(1) Share

Report

Report

Posted on by SM-06031357-0

2

Hi

when you run an Item age composition-Quantity report in BC it considers all entry types in it, which includes transfer orders. The TOs are only moving the stock from one location to another without actually changing the ageing, is there a way to exclude this entry type on this report, or if there is an alternate report.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Aziz Skhiri 103 on at

Like (0)

Report
Copy link

Link copied!

Hello , Unfortunately, the standard Item Age Composition - Quantity report in Business Central includes transfer orders (which reset the aging to the transfer date), and there's no built-in filter to exclude them.

A common workaround is to customize the report (ID 5807) in AL code to skip Entry Type = Transfer (or trace back to the original inbound date via applied-from entries). If that's not an option, export the Item Ledger Entries to Excel/Power BI, filter out transfers (Entry Type <> Transfer), and build your own aging buckets based on original receipt dates.

There's also an open idea on Microsoft for better handling of transfers in aging reports: https://experience.dynamics.com/ideas/idea?ideaid=bae26031-0aa4-ef11-95f5-0022485288a6

Hope that helps! 😊

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,964 Super User 2026 Season 1

#2

Dhiren Nagar 1,086 Super User 2026 Season 1

#3

YUN ZHU 1,039 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans