Finance | Project Operations, Human Resources, ...

Delay Direct Delivery Purchase order creation

(1) Share

Report

Posted on by PhillyNJ

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

All responses (2)

Answers (0)

Suggested answer

Kevin Xia Microsoft Employee on at

Like (0)

Report
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:

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.

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.

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 Cal... 294,095 Super User 2025 Season 1 on at

Like (0)

Report

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.

Community site session details

Delay Direct Delivery Purchase order creation

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Jonas ”Jones” Melgaard – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

Delay Direct Delivery Purchase order creation

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Jonas ”Jones” Melgaard – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates