2341 Reserve Customers Orders Picking Confirmation

 

Notes

 

 

Notes

 

Overview

This output is used to show the previous picked order lines, also the amount or value that was charged for the excise and customs duty etc.

If you duty defer your order you will still see an entry here as this shows what was picked from YOUR stocks.

Only when the stock movement posting is complete will the orders picked confirmation be produced.

File Name Convention

SiteCode_CustomerCode_ROrdPckd_datetime

 

Limitations

This is designed for confirmation to the reserve customer.

You need to schedule this report and the flag in reserve customers marked as REPORT will be used to generate the report for the user, whichever Reserve reports you schedule the customer will receive all of them.

If you ask for a daily report then you will be sent the previous days information

If you ask for a weekly report then you will receive information for the previous week

If you ask for a monthly report then you will receive information for the past month.

If you select to receive this to a contact within VW Customer Contacts be aware that this address will receive a copy of all the outputs generated e.g. If you have 4000 reserve customers that email will receive 4000 emails !!!

Use the Reserve customer REPORTS flag !!

API request for an individual confirmation are possible but follow the same pattern in relation to “you will only get new information”

Notes

You should be aware that when the picking confirmation file is returned to you that there can be multiple lines for a single product ordered, as the picking stage may pick from multiple rotations.  All lines will have the same sales order line number and the overall quantity will be what you ordered.

Last Updates

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

Date

Change

Date

Change

 

 

 

 

Example Output

PDF

CSV

XML

XSD

 

2341 XML Specifications

Record

Segment

Element

Sub Element

Notes

Record

Segment

Element

Sub Element

Notes

<PICK>

 

 

 

Repeats for each picked order

 

<HD>

 

 

Appears one time for each order

 

 

<CustCode>

 

Stock holding warehouse customer code.

 

 

<OrdRef>

 

Warehouse unique order reference.

 

 

<DocRef>

 

The doc ref you provided on the inbound Order EDI

 

 

<Type>

 

Type of Movement - see link

Code Lists | A Order Type

 

 

<ODate>

 

Order Date

 

 

<ICase>

 

Distribution - if the warehouse are carrying out the delivery this is their calculated Invoice Case charge for the entire order.

 

 

<DPCRef>

 

Delivery Point customer reference

 

 

<PCon>

 

Parcel carrier consignment section - only appears if a collection group is specified, can be repeated as some carriers issue multiple numbers per item

 

 

 

<PCCN>

Consignment Number

 

 

 

<PCName>

Parcel carrier name

 

 

</PCon>

 

EOS

 

</HD>

 

 

EOS

 

<LD>

 

 

This repeats for each pick item on the order. You may find you sent a single order line to the warehouse but they picked it from multiple rotations to fulfill the order

 

 

<PCode>

 

Product Code

 

 

<Rotation>

 

Rotation Number - this will include the line number if there is one applicable. Format YY/nnnnnnn/nnnn
If you only wish the bsde rotation then this is a fixed length of 10 characters. [LEFT 10]

 

 

<Cases>

 

Quantity of Cases

 

 

<Singles>

 

Quantity of Single items.

 

 

<TSingles>

 

Total quantity in single items
(Cases x SPC) + Single Items

 

 

<CLineNo>

 

Customer Line number, this is supplied to the warehouse within the sales order file from the customers system, so it can be used to identify your line number from your original order.

 

 

<ExciseD>

 

Only if there is excise duty to be paid on this movement will the figure be shown, otherwise will show as 0.00

 

 

<CDuty>

 

Only if there is customs duty to be paid on this movement will the figure be shown, otherwise will show as 0.00

 

 

<VAT>

 

Based on the value for VAT element which includes cost prices plus duty to obtain the value for vat

 

 

<DCharge>

 

Distribution - if the warehouse are charging for the delivery this is the total charge for the delivery

 

 

<LICase>

 

Distribution - This is the line invoice proportion for this product line

To calculate the delivery charge for this specific line use :

LICase / ICase * DCharge = delivery cost for this line

 

 

<Batch>

 

The batch number field from the stock receipt into the warehouse, will only be populated if recorded on the warehouse receipt.

 

 

<SOLnNt>

 

Output of the SO Incoming EDI field LO1 which contains - SO Line Notes - As per SO XML Structure | XML LO (Line Options) Segment Only provided if there is anything in the field which is populated through EDI inbound.

 

 

<SSCC>

 

This element will repeat for each SSCC on the order with a comma seperating each of the SSCC codes. This field is MAX length so no restriction on the size of it.

 

</LD>

 

 

EOS

</PICK>

 

 

 

EO can be followed by another <PICK>

 

 

 

 



Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.