Order Date Field, Purchase Line Table

Specifies the date when the item is ordered. It is calculated backwards from the Planned Receipt Date field in combination with the Lead Time Calculation field.

Any base calendar defined for the vendor or the location affects how the date is calculated and rounded to working days.

The two key 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)

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
Planned Receipt Date
Lead Time Calculation

Other Resources

How to: Set Up Base Calendars
How to: Assign Base Calendars
Item Vendor Catalog
Lead Time Calculation