Versions Compared

Version Old Version 8 New Version 9
Changes made by

Alan Gilchrist

Alan Gilchrist

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


This is a proposed format - this is not available at this current time


Notes
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

Format (including file extension)XML (.XML)
PDFNot available
Delivery & Scheduling

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.

File Name Convention

SiteCode_CustomerCode_MSStkPt_datetime      . <extension>

Limitations

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

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

One line has to be created for each product per site because a product does not have to have the same dimensional information between their setup for each site, therefore it was impossible to get any common fields other than the product code.

Field Names & Content for Product Level File 

Segment

Segment

L1

Segment

L2

Notes<MStkProd><LD>This repeats many times within the StockProd</LD></MStkProd>

XML Segment Name

XML Element Name

Length

Description

Notes

<LD>

<CustomerCode>

8

Customer Code

Your customer code with the warehouse

<Site>6Site CodeStock 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 In Stock 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 in stock Singles

<TotalS>

6

Total  Available Singles in stock

<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.

<FS>

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.5Product Single Size<PCPP>5Product Cases per Pallet<PYear>4Product Year<PPackCd>8Product Packaging Code<PPAckDesc>50Product Packaging Description<TotalSUBAv>8TSingles UB Available

Total in Singles of the available singles which are underbond

<TotalSDPAv>8TSingles DP AvailableTotal in singles of the available singles which are duty paid.<TotalSUBFz>8TSingles UB FrozenTotal in Singles of the frozen singles which are underbond<TotalSDPFz>8TSingle DP FrozenTotal in singles of the frozen singles which are duty paid.<PIPC>8Pick in Progress Cases

This is any orders which are in the progress of being picked, they are beyond the point of edit or cancellation.

<PIPS>8Pick in Progress Bottles<TotalPIPS>8Pick in Progress Total Singles<PBrand>50Product Brand<TRAC>8Transfer In Cases

This is cases where a pre-advice is entered which is a "TRA" or Transfer from another site.

It will only identify the product where the product code is known.

The TRA is generated when the goods are confirmed picked in the sending warehouse, which means they will be removed from the sending warehouse.   

This stock has still not arrived in the warehouse but is expected, any order sent for stock which is in Transit will result in an insufficnet stock message until it has arrived and is landed in stock.

<TRAS>8Transfer In Singles<TotalTRAS>8Transfer In total in singles</LD>