...
The form when opened will show a list of all the price lists that you have available on the system.
...
When you open the form you can maintain the customer contract price list, expand the section below to learn more about this :
| Expand |
|---|
| title | Customer Price List Maintenance |
|---|
|
When you open the price list you will be presented with the form below, which has three distinct sections Header - with the name, type, expiry date Products - a list of the products on the price list, and when you select a product you will see the prices Price Window - only shows when you select a product, details the prices and the bands those prices will apply.
 Image ModifiedThe ability to replicate customer price lists is available, you simply have to specify the new customer that this price list will apply to. |
Price Maintenance Form
We provide a overall view form which allows you to see information about product prices or price lists. This is a single screen allowing you a much better overview of the pricing, along with key information on the costs and charges, the concept was to allow you to have a better idea before you start updating prices.
| Expand |
|---|
| title | Using the Price Maintenance Form |
|---|
|
This form provides you with global access to all the prices on a single screen allowing you to edit the sales price for the product. There are two options available you either maintain the prices for Once you decide what you wish to maintain select your option and search and you will see the products listed below | Tip |
|---|
There is an UPDATE PRODUCT COST option on the bottom left of the form, this will update the product purchase prices to be the prices from the LAST purchase of the goods. So if you have not been maintaining those prices, this will refresh those to what you last paid for the goods. |
For product price maintenance a full list of all products will appear  Image Modifiedor if you pick a price list then you will only see those items on the price list and then you are able to update the NEW SALES PRICE field based on the information displayed on the forms Once you have finished remembering to hit the SAVE button, do not just close the form otherwise nothing will be updated. | Info |
|---|
Remember you can always use the price list export functionality where you can output in excel and reload the price list directly back into the system. |
Field ExplanationField Name | Description |
|---|
Product Code | This has to be a unique product code for the product. | Description | Description of the product (50 characters maximum) Remember do not include the vintage, pack sizes, item sizes, brand, producer as those are all within their own fields. e.g. Wine Name | SPC | Singles per case | SS | Single Size e.g. 75.00 for standard wine bottle, 1.00 for marketing material | Vintage | Vintage or the Year You can also enter NA or NV | Last Landed Price GBP | The price at which the goods were last received | Last Landed Date | The Last Date this stock was receipted | Last Ex Cellar Price GBP | The Last Price used for Back to Back or Ex Cellar Orders. | Last Ex Cellar Date | The Last Date a Batch to back or Ex Cellar Order was placed. | Product UB Cost GBP | The Current Underbond Price for the Product. | DP Sales Price | The Duty Paid Price. | Suggested DP Price @ Margin | Based on the global standard margin factor, this is the Suggested Duty Paid Price Margin. | Suggested Ex Cellar Sales Price @ Margin | Based on the global standard margin factor, this is the Suggested Price Margin for Ex Cellar Orders. | New Sales Price | Your new standard sales price for the product per case, we will work out the single and underbond pricing automatically. | Duty Per Unit | Excise duty expected for this case at this time | CCT Per Unit | Customs duty expected for this case (at this time) | RHD | From the warehouse group, this is the cost to receipt this case into the warehouse | Rent | From the warehouse group, this is the cost per case per week for storage rental charges | Freight | Based on the Country or the Region this would be the price per case for the freight, usually defined as standard pricing | Insurance | Based on the country or the region this is the proce per case for the insurance, generally this is a common value for all countries based on your goods in transit insurance divided by number of cases per annum |
|