Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| moneyworks:pricebook_v3 [2017/07/26 08:48] – Mandeswori Maharjan | moneyworks:pricebook_v3 [2019/11/26 20:27] (current) – [Setup and Installation] Craig Drown | ||
|---|---|---|---|
| Line 7: | Line 7: | ||
| This Moneyworks script allows you to record and use a set of prices for each product or a group of products for each of your customers or a group of customers. Prices can include price breaks for different quantities. | This Moneyworks script allows you to record and use a set of prices for each product or a group of products for each of your customers or a group of customers. Prices can include price breaks for different quantities. | ||
| - | ===== Installation ===== | + | ===== Setup and Installation ===== |
| - | Double-click the script supplied by Sustainable Solutions. Once it is installed, PriceBookList icon will be available | + | |
| - | {{ : | + | {{ : |
| + | * If you have prices based on Customer group and Product group: | ||
| + | * Record the customer group code in Name.Category4 field | ||
| + | * Record the Product group code in the Product.Category1 field. | ||
| - | ===== Setting prices ===== | ||
| - | - Show the product list by choosing **Show > Products** | ||
| - | - Click the **PriceBookList** button in the toolbar. | ||
| - | - {{ : | ||
| - | - You'll be asked to select the customer or Group: | ||
| - | - {{ : | ||
| - | - Select customer for customer code and Group for customer group code. Customers are grouped by Customer Category 4. | ||
| - | - 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/ | ||
| - | - {{ : | ||
| - | - You only have to fill in a price. Other fields are optional | ||
| - | - If there is no expiry date for the special prices, enter a date well into the future (e.g. 1/1/50) else it will take defaut future date. You can't leave it blank. | ||
| - | - You will get an alert if the record is already in the price book. You can choose to delete or edit the record. | ||
| - | - {{ : | ||
| - | ===== Viewing prices ===== | + | ===== Viewing |
| - | - To view prices for selected Items, select items in Items list and choose | + | - Show the product |
| - | - To view prices for selected | + | - Click the **PriceBookList** button in the toolbar. You can see all the prices |
| - | - {{ : | + | - {{ : |
| + | - Click the **New** button in the toolbar | ||
| + | - {{ : | ||
| + | - Select **Customer** for customer code and **Group of Customer** for customer group code. | ||
| + | - Select **Product** for product code and **Group of Products** for a product group code. | ||
| + | - You'll be alerted if you enter an invalid customer/ | ||
| + | - You only have to fill in a **Special price**. Other fields are optional | ||
| + | - If there is no expiry date for the special prices, enter a date well into the future (e.g. 1/1/50) else it will take defaut future date. You can't leave it blank. | ||
| + | - You will get an alert if the record is already in the price book. You can choose to delete or edit or print the record. | ||
| + | - Avoid using “Duplicate” option. This creates duplicated record but if you don’t change the record(name and item), it will create same record in pricebook data. In that case, script will not update price from pricebook because of conflict. | ||
| ===== Using special prices ===== | ===== Using special prices ===== | ||
| - | * There is nothing special you have to do. When entering a sales order or invoice, when you select a combination of custom | + | * There is nothing special you have to do. When entering a sales order or Quotes or invoices, when you select a combination of customer |
| * {{ : | * {{ : | ||
| * If the quantity was increased to above a price break level, the price is updated to the relevant price you've specified. | * If the quantity was increased to above a price break level, the price is updated to the relevant price you've specified. | ||
| + | |||
| + | ===== Importing prices in bulk ===== | ||
| + | * If you have a lot of prices to be uploaded into Moneyworks at once, you can import them from text file in following format. | ||
| + | * To import **Command> | ||
| + | * Select prices text file and click on **Open** | ||
| + | * Test file format | ||
| + | * 4 columns separated by tabs (press the tab key, not the space bar) | ||
| + | * customer/ | ||
| + | * item/Item Group code | ||
| + | * special price(s) for use when this product is supplied to this customer | ||
| + | * Expiry Date. It can be blank, if there is no expiry data. Moneyworks will assign future date | ||
| + | * Format of price breaks | ||
| + | * a colon between qty-price pairs | ||
| + | * a hyphen between qty and price | ||
| + | * So in the example below the customer SMITH will pay for item BA100 | ||
| + | * $10 if the quantity is less than 5 | ||
| + | * $9.50 if the quantity is greater than or equal to 5 | ||
| + | * $9.20 if the quantity is greater than or equal to 10 | ||
| + | * etc. | ||
| + | |||
| + | {{ : | ||
| ===== Important Caveats ===== | ===== Important Caveats ===== | ||
| Line 42: | Line 62: | ||
| ^ Field ^ Data stored ^ | ^ Field ^ Data stored ^ | ||
| - | | Key | concatenated | + | | Key | concatenated |
| - | | Text | the special price(s) of the item along with the price breaks in format special_price; | + | | Text1 | Name Code/Name group Code | |
| + | | Text2 | Product Code/ | ||
| + | | Text | The special price(s) of the item along with the price breaks in format special_price; | ||
| |Date1 | The expiry date of the price. Set to 1/1/2040 if you don't want the item to expire | | |Date1 | The expiry date of the price. Set to 1/1/2040 if you don't want the item to expire | | ||
| - | |Float1 | The percentage discount for the item when supplied to this customer. Set to zero if special prices, not discounts are to be used| | ||