News and Announcements icon

Dynamics 365 CommunityForums Finance forum Sales order lines extr...

Finance forum

Answered

Sales order lines extraction

(1) Share

Report

Report

Posted on by Elodie Baudin

114

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

Categories:

Dynamics 365 Administration

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

Elodie Baudin 114 on at

Like (0)

Report

Sales order lines extraction

Hello,

Thank you for your help, my colleagues have succedeed to have these sales order lines.
André Arnaud de Cal... 290,537 Super User 2024 Season 2 on at

Like (0)

Report

Sales order lines extraction

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.
Anthony Blake 1,963 Super User 2024 Season 2 on at

Like (0)

Report

Sales order lines extraction

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?

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2

Martin Dráb 228,520 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans