Load Receipts
- Abigail Mills (Deactivated)
Description |
This method can be called to create new receipts in SupplyStream, suitable for both standard deliveries and returns. This will create an advance ship notice of pending deliveries to the DC. |
System behaviours
- The Receipt is defined by the ASNNumber (Identifier)
- If one Line Item in the ASN returns an error (for example, 'Error Submitting Receipt: ASN030117 - Error. Product 4809019 does not exist.'), then the entire ASN fails to upload.
- If there are multiple lots of a single SKU, these will need to be separated out onto separate ASN's. A single ASN (defined by the ASN number) does not accept multiple lines of the same SKU.
- Within a single ASN, all lines need to be from the same supplier
- Once an ASN is confirmed (GRN sent), the ASN is closed. No further GRN's will be sent for this ASN.
- In a CSV file, if you have a multi line ASN, the details of the ASN (Warehouse ETA, ASN Number, etc.), but be included on every row.
Available formats
Entity Relationships
This diagram shows the high level relationship between the entities detailed in the Field Level Details section of this page.
Field level details
Receipt | ||||||
Field | Description | Data Type | Value Limits | Requirement | Use on standard documents | Field returned in service ID/table/field (multi services split by ";") |
ASNNumber | ASN reference identification code that allow the DC to identify the incoming goods. Typically one ASN per delivery (this may be a split of a PO). | nvarchar(50) | Mandatory | 13/GRN/DeliveryNumber | ||
HBReference | "House Bill" number. Open reference field. If no HBReference provided, ASNNumber populates this field. Must be unique. | nvarchar(50) | 13/GRN/HBRef | |||
WarehouseETA | The date in which the goods are expected to reach the DC. Other CSV date format options available at request. | datetime | CSV: dd/MM/YYYY e.g. 12/09/2016. Other: YYYY-MM-ddTHH:mm:ssZ e.g. 2013-10-31T00:00:00Z | |||
IsReturn | If this is a return delivery, mark this field as TRUE. If this is not specified, it will default as FALSE | boolean | true. false | Conditional: Set to TRUE if a return | ||
Notes | Note to DC. | nvarchar(4000) | ||||
UpdateReceipt | The system will look for an existing ASN in status "Create" with the specified ASN Number. If this field is set to TRUE and the ASN Number already exists, the system will remove the existing record and create a new one in its place. This will also update the line items of the receipt. ASN number must be unique in the system. | boolean | ||||
ReceiptType | Mark whether the receipt is a Standard delivery, or a return. Use either the IsReturn field, or this one. They control the same data in SupplyStream. | nvarchar(100) | Standard, Return |
ReceiptHeader | ||||||
Field | Description | Data Type | Value Limits | Requirement | Use on standard documents | Field returned in service ID/table/field (multi services split by ";") |
DCCode | SEKO created code that uniquely identifies the DC from other SEKO DC's. This code is supplied by SEKO. | Nvarchar(100) | Conditional: If more than one DC in use | 13/GRN/DCCode |
ReceiptLineItem | ||||||
Field | Description | Data Type | Value Limits | Requirement | Use on standard documents | Field returned in service ID/table/field (multi services split by ";") |
LineNumber | Integer that uniquely identifies a line of an order. Must be more than 0. Character length restriction on the Line Number is 8. For CSV, can be auto incremented if this cannot be provided, which will increment each ASN starting from 1. | int | Mandatory | 13/GRNLineItem/ LineNumber | ||
SupplierCompanyCode | Defines which supplier is delivering the goods to SEKO. SupplierCompanyCode value used can be the default SupplierCode which is assigned to all SKU's or a supplier code that is assigned to the SKU at product master level. All suppliers created are viewable via SupplyStream 'Admin→ Companies→ Suppliers' | nvarchar(100) | SKU must be assigned suppliercode | Mandatory | ||
ProductCode | The SKU that is being delivered. A ProductCode cannot be used more than once on an ASNNumber. | nvarchar(100) | Mandatory | 13/GRNLineItem/ ProductCode | ||
Quantity | The quantity of the SKU in units. 0 Quantity should not be sent, although the iHub would not reject the ASN if 0 is sent. | int | Mandatory | 11/ DeliveryArriveLineItem/ASNQuantity | ||
ReturnReason | Reason for the return | nvarchar(100) | 13/GRNLineItem/ReturnReason | |||
BestBeforeDate | Best Before Date of SKU for delivery. SKU must be a date controlled (Load Product Master: DateControlled = TRUE). Other CSV date format options available at request. | datetime | CSV: dd/MM/YYYY e.g. 12/09/2016. Other: YYYY-MM-dd e.g. 2013-12-12) | Conditional: if SKU is date controlled and operating FEFO | ||
LotNumber | Lot Number of SKU for delivery. SKU must be a lot controlled (Load Product Master: LotControlled = TRUE). Not case sensitive. | nvarchar(100) | Conditional: if SKU is lot controlled | 13/GRNLineItem/LotNumber |