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

Announcements

No record found.

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... / Data relating to items...
Small and medium business | Business Central, N...
Answered

Data relating to items sold

(1) ShareShare
ReportReport
Posted on by CA-01061105-0 30
Hi All. 
 
I would like to extract data relating items sold in a specific time period. For example i want to know how many bicycles we sold between monday 09:00 and 17:00. 
 
I did have a go at the inventory sales statistics report but i can't seem to manage the time filter. 
 
Or maybe i can extract the data from another report?  
 
Many thanks in advance 
 
I have the same question (0)
  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 14,419 User Group Leader on at
    HI,
     
    In Business Central every record has $systemModifiedAt and $SystemCreatedAt. These fields show you when every record is modified and created.
     
    You can filter Item Ledger Entries based on these fields and get relevant data.
     
     
    Regards,
    Saurav Dhyani
  • CA-01061105-0 Profile Picture
    CA-01061105-0 30 on at
    Thank you very much for your feedback.  If i want the data for multiple items how dou suggest i go about doing this?  say i want to know the quantity of items sold for 5 different items between Friday 20:00 and 23:00
  • Verified answer
    Valentin Castravet Profile Picture
    Valentin Castravet 32,528 Super User 2026 Season 1 on at
    In the Item Ledger Entries Page you can use a filter for Entry Type Sale, you can also filter on the Document Type field as well. In the Created At field you would then filter on the specific date/time you are looking for. After that, sum of the quantity column, you can export the page to excel to do this or use analysis mode to view the sum. 
     
     
  • Jun Wang Profile Picture
    Jun Wang 8,212 Moderator on at
    you could filter to the date range, Don't believe you could filer by the hours.
     

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,875 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 926 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 642 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans