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. |
...
This diagram shows how the SupplierCompanyCode field of this service can be used to assign a supplier to a SKU on an ASN. Otherwise, the value used can be the default supplier code which is assigned to all SKU's. You can have multiple suppliers to a product. Uploading additional suppliers using Load Product Master Updates does not overwrite previously assigned suppliers.
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. | 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. Duplicate ASNNumber rejection setting can be on, alongside this function. | 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 | |||
| GUID | SupplyStream Globally Unique Identifier. If GUID not provided, this will be automatically generated by the system. System generated example: |
...
ReceiptLineItem | ||||||
Field | Description | Data Type | Value Limits | Requirement | Use on standard documents | Field returned in service ID/table/field (multi services split by ";") |
| GUID | SupplyStream Globally Unique Identifier. If GUID not provided, this will be automatically generated by the system. System generated example: | varchar(100) | ||||
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. | 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 ASN Number. | nvarchar(100) | Mandatory | 13/GRNLineItem/ ProductCode | ||
EAN | Placeholder | nvarchar(50) | ||||
Quantity | The quantity of the SKU in units | 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 |
...