Page Comparison

This is a description of the template for excel file order creation for multi customer orders. This template is called "Multikundorder - orderspec 2.0".

Namn

Parameters

Description

Example

Mandatory

ClientId

The short name of the client that owns the order.

Client name: "Stjärna"

Client short name: "STJ"

Note
You must be sure of which short name to write so the order ends up in the right client system.

Yes

Orderno

Order number

An a available order number.

Info
It is not possible to enter the same order number again, the registrant must check for available order numbers and prefix in XTND Backend.

"OC-111222"

"12345678"

Yes

OrderDate

Orderdate

ÅÅÅÅ-MM-DD hh:mm

No

Orderreference

Order reference.

Printed as "Your Reference" on order header.

"Anders Andersson"

CustomerNo

Customer numberThe customer number of the customer that has ordered the products.

"17"

Info
If entering a customer number that don not exists, the customer will be created. (Duplicates are not allowed). Do not mix and create new customers with existing ones.

Yes

DeliveryMethod

Agreed The short name of the available mode of transport for the client and customer.

"SCHPAR"

If you want to specify another delivery method, the abbreviation for the delivery method must be specified, it must be a valid way for the client. If you do not specify anything, default delivery method will be set for the order

Note
Info
You can find the short name of the delivery method you desire under the gearwheel in XTND Backend > Generel settings > Transport settings.

No

DeliveryName1

Name for delivery adress, row 1.

Yes

DeliveryName2

Name for delivery adress, row 2.

No

DeliveryAddress1

Adress for delivery adress, row 1.

Yes

DeliveryAddress2

Adress for delivery adress, row 2.

No

DeliveryAddress3

Adress for delivery adress, row 3.

No

DeliveryPostalCode

Postal code for delivery adress.

"12345"

Note
Postal code must be without spaces.

Yes

DeliveryCity

City, for delivery adress.

Stockholm

Yes

DeliveryState

Delivery state.

Type the state if needed or leave empty.

No

DeliveryCountry

County for delivery adress.

Type the state as "SE" or "NO"

Yes

PhoneNumber

Telephone number of recipient or notification service if such is included with the mode of transport.

Type the phone number if needed or leave empty

Info
Telephone numbers are also saved on the customer for new customer arrangements. On orders, they are saved by telephone and printed on orders under your reference. (in ConsumerOrder as Phone in ShipTo).

No

InvoiceName

Name for invoice adress.

Yes

InvoiceAddress1

Adress for invoice adress, row 1.

Yes

InvoiceAddress2

Adress for invoice adress, row 2.

No

InvoiceAddress3

Adress for invoice adress, row 3.

No

InvoicePostalCode

Postal code for invoice adress.

Yes

InvoiceCity

City for invoice adress.

Yes

InvoiceState

State for invocie adress.

No

InvoiceCountry

Country for invoice adress.

Yes

AskedDeliverydate

Desired delivery date (ÅÅÅÅ-MM-DD tthh:mm).

Yes

VATno

VAT number.

Note
Only to be filled in for new layouts by a new customer.

No

OrgNo

Organisation number.

Note
Only to be filled in for new layouts by a new customer.

No

GoodsNotification

Goods notification.

Printed as Freight Marking on orders. (In ConsumerOrder as MKS on head)

No

PaymentType

Type of payment. Entered as:

INV: BILLING

AUTO: AUTOGIRO

ADV: ADVANCEPAYMENT

FAC: FACTORING

CAS: CASHPAYMENT

LAS: LASTSCHRIFT

CC: CREDITCARD

MOH: MANUALONHOLD

FAM: INVOICEME

Yes

FreightFree

Freight free or not.

0: Freight

1: Freight free

Yes

RowCounter

Number of rows in the order.

Info
If there are 3 lines with the same order number, a 3 is written on each line for the order.

Yes

Orderposition

Order line position.

Fill in if you want a special order on the rows.

No

Item

Product numer.

Note
Product must be stored in XTND Backend and linked to price list, warehouse and supplier agreement.

Yes

ItemName

Product name.

Info
This will overwrite existing description.

No

Quantity

Ordered quantity.

Always written in integers.

Yes

Unit

Sales unit.

Note
The unit must be set in XTND Backend and connected to the product and a price list.

Yes

PriceexVAT

Price ex VAT per unit.

Note
If price is indicated on a row, all rows in the column must be registered with price.

No

VATPercentRow

VAT in percent.

Note
If VAT is entered on a row, all rows in the column must be registered with VAT.

No

Currency

Currency as in ex. SE, DKK or NOK.

Note
The currency must be on an active price list for the customer.

Yes

Notes

Notes for order.

Info
Written as order line listing on order document. (In ConsumerOrder as MKS)

No

OrderEmail

Email for order confirmation.

"anders.andersson@andersson.se"

No

InvoiceEmail

Email for invoice.

No

Warehouse

Warehouse that's connected to the product.

No

OrderReviewReasonNotes

No

Versions Compared

Old Version 7

New Version 8

Key