Calculate Dates for Purchases
If you want to have items in inventory on a certain date, Business Central can automatically calculate the date on which you must order them.
The result is the date on which you can pick the items that you ordered.
If you specify a requested receipt date on a purchase order line, the calculated order date is the date on which you must place the order. The date on which the items will be available for picking displays in the Expected Receipt Date field.
If you don't specify a requested receipt date, the date you expect to receive the items is based on order date on the line.
The receipt date is also the date when the items will be available for picking.
Tip
By default, many of the date fields this article mentions are hidden on purchase order lines. If a field isn't available, you can add it by personalizing the page. For more information, see Personalize Your Workspace.
Calculating with a requested receipt date
If there's a requested receipt date on the purchase order line, that date is the basis for the following calculations:
- requested receipt date - lead time calculation = order date
- requested receipt date + inbound whse. handling time + safety lead time = expected receipt date
If you specify a requested receipt date on a purchase order line, that date is assigned to new lines as you create them. You can change or remove the date on the lines.
Note
If your process is based on backward calculation, for example, if you use the requested receipt date to get the order 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 without a requested receipt date
If you enter a purchase order line without a requested receipt date, the Order Date field on the line shows the date in the Order Date field on the purchase order header. This date is either the date you entered or the work date. The dates are then calculated for the purchase order line, with the order date as the starting point, as follows:
- order date + lead time calculation = planned receipt date
- planned receipt date + inbound whse. handling time + safety lead time = expected receipt date
If you change the order date on the line, Business Central recalculates the other dates.
Default values for lead time calculation
Business Central uses the date formula in the Lead Time Calculation field on the purchase order line to calculate the order and expected receipt dates.
You can manually specify the date formula on lines. Otherwise, Business Central will use the formulas that are defined on the following pages in this order of priority:
- Item/Vendor Catalog
- Item Card
- Stockkeeping Unit Card
- Vendor Card
See also
Related Articles
Create Recurring Purchase Lines
In this article Set up recurring purchase lines Assign recurring purchase lines to a vendor Insert recurring purchase lines on a purchase invoice See also If you often need to create purchase lines with similar information, you can set up standard ...Various dates on Purchase Documents
Setting up Item Purchase prices (VIDEO)
How to set up item purchase prices in Business Central? VIDEO: Setting up Item Purchase prices Item purchase prices in Business Central can be set up either on the items, or from the vendors. So first of all, let’s look on the items and we take an ...Process Purchase Returns or Cancellations
In this article Inventory Costing To create a purchase credit memo from a posted purchase invoice To create a purchase credit memo by copying a posted purchase invoice To create a purchase return order based on one or more posted purchase ...Various Vendor & Purchase Reports
Standard Business Central provides a number of reports that can present Vendor related analysis. Below are some of them mentioned. Tips In most reports it's possible to apply filters to limit what is included in the report output. Some reports does ...