One moment please...
 
 
Exact Financials   
 

Connectivity Manual - Items

File name: items.csv

Nr Field name Type Length Ref. Description Remarks Default
1 item_code CHAR A20 - Item code - -
2 descr CHAR A40 - Description - -
3 short_desc CHAR A13 - Short description - -
4 item_type INT N6 - Item type 23901/23902/23903 See below
5 itemgroup_code CHAR A8 lligrp Item group Mandatory -
6 unit_code CHAR A8 units Unit Mandatory -
7 stock_item LOG True/False - Stock item - ?=False
8 vat_code_sales CHAR A3 vattrs VAT code sales - -
9 revenue_statistics LOG True/False - Revenue statistics - ?=True
10 sales_price DEC N9,3 - Sales price - -
11 standard_cost_price DEC N9,3 - Standard cost price - -
12 vat_code_purchase CHAR A3 vattrs VAT code purchase - -
13 empty - - - - - -
14 item_text CHAR A2000 - Text - -
15 descr_ml CHAR A40 - Multi language description 1 - -
16 descr_ml CHAR A40 - Multi language description 2 - -
17 descr_ml CHAR A40 - Multi language description 3 - -
18 descr_ml CHAR A40 - Multi language description 4 - -
19 descr_ml CHAR A40 - Multi language description 5 - -
20 discontinued_item LOG True/False - Discontinued item - ?=False
21 text_item LOG True/False - Text item - ?=False
22 get_receipt LOG True/False - Receipt - ?=False
23 location_code CHAR A8 fas_loc Location - -

Clarification of the fields:

LOG fields: True = Yes, False = No

Field Clarification
4 23901 = purchase item (Will be used as default if "?" or "0" is entered, when neither sales order nor invoice is in license)

23902 = sales item (Will be used as default if "?" or "0" is entered, when sales order or invoice is in license)

23903 = both
8 The VAT codes should be of the type 'Sales' or 'Both'.
12 The VAT codes should be of the type 'Purchase' or 'Both'.
14 This field will only be used if field 21 (text_item) is set to 'True'.

Connectivity > Data import > Available import formats > Sales > Items

     
 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.085
 Assortment: Exact Financials  Date: 03-10-2015
 Release:  Attachment:
 Disclaimer