Sales Price Worksheet Table

Specifies the unit price in the Unit Price field on the item card, but you may also need to set up some sales prices for items. You do this in the Sales Prices window, which you find by clicking Actions, Sales Prices on the item card.

You use the Sales Price Worksheet table to edit and update the sales prices. The program fills in this table when you run two batch jobs, which suggest unit prices based on:

  • the prices in the Unit Price field on the item cards. To run the Suggest Item Price on Wksh. batch job, click Actions, Functions, Suggest Item Price on Wksh.. Then you can, for example, give a particular customer price group a unit price that is lower than the normal price. The price in the Unit Price field on the item card is not changed by this batch job.

  • sales prices in the Unit Price field in the Sales Prices window. To run the Suggest Sales Price on Wksh. batch job, click Actions, Functions, Suggest Sales Price on Wksh. to change sales prices that have already been set up or to create new prices.

Both batch jobs end by displaying the newly calculated unit prices in the Sales Price Worksheet window, where you can change unit prices that are not satisfactory or delete lines you do not want. When you are satisfied with all the unit prices, click Actions, Functions, Implement Price Change to copy the new unit prices to the Sales Price table.

The Sales Price Worksheet table is different from most of the other tables in the program. The two most important differences are:

  • The main function of this table is not to let you set something up, but to let you use the Suggest Item Price on Wksh. and the Suggest Sales Price on Wksh. batch jobs in order to change something that has been set up.

  • The contents of the fields in this table are temporary until they are deleted or transferred to the Sales Price table.

Note

You can add or change the ending date when you update the sales prices.

List of Fields in the Table

To see the list of fields in this table, change to the Classic view. Choose the Choose View button in the upper-right corner, and then choose Classic.

Field Location
Variant Code Field, Sales Price Worksheet Table Inventory
Sales Code Field, Sales Price Worksheet Table Inventory
Currency Code Field, Sales Price Worksheet Table Inventory
VAT Bus. Posting Gr. (Price) Field, Sales Price Worksheet Table Inventory
Sales Type Field, Sales Price Worksheet Table Inventory
New Unit Price Field, Sales Price Worksheet Table Inventory
Price Includes VAT Field, Sales Price Worksheet Table Inventory
Sales Description Field, Sales Price Worksheet Table Inventory
Ending Date Field, Sales Price Worksheet Table Inventory
Allow Line Disc. Field, Sales Price Worksheet Table Inventory
Minimum Quantity Field, Sales Price Worksheet Table Inventory
Unit of Measure Code Field, Sales Price Worksheet Table Inventory
Item No. Field, Sales Price Worksheet Table Inventory
Starting Date Field, Sales Price Worksheet Table Inventory
Item Description Field, Sales Price Worksheet Table Inventory
Current Unit Price Field, Sales Price Worksheet Table Inventory
Allow Invoice Disc. Field, Sales Price Worksheet Table Inventory

See Also

Reference

Sales Price Worksheet
Item Card

Other Resources

How to: Copy Sales Prices