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.
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 related training at Microsoft Learn
Submit and view feedback for