Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Delay Direct Delivery Purchase order creation

Posted on by 77
Hi - 90% of our orders we create in F&O are Direct Delivery. When a Sales Line is created, the Purchase order is automatically created (or updated) at the /same time/. This is not an issue with an order that has 2 lines, however we have many orders that are over 100 lines. In our Tier 2 environment, this takes up to 12 minutes to place these orders. The orders are created via X++, ODATA and Entities. In our Tier 5 environment, it takes about 8 minutes. Both are way too long.
 
When we create the sales order with 100 stocked items the speed is significantly better. It would seem creating and updating the Purchase Orders takes up most of the time.
 
My question; is it possible to delay Direct Delivery Purchase orders to be created till after the Sales Order is confirmed?
 
Thanks in advance
 
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Delay Direct Delivery Purchase order creation
    Hi,

    if the current performance impact is a concern, you might want to consider optimizing the process. Here are some suggestions:

    1. Batch Processing:

      Instead of creating or updating each Purchase Order line immediately upon Sales Order line creation, consider implementing a batch processing mechanism. Accumulate the changes and process them in bulk at specific intervals. This can significantly reduce the overhead of creating/updating multiple Purchase Orders.
    2. Async Processing:

      Explore asynchronous processing options. You could initiate the Purchase Order creation/update in the background after the Sales Order is confirmed. This way, the user experience during Sales Order creation is not affected.
    3. Optimize Code and Queries:

      Review the X++ code, ODATA calls, and entities involved in the creation/update process. Optimize the code and ensure that the queries are efficient. Inefficient code or queries can contribute to slower processing times.
    Best regards,
    Kevin
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,900 Super User 2024 Season 2 on at
    Delay Direct Delivery Purchase order creation
    Hi PhillyNJ,
     
    You can use the Trace Parser to check what exactly is consuming the majority of time. Maybe it would be possible to speed up the process if you find the culprit. I don't have an environment running, but I thought you can first confirm the SO and then create direct delivery orders.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans