About Sales price worksheets

Before you start

If you want to maintain your sales prices using the Sales price worksheets window, you should not use the default prices in the Non-stock items and Stock items windows.

See: Maintain default prices for non-stock items and Maintain default prices for stock items.

You can create a worksheet with promotional prices, and set an expiration date for the promotion. You can also use a worksheet to calculate the pending prices for multiple items by using a price basis you specify yourself.

To populate a worksheet, you can manually add new rows, upload prices from an Excel or a.csv file, or use the Add item and Copy prices buttons. See: Import data from a local file to a table.

When you use the Customer or Customer price class price type, you must also select a price code.

Related pages

Concepts

• About Sales price worksheet - overview
• About multiple price lists
• About effective period of prices

Tasks

• Add records for multiple items to a worksheet
• Add promotional prices
• Add a record to a worksheet
• Calculate pending prices in a worksheet
• Calculate pending prices for items
• Copy prices to a worksheet
• Create a sales price worksheet

Windows

• Sales price worksheets (AR202010)
• Sales prices (AR202000)