Specifies the selling price per unit in the Unit Price field on the item card, but you may also need to set up some individual sales prices for items. You do this in the Sales Prices window, which you find by clicking Related Information, pointing to Sales, and then clicking Prices on the item card.
In the Sales Prices window, you can specify the conditions that must be met before a customer can be offered an individual unit price for a specific item when quotes, orders, invoices, and credit memos are set up. For example, the conditions can require that the customer is linked to a particular customer price group or the invoice is in a particular currency. They can also contain a starting date and an ending date, between which the sales price is valid, and they can contain a specific unit of measure code. You can also define a combination of the conditions under which the sales price applies. You can set up several sales prices for each item, but each must have a different set of conditions.
Because a sales price is often a reduced price, you can specify in the Sales Price window whether you also want the program to combine line and invoice discounts when a sales price is offered.
When you enter an item on an invoice, for example, the program automatically looks in the Sales Price table to see whether it contains a sales price for the item. If it does, the program checks whether the starting date has arrived and the ending date has not. If the conditions are met, the program will enter the sales price in the Unit Price field on the invoice. If not, the program will use the basic unit price from the item card.
To read about how to use batch jobs to edit and update sales prices, see the Sales Price Worksheet table.
List of Fields in the Table
The following table lists the fields in this table.
Unit Price Field, Sales Price Table |
Inventory |
Starting Date Field, Sales Price Table |
Inventory |
Item No. Field, Sales Price Table |
Inventory |
Published Price Field, Sales Price Table |
New Zealand Local Functionality |
Price Inclusive of Tax Field, Sales Price Table |
India Excise |
Minimum Quantity Field, Sales Price Table |
Inventory |
Cost-plus % Field, Sales Price Table |
New Zealand Local Functionality |
Cost Field, Sales Price Table |
New Zealand Local Functionality |
VAT Bus. Posting Gr. (Price) Field, Sales Price Table |
Inventory |
MRP Price Field, Sales Price Table |
India Excise |
Sales Type Field, Sales Price Table |
Inventory |
Allow Invoice Disc. Field, Sales Price Table |
Inventory |
PIT Structure Field, Sales Price Table |
India Excise |
Discount Amount Field, Sales Price Table |
New Zealand Local Functionality |
Price Includes VAT Field, Sales Price Table |
Inventory |
MRP Field, Sales Price Table |
India Excise |
Variant Code Field, Sales Price Table |
Inventory |
Abatement % Field, Sales Price Table |
India Excise |
Currency Code Field, Sales Price Table |
Inventory |
Allow Line Disc. Field, Sales Price Table |
Inventory |
Unit of Measure Code Field, Sales Price Table |
Inventory |
Sales Code Field, Sales Price Table |
Inventory |
Ending Date Field, Sales Price Table |
Inventory |
Unit Price Field, Sales Price Table |
Inventory |
Starting Date Field, Sales Price Table |
Inventory |
Item No. Field, Sales Price Table |
Inventory |
Unit of Measure Code Field, Sales Price Table |
Inventory |
Minimum Quantity Field, Sales Price Table |
Inventory |
VAT Bus. Posting Gr. (Price) Field, Sales Price Table |
Inventory |
Sales Code Field, Sales Price Table |
Inventory |
Sales Type Field, Sales Price Table |
Inventory |
Allow Invoice Disc. Field, Sales Price Table |
Inventory |
Price Includes VAT Field, Sales Price Table |
Inventory |
Variant Code Field, Sales Price Table |
Inventory |
Currency Code Field, Sales Price Table |
Inventory |
Allow Line Disc. Field, Sales Price Table |
Inventory |
Ending Date Field, Sales Price Table |
Inventory |
Published Price Field, Sales Price Table |
New Zealand Local Functionality |
Cost-plus % Field, Sales Price Table |
New Zealand Local Functionality |
Cost Field, Sales Price Table |
New Zealand Local Functionality |
Discount Amount Field, Sales Price Table |
New Zealand Local Functionality |
See Also
Reference
Sales Prices
Item Card