Small and medium business | Business Central, N...

Planning worksheet dates

(6) Share

Report

Posted on by LF-16052033-0

607

Hello experts,

Is there a way when the planning worksheet is generated or when PO's are created to don't allow purchase order receipt dates to fall on weekends or non-working days?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

Mansi Soni 10,176 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!

Hello,

You can check this once with Base Calendar functionality. Hope it helps you with what you are looking for.

https://learn.microsoft.com/en-gb/dynamics365/business-central/across-how-to-assign-base-calendars

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,800 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!

You'll have to setup a base calendar that specifies weekends as non working days

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 101,995 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi, hope the following helps as well.

https://stoneridgesoftware.com/guide-to-using-dates-in-dynamics-365-business-central/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 17,623 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hello,
yes use Base Calendars: create a calendar where Saturday/Sunday and holidays are marked as Nonworking, then assign it to the Vendor card on the Receiving FastTab and/or the Location card on the Warehouse FastTab; Business Central will use those calendars when calculating purchase/planning dates and will round receipt dates to working days. Important detail: if no vendor/location/company calendar is assigned, BC treats all days as working days, and if the PO line has no Location Code, it may fall back to the company calendar, so make sure the calendar is assigned where your planning actually uses it.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No
Suggested answer

Grigorios Mavrogeorgis 2,514 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hi,

Yes, the answer sits in the Base Calendar setup, not in the Planning Worksheet itself.

Every Vendor and every Location can have a Base Calendar assigned, and on this calendar you mark Saturday, Sunday and the holidays as non-working days. When the Planning Worksheet calculates the Expected Receipt Date, it respects these calendars and shifts the dates to the next working day automatically.

Create a Base Calendar, for example UK-CAL, add recurring entries for Saturday and Sunday, plus the bank holidays. Then assign it on the Vendor card, Receiving tab, and on the Location card. Once this is in place, neither the Planning Worksheet nor manually created Purchase Orders will propose receipt dates on weekends.

If no calendar is assigned, BC treats every day as working day, this is why many companies see Saturday dates without knowing why.

✅ Tick the checkbox below to mark the answer as verified, if it helped resolve your question.

Regards

Gregory Mavrogeorgis

Work: GMSOFT Limited
Blog: Inside Business Central
LinkedIn: www.linkedin.com/in/gregorymavrogeorgis

Was this reply helpful? Yes No
Gerardo Rentería Ga... 27,261 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

D365 Business Central : Calculate Dates Based On Working Days - That NAV Guy

Setup Base Calendars in #MSDynNAV & #MSDyn365bc.

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

AndrewThomas81 2,220 on at

Like (2)

Report
Copy link

Link copied!

You need to consider base calendar setup. You can also create custom calendars for customers/vendors

Kind Regards

Andrew Thomas FCCA MCP
YouTube - Use Business Central
LinkedIn

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 17,024 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

In Business Central, there is no standard feature to strictly block purchase receipt dates from falling on weekends or non-working days; however, you can control this behavior using Base Calendars, where weekends and holidays are defined as non-working and assigned to vendors, locations, or the company—this allows the planning worksheet to consider working days when calculating dates.

That said, users can still manually override dates on purchase orders, so if strict enforcement is required (i.e., never allow weekend dates), it would require a custom validation or auto-adjustment in AL to either block or shift dates to the next working day.

Was this reply helpful? Yes No