To copy override prices to a pricing matrix:You can copy the special pricing of items on the current order into the pricing matrix for the customer. Subsequent orders for the customer continue to use the special pricing overrides specified on the Copy Override Pricing to Matrix screen.
This is useful for customers with a purchasing commitment at your company. For example, many companies offer special pricing to customers who commit to purchase a certain quantity of products over a specified period of time. When this occurs, you can change prices using a pricing override when the first order is placed. Then copy the special override pricing to use as the remaining quantity gets purchased.
To copy override prices to a pricing matrix:
Create or open an order and display the order's Body screen.
Use the Pricing hot key, which opens the Pricing Override screen.
Use the Matrix hot key.
Enter the following field information, as needed:
|
Field |
Description |
|
Copy to |
Specifies whether to use the customer's Bill-To or Ship-To account in the matrix. |
|
Copy All/Dollar/Formula |
Specifies whether to use all overrides in the current order, only the overrides specified in Dollar amounts, or only those in Formula changes. |
|
Force Matrix to |
Specifies whether to use overrides As-Is (with a combination of dollar amounts and formulas), Dollar overrides only, or Formula overrides only. Press F10 for list. |
|
Overwrite Existing |
Indicates whether to override the Price/Cost/COGS overrides in the matrix. If Y (default value) is selected, the system updates the matrix cell and replaces the existing overrides; otherwise, it creates a new cell and copies the Price/Cost/COGS overrides into it. If N is selected, the system creates a new matrix cell and copies the Price/Cost/COGS overrides into it. The overrides information in any existing matrix cells for the branch, customer, and product remains intact. |
|
Copy Costs (Y/N) |
Specifies whether to use override costs, as well as override prices. Not usually needed. |
|
Dflt, Br Specific, Terr |
Specifies whether to use the overrides for this customer and this product at the current branch, the territory, or as the default for all authorized branches. Note: You can enter a territory only if it has the pricing branch as a valid branch. |
|
Expiration Date |
Specifies the date when the override expires. |
|
Expiration Qty |
Specifies the quantity after which the override expires. |
|
Expiration Qty Type |
Specifies the quantity type upon which the expiration quantity is based. Press F10 and select U-Unit, W-Weight, L-Load Factor, or D-Dflt List. |
|
Vendor |
The vendor to which the product and customer override costs in the vendor buy matrix is copied. A field entry is optional; but if a vendor exists, the costs are copied, regardless of Copy Costs (Y/N) setting. Note: When this screen is accessed from Purchase Order entry, this field is not accessible. |
Use a hot key to specify how to copy the override prices:
Use Begin to copy the override to the matrix, without opening the Sell Matrix Maintenance screen, so you can confirm your changes.
Use One Step to open the Sell Matrix Maintenance screen so you can confirm your changes by stepping through them before the override copy is finalized.
Note: The system will not overwrite an existing matrix cell entry that shares the same date range as the override.
See Also: