Versions Compared

Key

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

Overview

A confirmation of stock losses.

Format

The report is in csv format, which means it can be read into your system or can be opened in excel.  It is also available in PDF format.

Delivery & Scheduling

The report can be scheduled to run automatically on a daily, weekly or monthly basis or it can be requested via the web site on an ad-hoc real time basis.

...

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

File Name Convention

The filename will be

SiteCode_CustomeCode_StkLoss_datetime.      (xml or csv)

Limitations

Each time the report is sent, only stock losses which you’ve not already been informed of will be included.

 

 

 

 

CSV Field Names & Content

 

Field Name

Length

Comments

CustomerCode

8

 

CustomerName

30

 

ProductCode

50

 

ProductDescription

50

 

RotationNumber

13

 

Package

12

 

Ref

10

 

DateLostInStore

10

 

CasesLost

10

 

SinglesLost

10

 

LitresOfLiquid

18

 

LitresOfAlcohol

18

 

TaxCode

3

 

Reason

150

 

           

 

 

XML Field Names & Content

File Identifier - <StkLoss>

...