...
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.
Operationally an order could be picked over more than a single output file, as this is based on the pick confirmation of each line of the order, also bear in mind you may order a product but we may be picking this across several rotations so several lines may appear in the output for the same one product line you sent to the warehouse.
Order picked confirmation is generated when the stock movement takes place, this is slightly different depending on whether Distribution is in use, if this is not in use then it is generated when the order is marked as collected or despatched and in the event that you have underbond activities then the duty has to be posted onto the bond system. In the event you use distribution then anything being picked is for onward delivery and the pick confirmation point is used to trigger the stock movement posting and bond posting (where applicable)
Only when the stock movement posting is complete will the orders picked confirmation be produced.
...
Available
...
| View file | ||
|---|---|---|
|
CSV
...
Available
...
| View file | ||
|---|---|---|
|
...
XML
...
Available
...
| View file | ||
|---|---|---|
|
...
File Name Convention
...
SiteCode_CustomerCode_OrdPckd_datetime
...
Limitations
...
None
...
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.
CSV Field Names & Content
Field Name | SizeCSV | XML Segment | Notes | |||
Customer Code | 8 | Y | HD | |||
DP Account Ref | 8 | Y | HD | Normally your customers account code | ||
Document Reference | 30 | Y | HD | Your unique order reference | ||
ProductCode | 30 | Y | LD | |||
RotationNumber | 15Y | LD | ||||
Cases | 10 | Y | LD | |||
Singles | 10 | Y | LD | |||
LineNumber | 6 | Y | LD | Your line number sent to the warehouse in your sales order file. | ||
OrderDate | 10 | Y | HD | |||
ExciseDuty | 15Y | LD | How much excise duty for this line
| |||
CustomsDuty | 15Y | LD | How much customs duty for this line
| |||
VAT | 15 | Y | LD | How much VAT was calculated for this line
| ||
TotalCharge | 15 | Y | LD | The delivery charge for the goods from this line of the delivery, it takes the overall value, number of overall cases and proportions the charge equally on each line | ||
InvoiceCases | 10 | Y | HD | This is the total invoice cases for the overall delivery | ||
LineInvoicecases | 12.3Y | LD | When calculating the transport charge each line is calculated and then added together to provide an overall total invoice cases value. This is the individual line value | |||
DeliveryType | 6Y | HD | This will be HMRC order types shown in this field, such as:
| |||
TotalSingles | 10 | Y | LD | The total number of singles confirmed picked for this order line | ||
DP Reference | HD | |||||
Batch Ref | LD | |||||
SO Notes | LD | |||||
PCCNHD/PC | This section can be repeated multiple times one time for each | |||||
PCNameHD/PC | ||||||
SSCC | LD/SSCC | A repeating element which will be provided one time for each SSCC for this product line |
XML Format
Segment / Element
Notes
<PICK>
Repeats for each picked order
<HD>
Appears one time for each order
<CustCode>
<OrdRef>
<DocRef>
<Type>
<ODate>
<ICase>
<DPCRef>
<PC>
Parcel carrier confignment section - only appears if needed, can be repeated as some carriers issue multiple numbers per item
<PCCN>
Consignment Number
<PCName>
Parcel carrier name
</PC>
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>
<Rotation>
<Case>
<Single>
<TSingle>
<CLineNo>
<ExciseD>
<CDuty>
<VAT>
<DCharge>
<LICase>
<Batch>
<SOLnNt>
<SSCC>
This element will repeat for each SSCC on the order.
</LD>
EOS
</PICK>