Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Sales Order Lines Repo...
Microsoft Dynamics AX (Archived)

Sales Order Lines Report and Sales Order Line Editing

(0) ShareShare
ReportReport
Posted on by Community Member

Step 1, I am trying to find a grid view in AX that shows sales order lines for multiple Customer POs at once, that includes a reference to the sales order number, the customer PO, customer ID, order quantity, order price, quantity delivered, price, etc.

Step 2, We're also trying to find a way to edit every open sales order line for a particular customer. For example, we would like to open all open sales order lines for customer A and cancel item 12345 from their sales orders. We can receive as many as 800 orders from one customer in a day and we need to cancel 10 items off of every sales order. Right now the only way we know to do this is to open each sales order, one by one, and cancel the lines.

*This post is locked for comments

  • ColbyGallagher Profile Picture
    ColbyGallagher 3,666 on at
    RE: Sales Order Lines Report and Sales Order Line Editing

    For 1, yes, as Guy suggests should work. 

    For 2, use the Excel Add-In, pull down SalesLine Table, add SalesLine.SalesQty (the first Quantity), and Line Status.   Use the Add-In Filter (not excel table filters) on your customer and Item Number, Set quantity to 0 and Line Status to cancelled, publish.  

  • Suggested answer
    Guy Terry Profile Picture
    Guy Terry 28,714 Super User 2025 Season 1 on at
    RE: Sales Order Lines Report and Sales Order Line Editing

    Hi George,

    1. The list page at Sales and marketing -> Common -> Sales orders -> Backorder lines shows order lines. You can personalise it to add the missing fields (Customer requisition and Unit price, I think, from your description).

    You have to aware that, because of the purpose it is designed for, it only shows lines which are not fully delivered. You can override it by opening the Advanced filter and modifying it.

    There are also some Inquiries (under 'Order status') in the Sales and marketing module which could be a good basis for your solution.

    2. I can't find a brilliant way to get what you want. I assume you are using Deliver remainder -> Cancel quantity to cancel the lines?

    Try this, it might speed things up a bit.

    Go to the All sales orders list page, and hit 'Edit in Grid'. Filter to show only the customer you want. Move the Edit in Grid form to occupy the left half of your screen. On the 'General' tab, hit 'Line quantity'. Move the 'Line quantity' tab to occupy the right half of your screen.

    When you click on an order on the left, the 'Line quantity' form will update to show the lines for that order. You can use 'Update line' -> 'Deliver remainder' to cancel lines. You can then click on the next order and repeat.

    This works, because the Edit in Grid forms retain a relationship with forms you open from them. The List pages do not. I have not tried AX7, but I imagine this functionality will disappear altogether in that version.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics AX (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 100 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 48

#3
shanawaz davood basha Profile Picture

shanawaz davood basha 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans