General Tab

The general tab holds the most commonly used information about your product

Dimensions

This section contains the common dimensions for the product

• Singles per Unit → Singles per Case → SPC

• Units per Pallet → Cases per Pallet → CPP

• Single Size → SS - if it is not a liquid product then set this to 1

• Weight - this is the gross weight of the case (product + packaging)

• A.B.V. → Strength - this is the alocholic % strength for the item

• Litres per Unit → LOL - derived field from the SPC x SS and can also be known as the net weight.

• Unit of Issue - this field has options but defaults to cases/bottles - this is reserved for future use

Mandatory Analysis Fields

Product Analysis fields are usually setup when you take on the system, you can add to some of these tables (not the coutry table). When completing the fields you can either enter the code (if you know it) or use the F11/F12 search facility.

These fields are all used for other purposes within the system, including use on reporting within BI Enquiries where you can obtain very granular reports, so we use these fields for :

• Customs purposes

• Marketing

• Reporting

• Drinking Matrix (for wines)

• Web site

Customs Information

The only fields you need to setup within this section are

• Commodity Code - which will populate the product code type

• Duty Code

• VAT Code

All of these should be simple lookup options where you can either enter the code if known or use the F11/F12 functionality.

LWIN Additional Information

If you are performing LWIN lookup for your product codes or descriptions a number of additional fields will be retrieved from LWIN and we place this information into these fields on the product form.

At present they are present for informational purposes only and they are not currently used within the system.

User Defined Analysis

Additional analysis fields, if they mandatory fields are not enough then you can add additional analysis fields, these are shown on many of the BI Enquiry outputs along with web outputs

These can be setup through the additional analysis within maintenance and are completely user setup fields.

Warehouse Stock Levels

Information shown within this section will only show locations with stock. (e.g. Not 0/0)

The quantities displayed are Units (Cases) / Singles (Bottles)

Warehouse Stock Levels Field Explanation

Field	Explanations of the fields
On PO	How much stock is waiting to be delivered from outstanding purchase orders. This figure does not impact the available stock figure but will allow you to sell stock soon to be delivered which may put you into a -ve available
In Stock	This is the actual stock in the warehouse, so it is the physical stock and it is what we use to balance the stocks with the warehouse during the snapshot processing.
Frozen
Trading Reserve	Customer paid reserves where the customer is offering their stock for trade
Non Trading Reserve	Customer paid reserves where the customer is only storing the stock.
Unpaid Reserves
On SO
SO Held
Allocated	Allocation of orders is the commitment of that stock for an order you plan to fulfil, this also means that orders in allocated are with the warehouse awaiting picking and also will be showing in the Deliver Orders window in the Sales menu. Once you Deliver the order the order is complete and the stock is removed from the in stock figure.
Available	From your commitments this is the available stock you have available to you Within the main warehouse you are over committed by 5 singles, this is because the system will allow you to take orders for stock, it does warn you of this when placing the order and you will only be able to commit (allocate) 1 single to any of the outstanding orders.
EP PO	The EP (Advanced Orders) allows you to pre-buy stocks in advance of them becoming available and in stock, by using this type of order you can then sell these stocks in advance of them arriving. The information is shown on the screen to highlight what EPPO and EPSO you have outstanding and what you technically can still sell, and as those parcels of stock arrive into the warehouse the figures move from EPPO into the main stock figures.
EP SO
Order Available