Finance | Project Operations, Human Resources, ...

Creating and Excel that compiles a list of all items in every Sales Order

(1) Share

Report

Posted on by KT-16051809-0

Hello,

I am working in D365 F&O.

I want to be able to download an excel file that contains all of the products contained in every open sales order.

When I go to Sales and Marketing > Sales Order > All Sales Orders, I can only see the list of sales orders. Where should I go next in order to comple the items from each sales order into one excel document?

Many thanks!

All responses (2)

Answers (0)

Suggested answer

NikolajSorensen 1,755 on at

Like (1)

Report

Creating and Excel that compiles a list of all items in every Sales Order

Isn't the "Open sales order lines" form what you are looking for? Shows all open lines and can be opened in excel using the standard entities, where you can then filter on the lines status?
Suggested answer

Waed Ayyad 7,963 Super User 2025 Season 1 on at

Like (0)

Report

Creating and Excel that compiles a list of all items in every Sales Order

Hi,

What do you want to achieve? do you want to add new excel button to return specific data?

Check the below link, it maybe helps you:

https://community.dynamics.com/blogs/post/?postid=473c3e9d-98dd-4c49-bde1-b9af8090293c

Thanks,
Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue