B Creative Solutions

This appendix contains these topics:

B.1 Rounding to the Nearest Whole Dollar

First adjustment is a formula set up as UPRC/10000.

Second adjustment is set up to multiply the net price by 1,000,000 percent (Basis Code 2).

For example: Base price is $8.41.

8.41 / 10,000 = .0008

.0008 * 1,000,000% = $8.00

When you set up the second adjustment to multiply the net price by 1 million percent, the 1 appears truncated on the Adjustment Detail video (P4072). The display only accommodates 000,000.0000, though the system recognizes the number in it's entirety.

B.2 Restricting Items from Sale from a Group of Customers

  1. Set up complex groups for customers and/or items.

  2. Make the 1st adjustment a zero value adjustment.

  3. Identify the item and customer groups in the adjustment definition, which don't write to sales order, and make it a mandatory adjustment.

Note:

When a customer orders an item that is not in the customer's group, the system displays a hard error message stating that a mandatory adjustment may occur.

B.3 Adjusting an Override Price

Based on the hierarchy of price retrieval, if you override a price in the sales order detail, the price override flag is set and no adjustments affect the price. However, you can set up an advanced price adjustment that allows you to override the price inside the adjustment and then subsequent adjustments takes affect.

The first adjustment is an override price that allows changes - the definition has Override Price (Y/N) set to Y, and Manual Add/Change (Y/N) set to Y. The adjustment detail has basis 5, Add On Amount, with factor 0.

The subsequent adjustments are Basis 2, percent of Net Price.

When you enter the sales order with this schedule, the price displays as zero. From Sales Order Entry (P4211), enter 11 in the Option field to go to the Price Adjustment window (P4074W). The first adjustment shows a zero price - you can override this price with your override price, and enter a valid reason code, and press F6. The subsequent adjustments recalculate based on this price.