...
| Table of Contents |
|---|
...
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 lookup fields which are all pre-defined in advance when the system is initially setup. If you do not fill these fields then BI analysis of your sales will be made difficult.
The system has 5 mandatory fields Country/Region/Style/Type/Group and there are a further 6 optional user-defined fields (UDF) which you can choose to use.
Customs Information
LWIN Additional Information
User Defined Analysis
Warehouse Stock Levels
The information shown here in the grid is displayed per Warehouse Group. All the figures 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
The fields are all mandatory you must select one of the options when you setup a product
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
| Info |
|---|
You require the licensed LWIN module for these fields to be auto populated. |
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.
There is a plan to add these to the web API
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)
Special Fields: Unpaid Reserve is highlighted in yellow if this is being used as this will affect the order available figure, although the stock is in the Warehouse you may not wnat to allocate it to another Customer.
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 |