Sales Documents Date Price Calculation
The Date Price Calculation field determines which date is used to calculate the sales price.
This setting is validated when creating Sales Documents to ensure compatibility.
This can be setup in 3 different scenarios (from lowest to highest priority):
- Sales & Receivables Setup
- Customer Price Group
- Customer Card
Behavior in Sales Documents
When a sales document is created, the system uses the configured Date Price Calculation to determine which date field will be used to filter and apply the correct price list.
Supported Date Options:
- Order Date / Posting Date
- Shipping Date
- Delivery Date
Exceptions
Blanket Sales Orders
When a Blanket Sales Order is created and the Date Price Calculation is set to Delivery Date, the system will automatically calculate the price based on the Order Date instead.
Sales Return Orders
The same logic applies: if Date Price Calculation is set to Delivery Date, the Order Date is used.
Recurring Sales Lines
If a customer has Recurring Sales Lines configured to be inserted automatically, and a Sales Quote, Sales Order, or Sales Invoice is created with Date Price Calculation set to Delivery Date, the system will likewise use the Order Date for price calculation.
EDI/API Integration
When sales documents are created via EDI or API, the system uses the Order Date for price calculation, regardless of the configured setting.