Lead Time Calculation Field, Purchase Line Table
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.
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. For more information, see 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 How to: Assign Base Calendars.
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 in the Item Vendor Catalog window, if the lead time is defined for the vendor.
Tip
For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.
Parent Tables
Table | Location |
---|---|
Attached to Line No. Field, Purchase Line Table | Purchases and Payables |
Purchase Line Table | Purchases and Payables |
Purchase Line Table | Purchases and Payables |
See Also
Reference
Purchase Order
Order Date
Planned Receipt Date
Other Resources
How to: Set Up Base Calendars
How to: Assign Base Calendars
Item Vendor Catalog
Lead Time Calculation