Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

recalculate order commitment

(0) ShareShare
ReportReport
Posted on by 25

Good afternoon,

Does anyone know how I can reconsider multiple sales lines / orders? When the delivery time has passed or when the purchase order is delayed?

Now I have to run a new ctp per order to generate an overview.

Thanks in advance.

  • jerome77 Profile Picture
    jerome77 on at
    RE: recalculate order commitment

    Hi

    Planning worksheet to manage your demand and needs

    How to Run Full Planning, MPS and MRP - Business Central | Microsoft Docs

    Kind regards

    jerome

  • Enpresa Profile Picture
    Enpresa 25 on at
    RE: recalculate order commitment

    Thanks for your responses.
    I suggested the idea.

    We are a wholesaler / importer, unfortunately we often have to deal with situations at our suppliers. A fixed date is therefore quite difficult. Sometimes it is 10 days and sometimes 20. That is why I want to inform my customer early.

    @Jerome
    What do you mean by planning worksheet?

  • Suggested answer
    jerome77 Profile Picture
    jerome77 on at
    RE: recalculate order commitment

    Hi

    Yes good that Steven shared the link.

    Is it business as usual process here? Maybe to reconsider lead time setup if vendor always late.

    Also if you re ran planning worksheet when late to get new proposal done ?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: recalculate order commitment

    Hello,

    Yes, the idea is a good one. Here is a link to add your idea to the Dynamics Business Central ideas list that everyone can vote on and Microsoft Product Team can see:

    experience.dynamics.com/.../

    Hope this helps.

    Thanks,

    Steve

  • Enpresa Profile Picture
    Enpresa 25 on at
    RE: recalculate order commitment

    Steve,

    Thanks again for your response.
    I think this is strange since you enter all the information on the purchasing side that affects a sales order.

    This would really be an addition to the package. You don't want to manually reconfirm hundreds of orders. Can you send points for improvement somewhere?

    Thanks again. And stay healthy.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: recalculate order commitment

    Hello,

    Ugh! Running ATP or CTP for multiple Sales Orders at the same time is not possible out-of-the-box. In thinking out-of-the-box, maybe an extension, by your Partner, the allows ATP/CTP to run against multiple Sales Order. However, you have to think of the current process and results that come back that you can accept. This needs to be thought out since the process does require accepting the dates to be updated to a Sales Order.

    Hope this helps.

    Thanks,

    Steve

  • Enpresa Profile Picture
    Enpresa 25 on at
    RE: recalculate order commitment

    Good day Steve,

    Thank you for your response.
    I know this method. But I want this for multiple orders at the same time.
    We have hundreds of orders but it is not possible to do this per order. I want this because of a power bi report where the delivery times are stated with the shipping date. When I recalculate a CTP or ATP, new dates are added here.

    Do you happen to know this too?

  • Claus Macali.dk Profile Picture
    Claus Macali.dk 997 on at
    RE: recalculate order commitment

    Thanks Steve, very good

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: recalculate order commitment

    Hello,

    If I am following your question you are looking for a function that looks at Order Promising. In BC, on the Sales Order List or when a Sales Order is open, you can click to Actions/Functions/Order Promising. Here you can use the tools Available-to-Promise or Capable-to-Promise.

    pastedimage1612542555432v1.png pastedimage1612542616174v2.png

    Some information on these tools... 

    The Order Promising functionality enables you to promise an order to be shipped or delivered on a specific date. The date that an item is available to promise or capable to promise is calculated, and order lines are created for those dates that you accept. The functionality calculates the earliest possible date that an item is available for shipment or delivery. It also creates requisition lines, in case the items must first be purchases, for those dates that you accept.

    Business Central uses two fundamental concepts:

    • Available to Promise (ATP)
    • Capable to Promise (CTP)

    Available to Promise

    Available to promise (ATP) calculates dates based on the reservation system. It performs an availability check of the unreserved quantities in inventory with regard to planned production, purchases, transfers, and sales returns. Based on this information, Business Central automatically calculates the delivery date of the customer’s order because the items are available, either in inventory or on planned receipts.

    Capable to Promise

    Capable to promise (CTP) assumes a “what if” scenario, which only applies to item quantities that are not in inventory or on scheduled orders. Based on this scenario, Business Central calculates the earliest date that the item can be available if it is to be produced, purchased, or transferred.

    Example

    If there is an order for 10 pieces, and 6 pieces are available in inventory or on scheduled orders, then the Capable-to-Promise calculation will be based on 4 pieces.

    Calculations

    When Business Central calculates the customer’s delivery date, it performs two tasks:

    • Calculates the earliest delivery date when the customer has not requested a specific delivery date.
    • Verifies if the delivery date requested by the customer or promised to the customer is realistic.

    If the customer does not request a specific delivery date, the shipment date is set to equal the work date, and availability is then based on that date. If the item is in inventory, Business Central calculates forward in time to determine when the order can be delivered. This is accomplished by the following formulas:

    • Shipment Date + Outbound Warehouse Handling Time = Planned Shipment Date
    • Planned Shipment Date + Shipping Time = Planned Delivery Date

    Business Central then verifies if the calculated delivery date is realistic by calculating backward in time to determine when the item must be available to meet the promised date. This is accomplished by the following formulas:

    • Planned Delivery Date - Shipping Time = Planned Shipment Date
    • Planned Shipment Date - Outbound Warehouse Handling = Shipment Date

    The shipment date is used to make the availability check. If the item is available on this date, Business Central confirms that the requested/promised delivery can be met by setting the planned delivery date to equal the requested/promised delivery date. If the item is unavailable, it returns a blank date and the order processor can then use the CTP functionality.

    Based on new dates and times, all related dates are calculated according to the formulas listed earlier in this section. The CTP calculation takes longer but it gives an accurate date when the customer can expect to have the item delivered. The dates that are calculated from CTP are presented in the Planned Delivery Date and Earliest Shipment Date fields on the Order Promising Lines page.

    The order processor finishes the CTP process by accepting the dates. This means that a planning line and a reservation entry are created for the item before the calculated dates to ensure that the order is fulfilled.

    You setup Order Promising on the Order Promising Setup page.

    Hope this helps.

    Thanks,

    Steve

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans