Versions Compared

Key

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

Name Convention

WhStkPd

Limitations

Products with ZERO stocks will not be included in this export

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

Overview

A simple and compact warehouse stock snapshot by product.

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 products only , so no rotations will be shown

The purpose of this service is to provide the live order status within the warehouse for a given reference of your own.

All stock orders will show an order status however there are three key types

  • Transfer order which is considered complete when the transfer takes place

  • Collection from warehouse which is considered complete when an order is collected

  • Deliveries by the warehouse which is considered complete when the order is pick confirmed.

If you are looking to confirm orders for invoicing you should look at the order pick confirmation which is a consistent point (also the duty point) for the order as the status not definitive and can be rolled back.

Name Convention

API Only

Limitations

Fields from MST onwards are only available if the warehouse are performing the delivery for any collections this information will be missing as they will not be known

Last Updates

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

Date

Change

 

 

 

 

Example Output

PDF

CSV

XML

2131

2311 XML Specifications

XML Segment

XML API Element

Length

Notes

<WhStkPd>

<P>

<PC>

50

Product Code

<TS>

6

Total Singles in stock

A total amount in single items, including stocks which are currently frozen.

For available stock consider using https://visionsoftware.atlassian.net/wiki/pages/resumedraft.action?draftId=2787377153 instead.

<SC>

5

Singles per case

</P>

</WhStkPd>

Notes

<T>

<R>

Order/pick record - can repeat

CCO

Customer code - Your warehouse account reference

SCO

Site code - The site code where your account is based at the warehouse

DRF

Document reference - Your reference for the order

ORH

Order UID - The warehouse reference for your order

SPH

Pick UID - The warehouse pick reference for the order

PCF

Pick confirmed - Have the warehouse finished the pick?

MST

Delivery manifest status

Generic statuses for all WMS systems : Outstanding / Despatched / Delivered

Each warehouse have other statuses they use; so consider that this could be free text.

PDD

Planned delivery date

FT1

Original ETA window from time

TT1

Original ETA window to time

FT2

Revised ETA window from time

TT2

Revised ETA window to time

ATD

Actual time of delivery - includes both the date and time

POD

Is the POD ready to be requested using 3. POD?

</R>

</T>