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 |
---|---|
Sales Order No. Field, 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