About Sales price worksheet - overview

You create a new worksheet by using the Add new record button in the Sales price worksheets (AR202010) window toolbar. Each worksheet has a reference number that the system generates according to the number series defined in the Customer ledger preferences (AR101000) window. A worksheet is created with the On hold status and the Hold check box selected, which indicates that a user can edit the worksheet but cannot release it yet. You can edit the price records of existing worksheets that have the On hold or Open status.

Also, you can click the Create price worksheet button in the Sales prices (AR202000) window to create a worksheet that is populated with the price records you have selected in this window.

You decide which price records you want to update and add these records to a worksheet. You can populate a worksheet by performing any of the following actions, each of which adds new records to the existing list:

• Adding the new price records one by one, by using a standard button in the table toolbar
• Deleting the price records one by one, by using a standard button in the table toolbar
• Uploading price records from an Excel file, by using a standard button in the table toolbar
• Uploading the list of items with their default price information from the Inventory workspace by using the Add item button in the table toolbar
• Making a copy of existing price records by using the Copy prices button in the table toolbar

You can edit the added price records and then add more new price records to the worksheet, or window the list of price records first and then proceed to editing. The worksheet should have the Hold check box selected (which gives it the On hold status).

You can edit price records by performing any of the following actions:

• Editing components of price records one by one, including creating tiered prices and changing a unit of measure or price type and code (if needed). Also, you can enter the new prices for the stock items in the list in the Pending price column.
• Calculating the new pending prices for all price records in the worksheet by using the selected price basis. You can base sales prices in price lists on the manufacturer's suggested retail prices (MSRP), standard or average costs, mark-ups set for particular item classes or inventory price classes, or other rules. To ensure that the appropriate mark-up is achieved, you can configure the system to warn users, when they modify a sales order, that the price is lower than the required minimum mark-up percentage. For details, see About sales price calculation.
• Making all the records in the worksheet promotional, by selecting the Promotional check box and specifying the expiration date in the top part of the window.

When you have finished editing price records, you should clear the Hold check box, which gives the worksheet the Open status, indicating that the worksheet is ready to be released. With this status, you still can edit price records one by one, but you cannot use mass-editing tools.

The price records listed in the worksheet are added to the sales prices records when you release the worksheet by clicking Release in the window toolbar. Prices in the released worksheet become effective on the date you have specified in the Effective date field of the worksheet.

When you release a worksheet, the system validates records, ensuring that the following criteria are met:

• Pending prices should be set for all records. If you do not want to update a price, delete the row from the table or specify the current price in the Pending price column.
• Regular prices for the same combination of a price type, price code, item ID, UoM, and currency may not overlap in time.
• Promotional prices for the same combination of a price type, price code, item ID, UoM, and currency may not overlap in time.Note: Promotional and regular prices for the same combination of price type, price code, item ID, unit of measure, and currency may overlap one another in time.

For details on price record validity, see About effective period of prices.