Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


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:
a99645dc-5b45-4917-890c-4b02c68ac342. Returned in API response message. Must be unique to the service.






...

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:
a99645dc-5b45-4917-890c-4b02c68ac342. Must be unique to the line of the order.

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

...