Per Customer Pricebook version 2

Requires: Moneyworks v7

This Moneyworks script allows you to record and use a set of prices for each product for each of your customers. Prices can include price breaks for different quantities.

Double-click the script supplied by Sustainable Solutions. That's it. For viewing prices, you need to install the pricebook report we will supply you into the reports folder inside your Moneyworks Custom Plug-ins folder

1. Show the product list by choosing Show > Products
2. Locate then highlight the product you wish to set a special price for
3. 
4. Click the Pricebook button in the toolbar
5. You'll be asked to enter the customer code:
6. 
7. You'll be alerted if you enter an invalid code, else if you enter a valid customer code and the values in the window are blank, you're adding a new product/customer combination. If values are already filled in, you're editing:
8. 
   1. You only have to fill in a price. Other fields are optional
   2. If there is no expiry date for the special prices, enter a date well into the future (e.g. 1/1/50). You can't leave it blank.

1. To view prices, choose Pricebook Report from the reports menu:
2. 

• There is nothing special you have to do. When entering a sales order or invoice, when you select a combination of custom and product that has special pricing, that pricing will be used. See the previous report example: customer “BSUPP” has a price of $20 for the product BA100. The price is inserted automatically.
• 
• If the quantity was increased to above a price break level, the price is updated to the relevant price you've specified.

This script also allows you to restrict the supply of particular groups of products to only certain customers

If you change the product or name code of an item, the special pricing information will be lost. You will have to re-enter the information for any customer/item combinations that are affected.

This script uses Moneyworks' user2 table to store information