web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Based on the Item Ledg...
Small and medium business | Business Central, N...
Answered

Based on the Item Ledger Entries - How to know which is Fast moving and non moving items

(0) ShareShare
ReportReport
Posted on by MANJUNATH DHANAPAL 175

Based on the Item Ledger Entries - How to know which is Fast moving and non moving items 

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    MahGah 15,613 on at

    You need to filter item ledger entry for activities that you want (purchase, sales, consumption, etc) for the date range you want to. Then take it to Excel and do some calculation to determine activities for each item during that time period and that can give you some idea. 

  • MANJUNATH DHANAPAL Profile Picture
    MANJUNATH DHANAPAL 175 on at

    Can you please help me with an example ? I am unable to find it

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,613 on at

    I do my best but it is hard report. 

    Go to Item Ledger Entry and filter it based on your criteria. Then take it to Excel. 

    I Excel for each item you need to calculate a few things 

    1) Add to inventory (purchase / output) of the item during that period. 

    2) Left the inventory ( consumption/sales). 

    Then you can see how many of one item you brought in and how many left the inventory. then sort of determine the slow/fast moving. you can do it for $ or QTY. 

    I hope this help

    pastedimage1639499454081v1.png

  • Ashish0386 Profile Picture
    Ashish0386 75 on at

    On item table there are field Purchase qty, Sales qty , Negative Adjt qty and Positive Adjmt qty you can use these with date filter to find non moving items

  • Suggested answer
    MANJUNATH DHANAPAL Profile Picture
    MANJUNATH DHANAPAL 175 on at

    Thank you. This answered my question

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,613 on at

    Also, you can go to Item List -> Report -> Inventory -> Item Turn Over  and run this report. it should give you some good info. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 649 Super User 2026 Season 1

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 447 Most Valuable Professional

#3
YUN ZHU Profile Picture

YUN ZHU 388 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans