2103 Product Stock Enhanced

Overview

A stock snapshot can be created to provide customers with stock information at the time of day it has been run. This data can be used to run stock comparisons and reconciliations or just as a general stock sheet.

The By Product version is great for customers not using rotation numbers for ordering or where they are looking to balance Product to Product

File Name Convention

SiteCode_CustomerCode_StkPrdtE_datetime

Limitations

This is a summary by product, there is no reference to individual rotations within this export.

Stock is considered as stock in warehouse and is not available to order quantities

Products with ZERO stocks will not be included in this export.

Last Updates

We will only show entries highlighting changes which are less than 2 years old

Date	Change

Date	Change

Example Output

PDF

CSV

XML

XML Specification

Segment	Element	Length	Description	Notes
<LD>
	<CustomerCode>	8	Customer Code	Your customer code with the warehouse
	<Site>	6	Site Code	Stock holding customer site code
	<ProductCode>	50	Product Code
	<Description>	50	Product Description	Description from the Product table and could be different to the stock level description
	<FirstDate>	10	Earliest Date Received	Date Received of Earliest Stock
	<LastDate>	10	Last Date Received	The last date stock was received for this product
	<SPC>	5	Singles Per Case	This will use the Product Singles per case as the product default.
	<PC>	6	Available Cases	The available stocks figures are the total available stock holdings at the time of the extract and do NOT include items which are frozen. NOTE : To find your total stock in bond you need to add the Present and Frozen case figures together.
	<PS>	6	Available Singles
	<TotalS>	6	Total Available Singles
	<FC>	6	Frozen Cases	Frozen stocks are those where an amount of stock is being held or blocked from being used. Frozen Stocks which are NOT included in the Present Cases figures.
	<FB>	6	Frozen Singles
	<TotalFS>	6	Total Frozen Singles
	<AC>	6	Allocated Cases	Allocated Stocks - ( this figure is included within the available stock figure - to find free stock then Available - Allocated) Generated from Orders Received but not picked yet including items which are on hold with the warehousing system Will not include EDI orders where order has been held due to EDI validation
	<AS>	6	Allocated Singles
	<TotalAS>	6	Total Allocated Singles
	<PSS>	8.5	Product Single Size
	<PCPP>	5	Product Cases per Pallet
	<PYear>	4	Product Year
	<PPackCd>	8	Product Packaging Code
	<PPAckDesc>	50	Product Packaging Description
	<TotalSUBAv>	8	TSingles UB Available	Total in Singles of the available singles which are underbond
	<TotalSDPAv>	8	TSingles DP Available	Total in singles of the available singles which are duty paid.
	<TotalSUBFz>	8	TSingles UB Frozen	Total in Singles of the frozen singles which are underbond
	<TotalSDPFz>	8	TSingle DP Frozen	Total in singles of the frozen singles which are duty paid.
	<PBrand>	50	Product Brand
</LD>