Pricing Control > Multi-Level Price Update

Managing pricing across a large inventory can be a time-consuming task, especially when multiple pricing tiers are used to accommodate different customer groups, quantities, or discount structures. To streamline this process and ensure consistency throughout your company's pricing strategy, AccountMate Enterprise offers a dedicated tool designed for efficient, large-scale price adjustments.

The Multi-Level Price Update function allows you to update an item's multi-level prices as defined on the Multi-Level Pricing page in its maintenance record. This feature saves time by allowing you to update the multi-level prices of multiple inventory items at once, based on the selection criteria you specify.

This function is available only when the Pricing Control module is installed and activated. To use it, you must first set up multi-level prices for your inventory items.

To update the inventory item’s multi-level prices, perform the following steps:

1.Access the Multi-Level Price Update function from the Pricing group in the Maintenance Menu of the Accounts Receivable or Sales Order module. The Multi-Level Price Update wizard opens automatically with the Selection Criteria as the first screen.

2.In the Currency field, click the List box button to select the specific currency you want to use in updating the multi-level prices.

Note: This field is enabled and accessible only if the Use Multi-Currency feature and the Pricing Control module are activated.

3.In the Price Type field, click the List box button to select the basis for updating the multi-level price of each inventory item you want to update. Choose from the following options:

oList Price + %

Select this option if you want to update each inventory item’s list price based on the current list price in the Pricing page of the item's maintenance record, plus a percentage of the item's list price.

For example: If the list price of an inventory item record is $160.00, the system will update the current list price plus the percentage rate you specify.

oList Price + Amount

Select this option if you want to update each inventory item’s list price based on the current list price in the Pricing page of the item's maintenance record, plus or minus the flat amount you enter in the Update Price By field.

For example: If the list price of an inventory item record is $160.00, the system will update the current list price plus the amount you specify.

oCost Base + %

Select this option if you want to update each inventory item’s cost base based on the cost base amount entered in the Settings page of the item's maintenance record, plus a percentage of the item's cost base.

For example: If the list price of an inventory item record is $160.00, the system will update the current list price plus the percentage rate you specify.

oCost Base + Amount

Select this option if you want to update each inventory item’s cost base which is based on the cost base amount entered in the Settings page of the item's maintenance record, plus the flat amount you specify.

For example: If the list price of an inventory item record is $160.00, the system will update the current cost base plus the amount you specify.

oFixed Amount

Select this option if you want to update the multi-level prices of the selected inventory items by adding an amount to the current multi-level prices.

For example: If you want to update the multi-level prices of inventory items based on their current multi-level prices, you may enter that each inventory item’s new multi-level price will be $20.00 higher than its multi-level price base, which is the inventory item’s current multi-level price. In this case, an inventory item with a current unit price of $150.00 and current multi-level price of $100 will have its multi-level price updated to $120.00 [$100.00 + $20.00].

4.Specify in the Start Date field the date when the updated basic prices will take effect. Accept or amend the default system date.

5.In the selection filters area, enter the parameters that will determine which inventory items are included in the price update. You may accept the default All option or specify a list or range using the From/To fields. You may click the Lookup button to display the Search window where you can select a customer price group, item price group, an item number, or unit of measurement, depending on the filter option you have selected. The available selection filters are as follows:

oCustomer Price Group

Enter the customer price group that the inventory items you want to update belongs to.

oItem Price Group

Enter the price group assigned to the inventory items that you want to update.

oItem #

Enter the numbers of the inventory items for which you want to update the prices.

oU of M

Enter the unit of measurement assigned to the inventory items that you want to update.

6.Click the Next button to proceed. In the Price Formula Input screen, accept or amend the default unit of measurement for the item in the U of M field. A grid appears showing all the customer price group and item price group that match the selection criteria you defined in the previous screen.

7.To specify quantity thresholds for a customer price group, click the field under the customer price group and item price group to display the Quantity Price Break window. See Quantity Price Break topic for more details.

8.If you want to amend or edit any filter criteria in the previous screen, click the Back button. Click Cancel anytime if you want to abort the process and return to the Selection Criteria screen. Click Next to continue.

9.The Review screen shows on a grid all the inventory items that match the selection criteria you entered. It also shows the system-calculated new multi-level prices of your inventory items based on the settings you specified on the previous screen. If you want to amend the new multi-level price of an item, click Back or start over again.

10.Once you are ready to complete the process, click the Finish button. A message will appear asking if you want to perform the process again or if you wish to exit the wizard. Click Perform Again if you want to repeat the whole process and return to the Selection Criteria screen. Click Close to exit the transaction wizard, or click Cancel to close the message box but stay on the Review screen.

Multi-Level Price Update

Multi-Level Price Update

See Also