Set Up Base Calendars
In this article
- To set up a base calendar
- Lead Time Calculation
- To customize a calendar
- To assign a base calendar
- See Also
You can assign a base calendar to your company and its business partners, such as customers, vendors, or locations. Delivery and receipt dates on future sales order, purchase order, transfer order, and production order lines are calculated according to the calendar’s specified working days. The main task in setting up a new base calendar is to specify and define the non-working days that you want to apply.
To set up a base calendar
Choose the
icon, enter Base Calendar, and then choose the related link.Choose the New action.
Fill in the Code field.
Choose the Maintain Base Calendar Changes action.
On the Base Calendar Changes page, use the Recurring System field to mark a particular date or day as a recurring nonworking day. You can select either the Annual Recurring or Weekly Recurring option.
If you select Annual Recurring, you must also enter the relevant date in the Date field.
If you select Weekly Recurring, you must also select the relevant day of the week in the Day field. If you leave the field empty, you must fill in the Date field. The Day field is filled in automatically.
When you make an entry, the Nonworking field is selected. You can choose to clear the check mark to make it a working day.
When you return to the base calendar card, you will observe that the nonworking day entries that you made have been updated. These entries now appear in red and the Nonworking field is selected.
Note
When setting up a new base calendar, you can select and copy lines from an existing calendar. You do this in the relevant Base Calendar Changes page.
Important
Any base calendar defined for the vendor or the location affects how the dates are calculated and rounded to working days. Specifies a date formula for the time that it takes to replenish the item. It is used to calculate the Planned Receipt Date field, if calculating forward, and Order Date field, if calculating backwards. See Lead Time Calculation.
Lead Time Calculation
Any base calendar defined for the vendor or the location affects how the dates are calculated and rounded to working days. Accordingly, the two date fields on purchase order lines are calculated as follows under different conditions.
| Calculation Direction | Vendor Calendar Defined | Vendor Calendar Not Defined |
|---|---|---|
| Forward | planned receipt date = order date + vendor lead time (per the vendor calendar and rounded to the next working day in first the vendor calendar and then the location calendar) | planned receipt date = order date + vendor lead time (per the location calendar) |
| Backward | order date = planned receipt date - vendor lead time (per the vendor calendar and rounded to the previous working day in first the vendor calendar and then the location calendar) | order date = planned receipt date - vendor lead time (per the location calendar) |
Note
In addition to the lead time calculation that affects the planned receipt date and order date, as shown in the above table, warehouse handling time and safety lead time may be added to the formulas to make up the value in the Expected Receipt Date field, as follows: Planned Receipt Date + Safety Lead Time + Inbound Warehouse Handling Time = Expected Receipt Date.
Important
If your location uses a significantly different calendar than your vendors do, then it is important that you set up specific calendars for those vendors, to calculate optimal vendor lead times. For information about how to set up vendor calendars, see To assign a base calendar.
The contents of the Lead Time Calculation field is copied from either the item card or the SKU card, if the lead time is defined for the item, or on the Item Vendor Catalog page, if the lead time is defined for the vendor.
To customize a calendar
The main task in customizing a base calendar for your company, or one of its business partners, is to enter any changes to working and nonworking day status.
For example, while a base calendar would typically list all Saturdays as non-working days, the customized calendar for a particular location may list all Saturdays during the months of November and December, and leading up to the holiday season, as working days.
The following procedure uses the case of the location as an example. Note that at this point, you have already assigned a base calendar to the location.
Choose the
icon, enter Locations, and then choose the related link.Open the location that you want to update, and then select the Customized Calendar field. Note that a calendar must be selected in the Base Calendar Code field.
On the Customized Calendar Entries page opens, choose the Maintain Customized Calendar Changes action.
In the Customized Calendar Changes, add lines for customized calendar entries.
When you enter a line, the Nonworking check box is selected. You can clear the check box if you want to change the status to a working day.
You can use the Recurring System field to set a particular date or day as a recurring nonworking day. You can select either the Annual Recurring or Weekly Recurring option.
If you select Annual Recurring, you must also enter the relevant date in the Date field. If you select Weekly Recurring, you must also select the relevant day of the week in the Day field. If you leave the field empty, you must fill in the Date field. The Day field is then filled in automatically. This could be useful if you want to mark an individual date as a nonworking or working day.
Choose the OK button.
On the Customized Calendar Entries page, you will observe that the date entries are updated with the changes that you made.
On the Location card, you will observe that the Customized Calendar field contains Yes, indicating that a customized calendar has been set up.
Important
If you do not fill in the Location Code field on an order line, your company’s calendar is used.
If you do not fill in the Shipping Agent Code field on the order line, your company’s calendar is used.
Note
If you make changes to a base calendar for which customized calendar changes exist, all existing customized calendars are updated automatically.
To assign a base calendar
The following procedure schedules delivery dates on sales order lines for a customer as an example.
Base calendars are assigned to your own company, customers, vendors, locations, and shipping agents as follows:
- On the Company Information and Customer cards, the base calendar is assigned on the Shipping FastTab.
- On the Vendor card, the base calendar is assigned on the Receiving FastTab.
- On the Location card, the base calendar is assigned on the Warehouse FastTab.
- On the Shipping Agents page, the base calendar is assigned on the Shipping Agent Services page.
- Choose the icon, enter Customers, and then choose the related link.
- Open the Customer card for whom you will assign a base calendar.
- On the Shipping FastTab, in the Base Calendar Code field, select the base calendar that you want to assign.
Important
- If you do not assign a base calendar to a company, all dates are calculated as working days.
- If you enter a blank location on an order line, all dates are calculated as working days.
- Any base calendar defined for the vendor or the location affects how the dates are calculated and rounded to working days.
Note
Before you can make customized calendar entries, you must first assign a base calendar to the company.
See Also
Related Articles
Set Up Email
In this article Requirements Add Email Accounts Use SMTP Use the Set Up Email assisted setup guideShow 10 more Note Azure Active Directory is now Microsoft Entra ID. Learn more People in businesses send information and documents, such as sales and ...Company information overview
In this article Working with multiple companies Display a company badge Change company display name Experience See also Business Central organizes business entities in companies. For each company, you must fill in some of the basic company details ...Create Number Series
In this article Gaps in Number Series Behavior of the No. field on documents and cards To create a new number series To create relationships between number seriesShow 2 more For each company that you set up, you need to assign unique identification ...Set up email
Note Azure Active Directory is now Microsoft Entra ID. Learn more People in businesses send information and documents, such as sales and purchase orders and invoices, by email every day. Administrators can connect one or more email accounts to ...Walkthrough: Set up and use a purchase approval workflow
You can automate the process of approving new or changed records, such as documents, journal lines, and customer cards, by creating workflows with steps for the approvals in question. Before you create approval workflows, you must set up an approver ...