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 / Finance | Project Operations, Human Resources, ... / Sales order lines extr...
Finance | Project Operations, Human Resources, ...
Answered

Sales order lines extraction

(1) ShareShare
ReportReport
Posted on by Elodie Baudin 137
Hello,
 
I would like to make an extraction from Data Management in D365 of all of the sales order lines (invoiced, delivered, opened and canceled).
 
But we have too much lines so the Data Management takes too much times (several days) and I'm afraid of slowing the environment for users.
 
I tried some filters in the Data Management (Date, line status...) but it doesn't work. 
Here is the error message :
 
 
Is there any other solution to extract all of the sales order lines? 
 
Many thanks in advance for your help 
I have the same question (0)
  • Anthony Blake Profile Picture
    Anthony Blake 3,181 Super User 2026 Season 1 on at
    Hi,
     
    What kind of Volumes of sales order lines are you looking at here? Can you DB refresh a Sandbox and run a count in SQL?
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 306,250 Super User 2026 Season 1 on at
    H Elodie,

    What is the purpose of extracting all sales order lines? In case you need something for reporting, have you considered exporting to a data lake using Synapse link or OneLake via the Fabric link? That will incrementally export inserted, changed, and deleted data after an initial sync.
  • Verified answer
    Elodie Baudin Profile Picture
    Elodie Baudin 137 on at
    Hello, 
     
    Thank you for your help, my colleagues have succedeed to have these sales order lines. 

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 414 Super User 2026 Season 1

#2
Subra Profile Picture

Subra 352

#3
Martin Dráb Profile Picture

Martin Dráb 275 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans