Calculating Line-Item Order Date and Receipt Dates in Dynamics 365 Business Central

In Microsoft Dynamics 365 Business Central, a Purchase Order’s line-item section contains variables to determine the line item’s receipt dates.

Some purchasers, however, are unaware that these variables are also used to calculate the Order Date of the line item.

By deriving the Order Date, the purchaser knows when the order for this item needs to be placed with the vendor.

The Variables

Business Central uses the vendor’s Lead Time Calculation, the line item’s Safety Lead Time, and the Location’s Inbound Whse. Handling Time as variables to derive the following:

· Order Date,

· Planned Receipt Date, and

· Expected Receipt Date.

This is all seen, within this example of a Purchase Order’s line item:

The calculations for the line item are as follows:

· Requested Receipt Date – Lead time Calculation = Order Date

· Lead Time Calculation + Order Date = Planned Receipt Date

· Planned Receipt Date + Inbound Whse. Handling Time + Safety Lead Time = Expected Receipt Date

The line item’s Safety Lead Time isn’t available for display, in the Purchase Order.  But, even if Safety Lead Time is blank in the Item Card, its default calculation is one day.

Setups

Two of these variables are found in the Item Card, while one resides in the Location Card.

This is all seen, within the final three screenshots of this article.

Addendum: Business Central Date Formulas

In Business Central, a week begins on Monday and ends on Sunday.

Contact us for help or more information.