Hello everyone,
I'm trying to better understand how Base Calendars interact with Sales Date Calculation in Business Central.
According to Microsoft Learn:
- If a Requested Delivery Date is entered, Business Central calculates the dates backwards:
- Requested Delivery Date
- minus Shipping Time
- = Planned Shipment Date
- minus Outbound Whse. Handling Time
- = Shipment Date
Microsoft also explains that Base Calendars are used so that calculated dates fall on working days.
My question is about the following scenario.
Example
- Requested Delivery Date = 26/08/2026 (Wednesday)
- Shipping Time = 2D
- Outbound Whse. Handling Time = 1D
- Company (or applicable) Base Calendar defines Saturday and Sunday as non-working days
Ignoring Base Calendars, the calculation would be:
- 26/08/2026 − 2D = 24/08/2026 (Monday)
- 24/08/2026 − 1D = 23/08/2026 (Sunday)
My question is:
Will Business Central automatically continue moving backwards through the Base Calendar until it reaches the previous working day (i.e. Friday 21/08/2026), or is the behaviour different?
I'm looking for the standard Business Central behaviour (no customisations), ideally verified in a recent BC version.
If possible, could someone confirm this from a sandbox or point me to official Microsoft documentation describing the exact algorithm?
Requested Delivery Date
26 Aug (Wed)
│
├─ Shipping Time = 2D
▼
Planned Shipment Date
24 Aug (Mon)
│
├─ Outbound Whse. Handling = 1D
▼
Shipment Date
23 Aug (Sun) ❓
Should Business Central adjust this to:
22 Aug (Sat) ❌
21 Aug (Fri) ✅
Resources:
https://learn.microsoft.com/en-us/dynamics365/business-central/across-how-to-assign-base-calendars#lead-time-calculation
https://learn.microsoft.com/en-us/dynamics365/business-central/sales-date-calculation-for-sales?source=recommendations
Many thanks!
