Sales Prices: General Information

MYOB Acumatica provides multiple mechanisms of maintaining sales prices. You can define a base price list, price lists that apply to a specific customer or a group of customers, and lists of promotional prices or prices that depend on the quantity of the product being sold. You can also define a default price to be used for each individual item if no other price is defined for it in the system.

Learning Objectives

You will learn how sales prices of various types are defined in the system.

Applicable Scenarios

In MYOB Acumatica, you can maintain sales prices for both non-stock items and stock items. You can define sales prices for stock items if the Inventory feature is enabled on the Enable/Disable Features (CS100000) form.

Sales Price Types

You define sales prices by using the Sales Prices (AR202000) form or the Sales Price Worksheets (AR202010) form. When you create a sales price record for an item, you specify the item and the date when the price becomes effective. Also, you assign the price a specific sales price type and code; these settings help you define what the price applies to. You select one of the following price types:

  • Base: You use this price type for prices that you want to include in a base price list. Base prices are used for an item if there are no more specific prices defined for the item (for example, promotional or specific to the individual customer). This price type does not have any price codes.
  • Customer Price Class: You use this price type for prices aimed at customers of a particular customer price class. This price type requires a price code to be specified. The price codes are identifiers of customer price classes defined in the system.
    Note: You use the Customer Price Classes (AR208000) form to define a customer price class—a group of customers that may be offered special prices because of their buying habits. For instance, you could define as a class those customers that buy the largest quantities and are offered the most competitive prices. By default, all customers of the same customer price class are charged the same price for the same item.
  • Customer: You use this price type for prices aimed at a particular customer. This price type also requires a price code to be specified. The price codes are identifiers of customer accounts defined in the system. This price type might be needed if you have customers that have unique buying habits even among customers of the same price class, or customers who buy especially large volumes of products.

Optionally, prices of the listed types can also be defined as any of the following:

  • Promotional: Prices aimed to draw customers' attention. Promotional prices are effective for a specific period of time.
  • Volume-dependent: Prices that depend on the volume of products being sold. You can define these prices if the Volume Pricing feature is enabled on the Enable/Disable Features (CS100000) form.
  • Warehouse-specific: Prices aimed to a particular warehouse. You can define these prices if the Multiple Warehouses feature is enabled on the Enable/Disable Features form.
  • UOM-specific: A price can be to a unit of measure (UOM) in which an item is sold.
Note: A price can be of multiple types simultaneously—for example, a customer-specific price can be defined as both promotional and volume-dependent.

Default Prices

A default price is a price of a stock or non-stock item that is used when no other price is defined for the item. Default prices can be maintained optionally—for instance, for the items whose prices do not vary depending on the purchased quantity, the season, promotional periods, and other factors.

You maintain the default price of a particular non-stock item in the Default Price box on the Price/Cost tab of the Non-Stock Items (IN202000) form. If the Inventory feature is enabled on the Enable/Disable Features (CS100000) form, you can enter default prices for stock items as well. To enter the default price for a stock item, you use the Default Price box on the Price/Cost tab of the Stock Items (IN202500) form. The default prices for stock items and non-stock items are specified in the base currency and for the base units.

You can update the default prices for stock and non-stock items as often as you need to. When updating price lists by using the Sales Price Worksheets (AR202010) form, you can specify the method of calculating the updated prices (based on such factors as the item markup percent or the percent of increase), and the new prices will be calculated automatically. However, when you update the default prices, you cannot directly specify how to calculate the new values—you can calculate these prices externally by using any method you consider appropriate. Then you enter the resulting prices manually on a per-item basis or import all of them from a file by using an import scenario.

Default prices have the following limitations:

  • The system does not keep the history of default prices. A default price has no start date and no expiration date. Once specified, the default price is used for the item until a new default price is entered.
  • You cannot define default prices as tiered prices or as promotional prices that are in effect for a particular date range.