Level Pricing Output

Although Level pricing data does not appear on any STORIS report, you can use Design Enhanced Laser Forms (Design Laser Printer Forms) and/or Create a Report (Query Wizard Builder) to access the data points and include them in your reports and other documents. For example, if you want your customers to see level pricing discounts on sales documents, you can use the Forms Designer to create the forms.

 The system does not consider level pricing adjustments (made via the Base Level and Multiplier fields in the Pricing Level Control Table) to be discounts. Level pricing calculations modify selling prices before they are added to sales order, so only the results appear on sales documents. Customers do not see the calculations.

In the Forms Designer, you can include any or all of the following data points for Discount 1 and Discount 2. Discount 1 references discounts applied via Level Pricing or Twilight Pricing, Discount 2 references discounts applied via line item discounts on sales orders. The Discount 2 start price includes calculations from Discount 1 (if present).

Data Field

Description

line_discount1_start_price

pre-discounted price

line_discount1_code

code of discount 1

line_discount1_description

description of discount 1

line_discount1_percent

discount percent of discount 1

line_discount1_amount

amount of discount 1

line_discount1_net_price

net selling price (initial price - discount 1 amount)