2. Rotation Stock

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.

This will list all rotations, so product codes will be shown multiple times, one time for each rotation

The report can be scheduled to run automatically on a daily, weekly or monthly basis or you can schedule this via the VCIS site.

The stock file will normally be emailed to your email address(es) as an attachment to an existing message.

SiteCode_CustomerCode_StkRotn_datetime         [.csv]     [.xml]    

Products with ZERO stocks will not be included in this export, this will be introduced from April 2017 onwards

As Vision Warehousing can store Rotations with varying levels of singles per case, at rotation level you get the information stored for each rotation.

CSV Field Name

(Reference Only)

Length

Notes

Customer Code

8

Your customer code with the warehouse

Product Code

50

Product Description

50

Rotation Number

10 or 15

Rotation Number in the format  YY/Dnnnnnn and where rotation line number are in use then YY/Dnnnnnn/nnnn.  The 15 digit format is only used when necessary, normally only shows 10 digits unless a line number exists.

Date Received

10

Singles Per Case

5

Present Cases

6

Whole numbers only, no decimal places, this will be calculated using the rotation level record singles per case

Present Singles

6

The remainder of stock which is in addition to the number of cases in stock, this will be calculated using the rotation level record singles per case

Total Present Singles

6

A total amount in single items.

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.

Frozen Cases

6

Whole numbers only, no decimal places

Frozen Bottles

6

The remainder of stock which is in addition to the number of cases in stock

Total Frozen Bottles

6

A total amount in single items.

Duty Paid

3

Yes or No indicator whether the items have duty paid.

Reserve Customer Code

8

Only completed is the stock has a reserve customer code allocated

BBD

10

Best Before Date

Year

4

Alternatively ‘vintage’

Batch

30

Your batch number (if known)

Free Circulation

3

Free Circulation - Yes / No  - is customs duty paid

OWC

3

Original Wooden Case – Yes / No

DS

3

Duty Stamped - Yes / No

XML Segment

XML Element

XML Element

(Future Change)

Length

Notes

<HD>

<CustomerCode>

8

Your customer code with the warehouse

<ProductCode>

50

<Description>

50

</HD>

<LD>

<Rotation>

10 or 15

Rotation Number in the format  YY/Dnnnnnn and where rotation line number are in use then YY/Dnnnnnn/nnnn.  The 15 digit format is only used when necessary, normally only shows 10 digits unless a line number exists.

<DateReceived>

10

<SPC>

5

<PC>

6

Whole numbers only, no decimal places, this will be calculated using the rotation level record singles per case

<PS>

6

The remainder of stock which is in addition to the number of cases in stock, this will be calculated using the rotation level record singles per case

<TotalS>

6

A total amount in single items.

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.

<FzC>

6

Whole numbers only, no decimal places

<FzS>

6

The remainder of stock which is in addition to the number of cases in stock

<TotalFzS>

6

A total amount in single items.

<ExciseDP>

3

Yes or No indicator whether the items have duty paid.

<Reserve>

8

Only completed is the stock has a reserve customer code allocated

<BBD>

10

Best Before Date

<Year>

4

Alternatively ‘vintage’

<Batch>

30

Your batch number (if known)

<CustomsDP>

3

Free Circulation - Yes / No  - is customs duty paid

<OWC>

3

Original Wooden Case – Yes / No

<DStamp>

3

Duty Stamped - Yes / No

</LD>