...
Company name - For Load Web Sales Order (LWSO), it automatically add “Web Order” in this field
ShipToCompany | |||
Field | Description | Requirement | Documents where it appear |
CompanyCode | Unique ship to code that can be used to retrieve company details. | Mandatory for LSO; not required for LWSO (web Orders) | |
With "On the fly company creation" turned on: | |||
If the code is an existing code in SS, the company description supplied in the order will be ignored | |||
If the code is new, the company description will be taken from the order, and stored on SS for all future orders that use this code. | |||
CompanyDescription | The name of the company delivering to. See section "The 'On the fly' company code creation function" on this page for more details on using this. | Mandatory for LSO; not required for LWSO (web Orders) | Dispatch Note, Commercial Inv |
DeliveryDetails | |||
Field | Description | Requirement | Use on standard documents |
FirstName | First name of the delivery contact. If provided, this value will take presidence over the CompanyDescription on some carriers address labelling, such as Hermes. | Dispatch Note, Commercial Inv, Pick Note | |
LastName | Last name of the delivery contact | Dispatch Note, Commercial Inv, Pick Note | |
Line1 | Line 1 of the delivery contacts address | Mandatory | Dispatch Note, Commercial Inv, Pick Note |
Line2 | Line 2 of the delivery contacts address | Dispatch Note, Commercial Inv | |
Line3 | Line 3 of the delivery contacts address | Commercial Inv | |
Line4 | Placeholder | ||
City | City of the delivery contacts address | Mandatory | Dispatch Note, Commercial Inv, Pick Note |
County | County of the delivery contacts address | Mandatory | Commercial Inv, Pick Note |
PostcodeZip | Postcode of the delivery contacts address. Postcode is not validated by the SEKO system | Mandatory | Dispatch Note, Commercial Inv, Pick Note |
CountryCode | Country of the delivery contacts address (ISO-2 or ISO-3). | Mandatory | Dispatch Note, Commercial Inv, Pick Note |
Appears on standard physical docs as full country name. | |||
PhoneNumber | Phone number of the delivery contact | Conditional: required by some carriers | Commercial Inv |
Used by some carriers to send customer SMS notifications | |||
FIrstName or LastName required. | |||
The phone Number will be saved at company level, rather than contact level, unless a first name/last name is provided. For the Phone Number to be visible on the Commercial Inv, this would need to be contact level. | |||
EmailAddress | Email address of the delivery contact | Conditional: required by some carriers | |
Used by some carriers to send customer email notifications | |||
FIrstName or LastName required. | |||
The Email Address will be saved at company level, rather than contact level, unless a first name/last name is provided. For the Email Address to be visible on SS, this would need to be contact level. |
...
Billing Details
For Commercial Invoice purpose
Field | Description | Requirement | Documents where it appear |
FirstName | First name of the billing contact. | Conditional: If billing address Line1 is provided and for commercial inv | Commercial Inv |
LastName | Last name of the billing contact | Commercial Inv | |
Line1 | Line 1 of the billing contacts address | Conditional: for commercial inv | Commercial Inv |
Line2 | Line 2 of the billing contacts address | Commercial Inv | |
Line3 | Line 3 of the billing contacts address | Commercial Inv | |
Line4 | Line 4 of the billing contacts address | ||
City | City of the billing contacts address | Conditional: for commercial inv | Commercial Inv |
County | County of the billing contacts address | Commercial Inv | |
PostcodeZip | Postcode of the billing contacts address | Conditional: for commercial inv | Commercial Inv |
CountryCode | Country of the billing contacts address | Conditional: for commercial inv | Commercial Inv |
Appears on physical docs as full country name (ISO-2 or ISO-3). | |||
PhoneNumber | Phone number of the billing contact | ||
EmailAddress | Email address of the billing contact |
Retail Compliance
Add only if it is Client requirement
...
Line Items
Field | Description | Requirement | Documents where it appear |
LineNumber | Integer that uniquely identifies a line of an order. Must be more than 0. Character length restriction on the Line Number is 8 . | Mandatory | |
The SEKO 360 system will order the line items by ascending LineNumber. For CSV, can be auto incremented if this cannot be provided, which will increment each sales order starting from 1. | |||
ProductCode | SKU to be dispatched. Must be unique per sales order. There must be available stock on the SKU. | Mandatory | Dispatch Note, Commercial Inv |
OrderLineMessage | Message assigned to the SKU on line level used for non standard requirement (such as engraving, where the engrave message would appear in this field) | ||
Quantity | Quantity of the SKU to be dispatched in units. Line Item Quantity needs to be greater than zero. Unit quantity should match the inbound quantity (EACH) | Mandatory | |
UnitPrice | The price of the unit (per unit) i.e. 4.99. Ex VAT if VAT field is provided in separate VAT field. Unit price should not be 0 if required by carrier or Commercial Invoice required. Unit Price is recalculated on short shipment. | Conditional: if required for shipping | Commercial Inv |
If VAT is populated | |||
VAT | The VAT of the unit (per unit) i.e. 0.67. This is added together to the Unit Price * Quantity value in the "Amount" column on the standard commercial invoice. | Conditional: When required for the carrier | |
(UnitPrice * Quantity) + (VAT * Quantity) = Amount | |||
VAT is recalculated on short shipment. | |||
As a note, if supplying VAT irrespective of DDU/DDP, the unit value must be NET not GROSS. | |||
If “SalesOrderLineItem.Vat” is greater than zero then “SalesOrderLineItem.UnitPrice” is required | |||
CurrencyCode | The currency code of the unit price. Use the same code for the entire order. | Conditional: if UnitPrice or VAT are populated | Commercial Inv |
...
Custom Settings (Backend)
Column Name | Notes |
AllowShipToCompanyCreate | If set to True this will automatically create "Ship To" companies on the fly. |
DuplicateSalesOrderNumberCheck | If set to True this will prevent loading sales orders with a SalesOrderNumber that has previously been used. |
LookupDeliveryAddress | If set to True this will automatically lookup a delivery address. |
DuplicateSOLineNoCheck | If this is set to “True”, then Clients with the "Duplicate Sales Order Number" check enabled should still be able to load Sales Orders with the same Sales Order Number as long as all the Line No's are different. |
ForceOrderRelease | If this is set to “True”, then Clients can still have a dispatch created from the Sales Orders they load as long as some or all of the stock is available. |
DuplicateSKU | If this is set to “True”, then Clients can load the Same SKU on multiple lines when loading Sales Orders |
KitToOrder | If this is set to “True”, Seko 360 will automatically attempt to assemble kits if there is no kit in stock. |
LSO/LWSO Process
Assign Service to Client
...