Versions Compared

Old Version 2

changes.mady.by.user Alan Gilchrist

Saved on

compared with

New Version Current

changes.mady.by.user Alan Gilchrist

Saved on

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 for a given warehouse reference

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

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

<T>

<R>

Will repeat for each order

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