One moment please...
 
 
Exact Financials   
 

Connectivity Manual - Sales orders

Import file: orders.csv

Nr. Field name Type Format H/S/B Reference Description Remarks Default
1 linenr_lsosl INT N4 B - Order line - -
2 debtor INT N8 H debtor Debtor - -
3 item_code CHAR A20 S llitem Item - -
4 textline CHAR A2000 S - Text line - -
5 acc_nr or itemgroup-code INT/CHAR N8/A9 S ledger/lligrp Account number/Item group - -
6 quantity DEC N9,3 S lsrep Quantity - -
7 price DEC N9,3 S - Price - ?=Price defined in maintenance items
8 seqnr_lsohl INT N8 B - Order number Setting -
9 invoice_debtor INT N8 H debtor Invoice debtor - *
10 delivery_debtor INT N8 H debtor Delivery debtor - -
11 delivery_method CHAR A8 H lldome Delivery method - *
12 delivery_address CHAR A8 H delnac Delivery address - -
13 representative CHAR A8 H lsrep Representative - *
14 order_date DATE DD/MM/YYYY H - Order date - Current date
15 delivery_date DATE DD/MM/YYYY H - Delivery date - *
16 reference CHAR A30 H - Reference - -
17 reference_1 CHAR A30 H - Reference 1 - -
18 reference_2 CHAR A30 H - Reference 2 - -
19 reference_3 CHAR A30 H - Reference 3 - -
20 text_code CHAR A8 H lltext Text code - -
21 exdescr_code CHAR A2 H lldesc Extra description code - -
22 curr_code CHAR A3 H curren Currency code - *
23 exch_rate DEC N5,6 H - Exchange rate - *
24 pay_condition CHAR A4 H paycon Payment condition - *
25 sel_code CHAR A2 H - Selection code - -
26 order_discount_perc DEC N3,2 H - Order discount - -
27 cost_code CHAR A8 H llcoc Cost code - *
28 freight_costs DEC N15,2 H - Freight costs - -
29 vat_code_freight_cost CHAR A3 H vattrs VAT code freight costs - -
30 order_costs DEC N15,2 H - Order costs - -
31 vat_code_order_costs CHAR A3 H vattrs VAT code freight costs - -
32 amt_inc_vat_inc_disc DEC N15,2 H - Order amount - -
33 approved LOG Y/N H - Approved - -
34 userid_approve CHAR A12 H euser Approved by - Current date
35 on_hold LOG Y/N H - On hold - No
36 descr CHAR A40 S - Description - -
37 quantity_backorder DEC N9,3 S - Quantity backorder - -
38 vat_code CHAR A3 S vattrs VAT code - *
39 cost_center CHAR A8 S ccent Cost center - *
40 cost_unit CHAR A8 S cunit Cost unit - *
41 pricelist_code CHAR A3 S llplst Price list code - *
42 discount_type INT N6 S - Discount type 11501/11502 ?=11501
43 line_discount DEC N15,2 S - Line discount - -
44 discount_calculation INT N6 S - Discount calculation 10201/10202/10203 ?=10201
45 EXTRA-calc_rate CHAR A1 H - Exchange rate type 0/1 Setting
46 PRO-project_code CHAR A10 S prmst Project code - -
47 PRO-cost_cat_code CHAR A8 S prcat Project cost category - -
48 PRO-project_cost_center CHAR A8 S ccent Project cost center - -
49 PRO-project_descr CHAR A30 S - Project description - -

General remarks:

If the setting 'Change debtor data' in the sales settings is not activated, the following fields needs to be filled with a "?", to retrieve the default data:

# field
9 Invoice debtor
10 Delivery debtor
11 Delivery method
13 Representative
22 Currency code
24 Payment condition
27 Cost code
38 VAT code
41 Price list code

If the setting 'Change item data' in the sales settings is not activated, the following fields needs to be filled with a "?", to retrieve the default data:

# field
7 Sales price
36 Description

Clarification of the fields:

# clarification
1 0 for headers, ? for sublines (the first available line number will be taken.)
3 This item should be marked as 'Sales' item or 'Both'.
5 This line is only used when you want to enter a sales order for a text line. In the sales settings in [Sales: File, Company settings, Sales settings], you can indicate whether you want to keep revenue statistics of text lines. If you have activated this option, an item group should be entered in this field. If you did not activate this option, a ledger account should be entered here.
9 The invoice debtor linked to the debtor (field 3) is used as default. If no invoice debtor is linked to the debtor, the debtor will be used.
11 If a "?" is entered, the delivery method linked to the debtor will be used.
13 If a "?" is entered, the representative linked to the debtor will be used. If no representative is linked to the debtor, the representative defined in the sales settings will be used.
15 Delivery date = order date + number of delivery days defined in Sales settings.
22 When entering a "?", the currency code linked to the invoice debtor will be used as default. In case no default code is linked, the currency code defined in the settings will be used.
23 When entering a "?" the current exchange rate will be used.
24 When entering a "?", the payment condition linked to the invoice debtor will be used as default, if no payment condition is linked, the payment condition defined in the settings will be used.
27 When entering a "?", the cost code linked to the invoice debtor, will be used as default. If no cost code is linked and you enter, the cost code defined in the settings will be used.
28-31 If you have entered a cost code in field 28 and you enter a "?" in these fields, the fields will automatically be calculated. If the field 'Cost code' is left empty these fields can be filled manually. Please mind that the VAT codes should be of the type 'Sales' or 'Both'.
33 If the setting 'Approve sales order' is disabled, this field will be ignored.
34 If you enter a "?", the current user will be the approver of the invoice.
37 If the quantity entered in field 6, quantity, is larger than the quantity that is on stock, the quantity ordered that is not in stock will automatically be put in backorder.
38 If "?" is entered, the VAT code linked to the invoice debtor will be used as default.
39 If "?" is entered, the cost center linked to the representatives will be used as default. If no cost center is linked to the representative, the cost center defined in the sales settings will be used as default.
40 If "?" is entered, the cost unit linked to the item group will be used as default.
41 If "?" is entered, the price list linked to the debtor will be used as default.
42 11501 = Discount is percentage (Used as default when "?" is entered.)
11502 = Discount is amount
44 10201 = Price list discount over line discount(Used as default when "?" is entered.)
10202 = Line discount over price list discount
10203 = Price list discount plus line discount
45 If you want to use Anglo-Saxon notation (Euro notation) for exchange rates you should enter 1, if you want to use the 'old' exchange rate enter 0. If this field is left empty, the settings you defined in the financial preferences in [Finance: File, Company settings, Financial preferences] on the 'Miscellaneous' tab will be used.
46-49 These fields will only be filled if you defined in [Finance: File, Company settings, Financial preferences] that a project link is optional or mandatory and the ledger account involved is marked as a project account. In case you have set this option to 'Optional' it is possible to import project data. In case you have set this option to 'Mandatory' the entry will be rejected if you do not enter project data.

Connectivity > Data import > Available import formats > Sales > Sales orders

     
 Main Category: Support Product Know How  Document Type: Support - On-line help
 Category: On-line help files  Security  level: All - 0
 Sub category: Details  Document ID: 18.326.087
 Assortment: Exact Financials  Date: 03-10-2015
 Release:  Attachment:
 Disclaimer