Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
moneyworks:pricebook_v4_airtox [2021/02/08 09:41] – [What it does] Sanjeev Thapa Magar | moneyworks:pricebook_v4_airtox [2022/11/23 05:48] (current) – [Setup and Installation] Mandeswori Maharjan | ||
---|---|---|---|
Line 12: | Line 12: | ||
===== Setup and Installation ===== | ===== Setup and Installation ===== | ||
- | * Double-click the script supplied by Sustainable Solutions. Once it is installed, PriceBookList icon will be appear in toolbar of the Product | + | * Double-click the script supplied by Sustainable Solutions. Once it is installed, PriceBookList icon will appear in the toolbar of the Items table. To open Items table **Show>Items** |
- | {{ : | + | {{ : |
* If you have prices based on Customer group and Product group: | * If you have prices based on Customer group and Product group: | ||
* Record the customer group code in Name.Category4 field | * Record the customer group code in Name.Category4 field | ||
- | * Record the Product group code in the Product.Category1 | + | * Record the Product group code in the Product.Custom4 |
===== Viewing and Setting prices ===== | ===== Viewing and Setting prices ===== | ||
- | - Show the product list by choosing **Show > Products** | + | - Show the product list by choosing **Show > Items** |
- Click the **PriceBookList** button in the toolbar. You can see all the prices set for each customer/ | - Click the **PriceBookList** button in the toolbar. You can see all the prices set for each customer/ | ||
- | - {{ : | + | - {{ : |
- Click the **New** button in the toolbar | - Click the **New** button in the toolbar | ||
- | - {{ : | + | - {{ : |
- Select **Customer** for customer code and **Group of Customer** for customer group code. | - 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. | - 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'll be alerted if you enter an invalid customer/ | ||
- | - You only have to fill in a **Special price**. Other fields are optional | + | - You only have to fill in a **Special price** or **Special Discount %**. Other fields are optional, the quantity break and price break will work with Special price only. |
- 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. | - 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. | - 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. | - 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 Quotes or invoices, when you select a combination of customer and product that has special pricing, that pricing will be used. See the previous report | + | * There is nothing special you have to do. Enter items in the sales order window and click Pricebook button in the window, then depending upon your combination of customer and product that has special pricing |
- | * {{ : | + | * {{ : |
* 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. | ||