Sales Prices

Navigates to the Sales Price Worksheets (AR202010) form, where you continue working with the created price worksheet, which contains all price records matching the criteria that you have selected on the current form. By default, the new worksheet is created with the On Hold status and the current business date.

When you create a price worksheet by clicking this button, the system copies the value selected in the Tax Calculation Mode box in the Summary area of this form to the created worksheet. If All Modes is selected in this box, the system displays an error message indicating that a tax calculation mode must be selected.

• All Prices: Prices of all available types are displayed.
• Base: Prices of the base type are displayed. The base price is used if there are no other more specific prices defined (promotional or customer-specific). This price type does not have any price codes.
• Customer: Customer-specific prices are displayed. You can select a particular customer account in the Price Code box to create a price list for this customer or to narrow the list of prices.
• Customer Price Class: Prices specific to the price classes are displayed. You can select a particular price class in the Price Code box to create a price list for all customers from this price class or to narrow the list of prices. For an item, you can set different prices for different customer price classes, which can be created and modified on the Customer Price Classes (AR208000) form.

The customer or a customer price class for which you want to create or edit a price list. This box is available if the Customer or the Customer Price Class option is selected in the Price Type box.

The list of values may be limited based on the current user's access role. You can select a price code of a customer whose settings permit the use of the branch or company to which the user's role is assigned (the Restrict Visibility To box on the Financial tab of the Customers (AR303000) form contains this branch, company, or a company group, or is empty).

The tax calculation mode of the prices displayed in the table. The following options can be selected:

• All Modes (default): Prices with all available tax calculation modes are shown.
• Not Set: Only prices with the Not Set tax calculation mode are shown.
• Gross: Only prices with the Gross tax calculation mode are shown.
• Net: Only prices with the Net tax calculation mode are shown.

This box appears on the form if the Net/Gross Entry Mode feature is enabled on the Enable/Disable Features (CS100000) form.

The warehouse for which you want to review sales price information.

This box appears if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.

• Select the Me check box to view the items assigned to you. The box will contain your user name.
• Clear the Me check box and select another user name to view the items assigned to the user.
• Leave the boxes blank to view items assigned to all users of the selected price workgroup or all groups.

• Select the My check box to view the items assigned to your price workgroup (or to a selected user in the group).
• Clear the My check box and select a price workgroup in the unlabeled box to display the items assigned to the price workgroup (or to a particular price manager, if you select one, in the selected group).
• Leave the box blank and clear the check box to view the items assigned to all price workgroups.

The code of the price, which can be either the price class ID of the customer (if Customer Price Class is selected in the Price Type column) or the customer ID (if Price Type is set to Customer).

For more details, see Uploading Prices with Alternate IDs and Creating Alternate IDs from Price Worksheets.

The warehouse for which the price is defined. If this box is empty, the price applies to all warehouses.

This column appears if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.

A check box that indicates (if selected) that the price for this item is promotional. Promotional prices, which may overlap with regular prices, should have expiration dates after which they are not used.

The check box is not available when the Fair Value check box is selected in the line.

If this check box is selected in the row, the Ignore Automatic Line Discounts check box will be selected automatically.

A check box that indicates (if selected) that automatic line discounts are turned off (that is, not calculated) for this price.

The check box appears on the form if the Customer Discounts feature is enabled on the Enable/Disable Features (CS100000) form.

This check box is selected automatically if the Promotional check box is selected in this row.

The check box is cleared and unavailable when the Fair Value check box is selected in this row. (That is, if in this row, one of these check boxes is selected, the other check box is cleared and not available for selection).

A check box that indicates (if selected) that the price in this row will be used by the price selection algorithm as a fair value price in the revenue reallocation process.

This column appears on the form if the Revenue Recognition by IFRS 15/ASC 606 feature is enabled on the Enable/Disable Features (CS100000) form. The check box becomes available for selection if the Promotion check box is cleared (in this row) for the price.

The check box is cleared and unavailable when the Promotional or Ignore Automatic Line Discounts check box is selected in this row.

A check box that indicates (if selected) that the fair value price is prorated. A price can be prorated when the system calculates the fair value price for inventory items with a deferral code of a flexible type (Flexible by Period, Prorate by Days, or Flexible by Days in Period).

This column appears on the form if the Revenue Recognition by IFRS 15/ASC 606 feature is enabled on the Enable/Disable Features (CS100000) form. The check box becomes available for selection when the Fair Value check box is selected.

A check box that indicates (if selected) that for the discount codes for which the Apply to Deferred Revenue check box is selected on the Discount Codes (AR209000) form, the system will apply the discounts defined on the Discounts (AR209500) form.

This check box can be selected only for prices for which the Fair Value check box is selected. The discounts will be applied to fair value prices to get the effective fair value prices to be used in the calculation of deferred revenue.

This column appears on the form if the Revenue Recognition by IFRS 15/ASC606 and Customer Discounts features have been enabled on the Enable/Disable Features (CS100000) form.

This column appears if the Volume Pricing feature is enabled on the Enable/Disable Features (CS100000) form.

The Min. Markup % for the item is specified on the Price/Cost tab on the Stock Items (IN202500) form or the similarly named tab on the Non-Stock Items (IN202000) form.

The tax calculation mode of the particular price. The following options can be selected:

• Not Set (default): The price either includes a tax or does not, depending on the tax settings.
• Gross: The tax amount is included in the item price.
• Net: The tax amount is not included in the item price.

The system displays prices with the tax calculation modes selected in the Tax Calculation Mode box in the Summary area.

This column appears in the table if the Net/Gross Entry Mode feature is enabled on the Enable/Disable Features (CS100000) form.

The tax category specified for the stock item or non-stock item on the General tab of the Stock Items (IN202500) or Non-Stock Items (IN202000) form. This column is read-only.

This column appears in the table if the Net/Gross Entry Mode feature is enabled on the Enable/Disable Features (CS100000) form.