The general tab holds the most commonly used information about your product
Some of the fields can only be set when creating a new product and can never be modified.
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
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
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)
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 | This shows stock which has been reserved for customers, these reserves as UNPAID and are considered soft reservations, because in theory you could provide the stocks to others as long as you know you will restock in time to fulfill this promise.  As the customer places orders for the product they have on reserves the system will ask |
On SO | All orders which are not held or allocated. |
SO Held | All orders which are held and not allocated. |
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. It takes into accont frozen, unpaid reserves, on SO, SO Held, allocated |
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 | This is what you will be able to use on the order after taking into account all the other fields, its a calculated field. This will normally be BLUE coloured, but will display in yellow when you have an unpaid reserve for this stock as technically you can provide the order available stock but you would compromise your unpaid reserve promises. So it is a business decision if you plan to use up your unpaid reserves ! Can you restock in time to fulfill the promises made…… |