Mass-Update of Sales Prices: General Information

Every once in a while, you might need to update sales prices of your stock and non-stock items. MYOB Advanced provides you with the ability to recalculate the existing sales prices in bulk by using specific criteria.

Learning Objectives

You will learn how to recalculate existing sales prices based on the manufacturer's suggested retail price (MSRP).

Applicable Scenarios

By using sales price worksheets, you can bulk-calculate prices of any types, except for default prices—that is, base prices, prices specific to a customer or customer price class, including sales prices that have been marked as promotional, or that have been defined for a particular unit of measure or a particular warehouse.

Price Basis

Your company may use a cost-plus approach, or set prices to achieve specific profit targets. In MYOB Advanced, you can calculate pending sales prices for both non-stock items and stock items by using the approach—that is, by choosing the price basis—that makes the most sense at a particular time.

In MYOB Advanced, the options for the price basis can be divided into the following groups:

• Inventory-related: A cost-plus basis (the Last Cost + Markup % option or Avg./Std. Cost + Markup % option) or the manufacturer's suggested retail price (the MSRP option).

  You specify values for these options by using the Stock Items (IN202500) form for stock items. Also, on the Price/Cost tab of the Item Warehouse Details (IN204500) form, you can define the markup percentage and MSRP specific to a particular warehouse. For non-stock items, only the Avg./Std. Cost + Markup % option is applicable, and the system uses (instead of the average or standard cost) the current cost of a non-stock item, which is specified in the Current Cost box on the Non-Stock Items (IN202000) form Price/Cost tab.

• Price record-related: The item's current price (Source Price) or pending price (Pending Price).

  You specify values for these options by using the Sales Price Worksheets (AR202010) form.

Calculation of Pending Prices Based on MSRP

An item's MSRP—that is, the manufacturer's suggested retail price—is specified on the Price/Cost tab of the Stock Items (IN202500) form. A similar box is available on the Price/Cost tab of the Non-Stock Items (IN202000) form for non-stock items.

You perform mass-calculation of pending prices based on the items' MSRP by using the Sales Price Worksheets (AR202010) form. On this form, you add to the sales price worksheet the price records for the items for which you want to recalculate prices. Then, you click Calculate Pending Prices on the table toolbar to invoke the Calculate Pending Prices dialog box. In this dialog box, you select MSRP as the price basis and click Update to add to the worksheet the pending prices recalculated based on MSRP. The recalculated pending prices become effective after you release the worksheet (on a date specified as the effective date).