Introduction and Header
The Product Maintenance is used to hold information about the Products (SKU’s) that you will be selling and is used extensively throughout ordering processes and stock control.
This page explains the header and footer functionality for the product maintenance and a number of other pages within this section explain the fields and contents of each tab, those pages are linked below
What is on this page
- 1 Product Header
- 1.1 Explanation of the Header Fields
- 1.1.1 Product Code
- 1.1.2 L-WIN
- 1.1.3 Product Description
- 1.1.4 Alt Language Description
- 1.1.5 Product Variant
- 1.1.6 Producer
- 1.1.7 Vintage
- 1.2 Options
- 1.2.1 Auto Generate
- 1.2.2 Available from
- 1.2.3 Delisted
- 1.2.4 Retail Product
- 1.2.5 SO Rotation Mandatory
- 1.2.6 Case Break sale allowed
- 1.3 Fields Generated by the System
- 1.3.1 Product ID
- 1.3.2 Package Description
- 1.1 Explanation of the Header Fields
- 2 Product Footer
- 2.1 Refresh
- 2.2 Sales Analysis
Other pages
Product Header
We will look at the contents of the fields shown above within this section.
Explanation of the Header Fields
Fields that you can enter data into
Field | Explanation |
---|---|
Product Code | We recommend using straight forward Product Codes of no more than 12 characters as this makes it easier to enter Sales and Purchase Orders. |
L-WIN | L-WIN is used for the Liv-ex Wine Identification Number, this allows you to request values for your products directly from Liv-ex. |
Product Description | This is a 50 character field designed to store the product name information you should avoid adding anything into this field which is already within its own field e.g. Vintage, Year, SPC, SS, Producer as those are all taken from their respective fields when the product is added to a report template. |
Alt Language Description | This field is not marked on the form It is only used for customers who are using multiple languages and can contain non latin characters. This field is limited to output on some templates. |
Product Variant | a lookup field to add a product variant such as screw cap, cork, gift pack etc. |
Producer | a lookup field for the producer |
Vintage | Vintage (Year) is used to record the year of manufacture for the product. The options are
NA is generally suppressed on report output. |
Options
Field | Explanation |
---|---|
Auto Generate | This feature is used when you have dynamic product codes setup. |
Available from | You are able to set the Available date for the Product, when creating the product it will default to the current date but you are able to change it. The format is dd/mm/yyyy or you are to select it by using the Calendar Picker Tool. |
Delisted | When you are making the Product De-Listed, this will allow you to use any remaining Stock but you are not able to receipt (land) the product on a new Purchase Order. You will use this for example; you might have a product that is coming to the end of its vintage. |
Retail Product | If you have marked the Product Is Retail Product, this will provide the ability add a non stocked product to the order. There are two options available
Retail items can not be added to purchase orders. The order will not show on the Allocation screen or Submission screen. You can use this option in conjunction with the 3rd party supplier fields on the Purchasing and Pricing to send the item to the warehouse for 3rd party fullfillment. The order line will follow through allocation automatically with other lines on the order when they are allocated, will be transmitted to the warehouse. We will not be able to confirm it has been fullfilled we will ASSUME it has been unless you adjust it manually on the delivery It’s important that non stocked items will show on margin and sales reports
For example: If you run a Bar, and you sell a glass of wine. You would like to make a note of the sale. As we are not able to Stock Manage the litres in a Bottle, we call this Retail product. You should under no circumstances change a stocked product to be a RETAIL product when there was previously stock or there is currently stock using the product record. |
SO Rotation Mandatory | SO Rotation Mandatory is used to make the Rotation Mandatory when entering this Product on a Sales Order. |
Case Break sale allowed | Case Break Sales Allowed is used to allow the user to uses Singles on an Order and able to break a cases
|
Fields Generated by the System
Field | Explanation |
---|---|
Product ID | a unique number generated by the system |
Package Description | derived from other fields SPC x SS (Singles per case x Single Size) |
Product Footer
Refresh
This is used to update the information on the page, if you have left the page open for a long time it is always worthwhile refreshing as stock balances may have changed
Sales Analysis
This is designed to provide you with a quick look at who is purchasing the product.
You can filter the contents of the form by using the search fields at the top of the form.
Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.