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!

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Waed Ayyad 9,042 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

NikolajSorensen 1,792 on at

Like (1)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No