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.

image-20240517-100309.png

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


Product Header

 

image-20240517-100240.png

 

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

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

  • 4 digit year

  • NA

  • NV

NA is generally suppressed on report output.

Options

Field

Explanation

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

  • Retail (not invoiced)

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

  • This will grey out the Warehouse Stock Levels section.

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

  • If this is not ticked then you are unable to put Singles on an Order.

Fields Generated by the System

Field

Explanation

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.