Sales Price Inquiry and Worksheet

🌐 NL · Last reviewed: 27 May 2026

Two screens for daily price work: Sales Price Inquiry (read-only lookup) and Sales Price Worksheet (buffer for batch updates).

From a sales quote or order line, open the action Sales Price Inquiry.
Filter on customer, item, quantity, UoM, variant, and optionally a ship date.
You see the current price, cost, and margin. The page validates against Minimum Margins.

For systematic price changes, work through a buffer:

Open Sales Price Worksheet.
Pick which price records to adjust — filter by customer, price group, date, item, price UoM.
Edit the buffer: Unit Price, Length Surcharge / Discount, Margin Amount / Percentage.
Run Suggest Sales Price on Worksheet to seed proposals from master prices plus surcharges / discounts.
Validate and adjust where needed.
Run Implement Price Change. Only accepted lines get copied into the live Sales Prices table. The Starting Date determines when the new price kicks in.

Field	Purpose
Sales Code Filter	Restricts the buffer to a customer or price group.
Sales Type Filter	Which sales type is loaded.
Starting Date Filter	Supports date expressions (Today, This Week).
Item No. Filter	Restrict items.
Sales Price	New or existing price in the buffer.
Minimum Quantity	Volume tier.
Unit of Measure / Variant	Price basis and optional variant.

Set a regular cadence: monthly pricing round via Suggest Sales Price on Worksheet, review in the worksheet, finalise with Implement Price Change.

The buffer only copies to the live price list after explicit execution of Implement Price Change. Don't skip this step.

Message	Cause
"Cannot edit All Customers records; use specific Sales Type"	You're trying to edit an All-Customers price without the right sales type.
"Starting Date in Campaign prices is read-only"	Campaign dates are managed on the Campaign card.

[Screenshot: Sales Price Worksheet buffer with proposed changes and validation column]