Date Calculation for Sales

Business Central automatically calculates the earliest possible date that an item on a sales order line can be shipped.

If the customer has requested a specific delivery date, then the date on which the items must be available to pick to meet that delivery date is calculated.

If the customer does not request a specific delivery date, then the date on which the items can be delivered is calculated, starting from the date on which the items are available for picking.

Calculating a Requested Delivery Date

If you specify a requested delivery date on the sales order line, that date becomes the starting point for the following calculations.

  • requested delivery date - shipping time = planned shipment date
  • planned shipment date - outbound whse. handling time = shipment date

If the items are available to pick on the shipment date, then the sales process can continue. Otherwise, a stock-out warning is displayed.

Note

If your process is based on backward calculation, for example, if you use the requested delivery date to get the planned shipment date, we recommend that you use date formulas that have fixed durations, such as "5D" for five days or "1W" for one week. Date formulas without fixed durations, such as "CW" for current week or CM for current month, can result in incorrect date calculations. For more information about date formulas, see Work with Calendar Dates and Times.

Calculating the Earliest Possible Delivery Date

If you do not specify a requested delivery date on the sales order line, or if the requested delivery date cannot be met, then the earliest date on which that the items are available is calculated. That date is then entered in the Shipment Date field on the line, and the date on which you plan to ship the items as well as the date on which they will be delivered to the customer are calculated using the following formulas.

  • shipment date + outbound whse. handling time = planned shipment date
  • planned shipment date + shipping time = planned delivery date

See also

Date Calculation for Purchases
Calculate Order Promising Dates
Work with Business Central