Creating Price Lists
This example shows you how to create a new Price List in which the Prices for each Item are the Base Price less 7%.
Start by creating a new Price Formula record using the Price Formula register in the Sales Ledger.
Give a name to the formula. In the % Adjustment field, enter the value "93" (representing a 7% discount) to give the calculation formula. The Round Off field gives instructions for rounding off the calculated value. Use 'Paste Special' to choose the option you need. For the example, enter "Two Decimals". Finally, select the Base Price to act as the base value for the calculation. Save the Price Formula by clicking [Save].
Now, create a new Price List using the register in the Sales Ledger, with the code "SEVEN", and an appropriate name. Enter the Code of the Price Formula that you have just set up in the Formula field.
If you leave the Item Code field blank, a new Price List will be created for all Items in the Item register. Otherwise enter one or more Items or Item Groups in separate rows to apply different Price Formulae to different products. Save the Price List by clicking [Save].
To create the new Price records, select 'Maintenance' from the File menu. Double-click 'Calculate Price Lists', and specify in the following dialogue box that you want to create Price records for the Price List "SEVEN":
New Price records will be added to the
Price register if this is the first time you have run the function for this Price List. Otherwise, the Prices will simply be recalculated. The creation will take some time, depending on the number of records. When the job is finished, the new records are visible in the Price register.
You can now allocate the new Price List to the Customers that are to be allowed to take advantage of the 7% discount. Specify the Price List on the
'Company' card of each such Customer record:
When you enter an Order or Invoice for one of these Customers, the correct prices are brought in automatically:
