Page Comparison

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

PDF

Available

CSV

Available

XML

Available

File Name Convention

SiteCode_CustomerCode_StkPrdt_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, this will be introduced from April 2017 onwards

Field Name

Length

CSV

XML Segment

Notes

Customer Code

8

Y

LD

Your customer code with the warehouse

Product Code

50

Y

LD

Product Description

50

Y

LD

Description from the Product table and could be different to the stock level description

Earliest Date Received

10

Y

LD

Date Received of Earliest Stock

Last Date Received

10

Y

LD

The last date stock was received for this product

Singles Per Case

5

Y

LD

This will use the Product Singles per case as the product default.

Present Cases

6

Y

LD

The present stocks figures are the total available stock holdings at the time of the extract and do NOT include items which are frozen.

To find your total stock in bond you need to add the Present and Frozen case figures together.

Present Singles

6

Y

LD

Total Present Singles

6

Y

LD

Frozen Cases

6

Y

LD

Frozen Stocks which are NOT included in the Present Cases figures.

Frozen Singles

6

Y

LD

Total Frozen Singles

6

Y

LD

Allocated Cases

6

Y

LD

From Orders Received but not despatched yet including items which are on hold with the warehousing system but will not include EDI orders where order has been held due to EDI format error

Allocated Singles

6

Y

LD

Total Allocated Singles

6

Y

LD

OACases

6

N

LD

Order Available Cases / Singles and Total in Singles

This takes stock less frozen less allocated to provide a figure of what is available to order.

OASingles

6

N

LD

OATSingles

6

N

LD