Follow

DocumentImport file for documents

The format of the file must be:

 

 

 

File type

CSV, text delimited by semi-columns

Delimiter

Semi-column

Record delimiter

CRLF (CHR(10) + CHR(13))

Code page

1252 ANSI (Event. 850 or 437 ASCII)

File name

*.wdx or bizexdoc*.csv

 

 

Field Nb.

Source

Description

Field type

Example

Comment

1

Header

Document Nb.

N(12)

1000

Compulsory

 

A tag <NEW> can be added after (or instead of) the document Nb.

 

a) If the field contains only a number and a document doesn't exists in WinBIZ for that type and that number, a new document will be created. Its number will be the one specified in this field.

 

b) If the field contains only a number and a document exists in WinBIZ for that type and that number, the lines will be ignored and an error will be logged.

 

c) If the field contains only the Tag <NEW>, a new document will be created a number assigned by WinBIZ automatically. The document will contain all the lines of the file.

 

d) If the field contains a number and the Tag <NEW> a new document will be created with a number assigned by WinBIZ.

2

Header

Document type

N(2) 

20

Compulsory. the accepted values are:

 

Sales

10 Offer

12 Order confirmation

14 Worksheet

16 Delivery slip

17 Debtor starting balance

18 Cash sale

20 Debtor Invoice

22 Debtor credit note

24 Debtor Payments (see here)

 

Purchases

40 Supplier order

41 Call for tender

42 Reception of goods

43 Creditor starting balance

44 Creditor invoice

46 Creditor payment (see here)

47 Creditor credit note

50 Return of goods

 

Stock

60 Stock movement

 

3

Header

Date

YYYYMMDD or DD.MM.YYYY

20170301 01.03.2017 01/03/2017

Compulsory, with or without delimiters

4

Header

Time

HH:MM C(5)

14:59

Optional

5

Header

Reference

C(250)

REF-1234568

Optional

6

Header

Total amount in local currency

N(15, 2)

18350.50

Compulsory

7

Header

ISO code of currency

C(3)

USD

Optional

 

Defaulted to the local currency if empty

8

Header

Exchange rate

N(12, 6)

1.28546

Optional

9

Header

Total amount in foreign currency

N(15, 2)

14275.43

Optional

10

Header

Quantity of foreign currency exchanged

N(6)

1

Optional

11

Header

Collective third party account

C(12)

1100, 2000

Compulsory

 

You can use a tag <AUTO> instead of filling in the field with an account number.

If you use the tag <AUTO> WinBIZ will: a) firstly use the collective account of the Creditor tab of the Address ;

b) secondly the account chosen in Tools->Options->Accounting-> Posting -> Debtor or Creditor Tab

c) if no account is specified there, WinBIZ will prompt the user to choose an account that will be used by default from that moment on

12

Header

Discount account

C(12)

3090

Optional

 

You can use a tag <AUTO> instead of filling in the field with an account number.

If you use the tag <AUTO> WinBIZ will:

a) firstly use the account chosen in Tools->Options->Accounting-> Posting -> Debtor or Creditor Tab

b) if no account is specified there, WinBIZ will prompt the user to choose an account that will be used by default from that moment on

13

Header

Language

C(1)

F

Optional

 

The admitted values are:

F - French

E - English

A, D, G - German

I - Italian

14

Header

Document format

N(1)

1

Optional

 

The admitted values are:

1 - Detailed

2- Summarized

If left empty it is defaulted to 1 Detailed

15

Header

Creditor document ref. Nb.

C(10)

ABC123

Optional

16

Header

URL

C(250)

http://www.mydoc.com?doc12345

Optional

17

Header

External identifier

C(50)

ABC10001

Optional.

 

This field can contain the identifier that the document has in the external system that sends the file to WinBIZ

 

<UPDATE>

The tag <UPDATE> allows to update the content of the existing document with the content of the new wdx file. The external identifier of the document must accompany the tag.

example  to modify the existing document that has the External identifier ABC10001: <UPDATE>ABC10001

 

<LINEADD>

The tag <LINEADD> allows to add to the content of the existing document the content of the record containing the tag in the new wdx file. The external identifier of the document must accompany the tag.

example  to add a line to the existing document that has the External identifier ABC10001: <LINEADD>ABC10001

18

Header

Batch Nb.

N(10)

100

Optional

19

Header

Remarks

C(250)

Merry Christmas

Optional

20

Address

Address code

C(15)

LGE10001

Compulsory

 

During the import WinBIZ matches the address with:

a) the existing address having the same value in the Address Code field;

b) if not found, the existing address having this same value in the field Complementary address code;

c) if not found, the  existing address having this same value in the field Global location number;

d) if not found, please refer to field number 47.

21

Address

Section

C(30)

Restaurant

Optional

22

Address

Company

C(50)

Microsoft Corp.

Optional

23

Address

Last Name

C(30)

Gates

Optional

24

Address

First Name

C(30)

Williams G.

Optional

25

Address

Street 1

C(40)

Microsoft Way 1

Optional

26

Address

Street 2

C(40)

PO Box 1

Optional

27

Address

Zip code

C(10)

111222333

Optional

28

Address

City

C(40)

Redmond

Optional

29

Address

ISO country code

C(13)

USA

Optional

30

Address

Country

C(40)

United States of America

Optional

31

Address

Language

C(1)

E

Optional

 

The admitted values are:

F, 1 - French

E, 4 - English

A, D, G, 2 - German

I, 3 - Italian

5 - Other

32

Address

Telephone 1

C(20)

01 (555) 10000

Optional

33

Address

Telephone 2

C(20)

01 (555) 10001

Optional

34

Address

Mobile telephone

C(20)

01 (842) 10001

Optional

35

Address

Fax

C(20)

01 (555) 10002

Optional

36

Address

E-mail

C(60)

info@microsoft.com

Optional

37

Address

URL

C(50)

www.microsoft.com

Optional

38

Address

Credit limit

N(15, 2)

2000.00

Optional

39

Address

Price table 1-20

N(2)

1

Optional

40

Address

Creation date

YYYYMMDD or DD.MM.YYYY

20170301 01.03.2017 01/03/2017

Optional

41

Address

Birth date

YYYYMMDD or DD.MM.YYYY

20170301 01.03.2017 01/03/2017

Optional

42

Address

Salutation

C(30)

Dear

Optional

43

Address

Delivery address

C(250)

Dupont & Dupond SA

Av. de la Gare 123

1000 Lausanne

Optional

44

Address

Address group

C(50)

Debtors

Optional

45

Address

Title

C(30)

Mister

Optional

46

Address

Region

C(100)

Zürich

Optional

47

Address

Address update method

N(1)

0

Optional.

 

The accepted values are:

2 = adds the address if it doesn't exists. If the address exists in WinBIZ it will be updated and completed.

0 = adds the address if it doesn't exist. If the address exists, its data is replaced with the data from the file.

1 = adds the address if it doesn't exist, but doesn't update it if it exists

 

If the field is left empty, it defaults to 0

48

Lines

Line Nb.

N(4)

1

Optional.

 

The range of accepted vales goes from 1 to 9999

49

Lines

Line type

N(1)

1

Optional

 

The accepted values are:

0-1 = Item
2 = Text
3 = Subtotal, total (see field 105)
4 = Title
7 = Reduction (see field 105)

 

If the field is left empty, it is defaulted to 0 (Item).

50

Lines

Item code

C(30)

WINWORDXP2003

Optional

 

The field is compulsory if you want to add or update a WinBIZ item (see field 74)

51

Lines

Description

C(250)

Microsoft Word XP 2003

Compulsory

52

Lines

Line date

YYYYMMDD or DD.MM.YYYYY

20170301 01.03.2017 01/03/2017

Optional

53

Lines

Quantity

N(15, 4)

1.0000

Compulsory

54

Lines

Unit price in local currency

N(16, 4)

300.00

Compulsory

55

Lines

Unit

C(15)

PCE

Optional

56

Lines

Rebate %

N(7, 6)

10

Optional.

 

The accepted range of values goes from 1 to 100

57

Lines

Total line amount

N(12, 2)

270.00

Compulsory

58

Lines

Unit price in foreign currency

N(16, 4)

233.80

Optional

59

Lines

Total amount in foreign currency

N(15, 2)

210.04

Optional

60

Lines

Turnover account

C(12)

3000

Compulsory

 

You can use a tag <AUTO> instead of filling in the field with an account number.

If you use the tag <AUTO> WinBIZ will:

a) firstly use the information filled in the posting method used by the Item

b) secondly (for creditor documents only) use the information filled in the posting method used by the Address

c) secondly use the account chosen in Tools->Options->Accounting-> Posting -> Debtor or Creditor Tab

d) if no account is specified there, WinBIZ will prompt the user to choose an account that will be used by default from that moment on

61

Lines

VAT %

N(15, 2)

8

Compulsory

62

Lines

VAT Included/Excluded

N(1)

1

Optional

 

The accepted values are:

0, 1 = Included

2 = Excluded

If left empty, it will defaulted to 0 = Included

63

Lines

VAT account

C(12)

2200

Optional

64

Lines

TVA method

N(1)

1

Optional

 

The accepted values are:

0, 1 = Gross

2 = Net

If left empty, it will be defaulted to 0 = Gross

65

Lines

Amount excluded from TVA if the TVA taxation is calculated on the difference

N(15, 2)

0.00

Optional

66

Lines

Delivery slip or Voucher Nb.

C(10)

BON4845

Optional

67

Lines

Rebate amount

N(13, 2)

 

Optional

68

Lines

VAT Type, Vat Code, or VAT Figure

Variant

<VAT_CODE=ABC123>

Optional

 

If this value is omitted, the VAT figure specified in the chart of accounts will be used for the turnover account.

 

1st Method: recommended

Use a tag including the Unique TVA type code entered in WinBIZ.

 

Ex: <VAT_CODE=ABC123>: all the VAT information will correspond to the TVA type having its code equal to ABC123.

 

The document import will look for the VAT information corresponding to the Code specified in the Tag. This code can be easily entered in the form used to edit the VAT types. If this method is used there's no need to transmit the information in fields  61, 63 to 65 and 72.

 

Using this method you can force a VAT Figure different from the one used in the VAT Type. This can be done adding a second Tag.

 

Ex: <VAT_CODE=ABC123><VAT_FIGURE=220>

We suggest not to use this kind of transmission, and rather create a corresponding VAT Type corresponding to this data.

 

2nd Method: supported but deprecated

1 = No VAT

2 = VAT Due

3 = Input VAT

4 = Excluding VAT

 

We support this old method. It is deprecated because it obliges to specify separately all the VAT parameters in the fields from 61 to 65 and in field 72.

 

Using this method you can still force a VAT Figure different from the one used in the VAT Type. This can be done adding the VAT Figure TAG.

 

Ex: 4<VAT_FIGURE=220>

We strongly deprecate this method.

69

Lines

Analytical account

C(20)

 

Optional

70

Lines

Remarks

C(250)

This product is no more in stock

Optional

71

Lines

Vendor code

C(20)

AV21458D

Optional

72

Lines

VAT rounding precision

N(1)

2

Optional

 

The accepted values are

0, 1 = 1 ct

2 = 5 cts

4 = 0.1 ct

If left empty it is defaulted to 0 = 1 ct

73

Lines

Deal Nb.

C(10)

59682E

Optional

74

Item

Item update method

N(1)

1

Optional: to be used only if a code is used in field 50.

 

The accepted values are:

0 = never adds and never updates the WinBIZ item

>=1 = if a item corresponding to the code in field 50 is found in WinBIZ, the item is updated. Otherwise the item is added.

 

75

Item

Short description

C(50)

MS Word XP

Optional

76

Item

Long French description

C(250)

Microsoft Word XP 2003

Optional

77

Item

Long German description

C(250)

 

Optional

78

Item

Long Italian description

C(250)

 

Optional

79

Item

Long English description

C(250)

 

Optional

80

Item

Long description in Other language

C(250)

 

Optional

81

Item

Bar code

C(23)

 

Optional

82

Item

Group

C(15)

SOFT WINDOWS

Optional

83

Item

Standard sale price

N(15, 2)

 

Optional

84

Item

Standard purchase price

N(15, 2)

 

Optional

85

Item

Standard unit

C(20)

Piece, Hour

Optional

86

Item

Weight

N(10, 3)

 

Optional

87

Item

Stocking location

C(15)

REDMOND

Optional

88

Item

Miscellaneous 1

C(25)

 

Optional

89

Item

Miscellaneous 2

N(12, 4)

 

Optional

90

Item

Miscellaneous 3

C(250)

 

Optional

91

Item

Miscellaneous 4

C(250)

 

Optional

92

Item

Miscellaneous 5

C(25)

 

Optional

93

Item

Miscellaneous 6

C(25)

 

Optional

94

Item

Miscellaneous 7

C(25)

 

Optional

95

Item

Miscellaneous 8

C(25)

 

Optional

96

Item

Miscellaneous 9

C(25)

 

Optional

97

Item

Miscellaneous 10

C(20)

 

Optional

98

Item

Default supplier code

C(20)

LGE10001

Optional

99

Item

Reserved

C(20)

 

To be left empty

100

Item

Reserved

C(10)

 

To be left empty

101

Item

Reserved

C(10)

 

To be left empty

102

Item

Reserved

C(10)

 

To be left empty

103

Item

Reserved

C(10)

 

To be left empty

104

Item

Reserved

C(10)

 

To be left empty

105

Lines

Rebate calculation method, subtotal/total line type

N(1)

1

Optional

 

For the Reduction line types (see field 49) the accepted values are:

1 = Calculated on the total document amount

2 = Calculated since the last Reduction line

3 = Calculated since last subtotal

4 = Calculated since last title

5 = Calculated on the total document amount, reductions excluded

6 = Calculated on last total

If left empty for a Reduction line type, it will be defaulted to 1

 

For the subtotal/total line types (see field 49) the accepted values are:

0 = Subtotal

1 = Total

If left empty for a subtotal/total line type, it will be defaulted to 0

106

Lines

Services from

YYYYMMDD or DD.MM.YYYY

01.06.2017

Optional

107

Lines

Services to

YYYYMMDD or DD.MM.YYYY

30.06.2017

Optional

108

Object

Object text 1

C(40)

 

Optional

109

Object

Object text 2

C(40)

 

Optional

110

Object

Object text 3

C(40)

 

Optional

111

Object

Object text 4

C(40)

 

Optional

112

Object

Object text 5

C(40)

 

Optional

113

Object

Object text 6

C(40)

 

Optional

114

Object

Object text 7

C(40)

 

Optional

115

Object

Object text 8

C(40)

 

Optional

116

Object

Object text 9

C(40)

 

Optional

117

Object

Object text 10

C(40)

 

Optional

118

Object

Object text 11

C(40)

 

Optional

119

Object

Object text 12

C(40)

 

Optional

120

Object

Object text 13

C(40)

 

Optional

121

Object

Object text 14

C(40)

 

Optional

122

Object

Object text 15

C(40)

 

Optional

123

Object

Object text 16

C(40)

 

Optional

124

Object

Object text 17

C(40)

 

Optional

125

Object

Object text 18

C(40)

 

Optional

126

Object

Object text 19

C(40)

 

Optional

127

Object

Object text 20

C(40)

 

Optional

128

Object

Reserved

C(40)

 

To be left empty

129

Object

Reserved

C(40)

 

To be left empty

130

Object

Reserved

C(40)

 

To be left empty

131

Object

Reserved

C(40)

 

To be left empty

132

Object

Reserved

C(40)

 

To be left empty

133

Address

Name of the address template

C(30)

Normal

Optional

134

Document

Vendor Code

C(20)

ER2563

Optional

135

Document

Your Reference

C(250)

 

Optional

136

Document

Category code

C(20)

EXPO_BERN

Optional

137

Document

Code of the presentation for the invoice

C(40)

PR5618

Optional

138

Document

Voluntary settlement

N(1)

0

 

Optional

 

The accepted values are:

0 = Normal settlement

1 = Voluntary settlement

If left empty it will be defaulted to 0

139

Document

Print counter

N(4)

1

Optional

140

Document

Code of the payment term

C(40)

CP7823

Optional

141

Document

Delay to due date in days

N(4)

30

Optional

142

Document

Shipment date delay in days

N(4)

30

Optional

143

Document

Attached file

C(40)

c:\Documents\abc.pdf

c:\Documents\

Optional

 

If the path entered is a file path, WinBIZ will retrieve the file.

If the path entered is a folder path, WinBIZ will retrieve all the files contained in the folder.

144

Document

Document rebate amount

N(10, 2)

14.15

Optional

 

This amount is rebated on the total of the document

145

Document

Discount amount

N(10, 2)

5.45

Optional

146

Document

Discount amount in foreign currency

N(10, 2)

 

Optional

147

Document

Payment method code

C(40)

CCP120

Optional

 

Used only for the import of the debtor and Creditor payments.

148

Document

Warehouse name

C(100)

Lausanne WH

Optional

149

Address

Send reminders

N(2)

0

Optional

 

The accepted values are:

0 = Send reminders

1 = Do not send reminders

If left empty it is defaulted to 0

150

Document

Code of the 2nd address of the document

C(40)

A100

Optional

151

Document

Code of the 3rd address of the document

C(20)

A1001

Optional

152

Payment

Reserved

C(20)

 

To be left empty

153

Payment

Reserved

C(40)

 

To be left empty

154

Payment

Reserved

C(40)

 

To be left empty

155

Payment

Creditor bank instructions

C(254)

 

Optional

 

Any combination of the following tags is accepted in any order:

 

<iban=...>
<bankaccount=...>
<clearing=...>
<swift=...>
<postalaccount=...>

 <reference=...>
<communication1=...>
<communication2=...>
<communication3=...>
<communication4=...>

 

For Postal accounts, the following tags are compulsory

<postalaccount=...>

<reference=...>

 

For Banks the following fields are compulsory:

<bankaccount=...>

<reference=...>


BTW:

- Max length = 254

- IBAN is going to be compulsory starting from 2018: it's strongly advised to always use the IBAN also when it's not yet compulsory.

156

Payment

Reserved

C(40)

 

To be left empty

157

Payment

Reserved

C(40)

 

To be left empty

158

Payment

Reserved

C(40)

 

To be left empty

159

Payment

Reserved

C(40)

 

To be left empty

 

 

Remarks

The file to be imported must contain all the columns mentioned above. The order of the columns is compulsory.

The name of the fields does NOT determine the content.

The optional fields must be in the file, but can be left empty.

Some programs can generate NULL values in their exports. This value is not always supported during the import. The only way to know if it is possible to exploit the files created by your program is to test them yourself.

It is possible to transform a document in another type. In order to do so, please refer to this topic

 

File sample

Here you find a simple example that you can copy and paste in a text file to produce a file containing an invoice with 3 lines.

 

25000;20;01042017;10:50;Installation réseau;1072.5;EUR;1.56;687.5;1;1100;3090;F;;;;;;;LGE10001;Restaurant;Microsoft Corp;Gates;William;Microsoft Way;PO Box 1;11122333;Redmond;USA;United States;F;01(555)10000;01(555)10001;01(555)100002;01(842)10001;info@microsoft.com;www.microsoft.com;2000;1;01042017;01041956;;;;;;;1;1;WINWORDXP2003;Microsoft Word XP 2003;01042017;1;300;Pce;10;270;192.3;173.08;3000;7.6;1;2200;0;0;BON4845;;;;;;;;1;MS Word XP;Microsoft Word XP 2003;;;;;;SOFTWARE WINDOWS;300;122.2;Pce;0.35;;;;;;;;;;;;1000F;;;;;;;;;;Objet test 1;;;;;;;;;;;;;;;;;;;;;;;;;

25000;20;01042017;10:50;Installation réseau;1072.5;EUR;1.56;687.5;1;1100;3090;F;;;;;;;LGE10001;Restaurant;Microsoft Corp;Gates;William;Microsoft Way;PO Box 1;11122333;Redmond;USA;United States;F;01(555)10000;01(555)10001;01(555)100002;01(842)10001;info@microsoft.com;www.microsoft.com;2000;1;01042017;01041956;;;;;;;2;1;WINEXCELXP2003;Microsoft Excel XP 2003;01042017;1;240;Pce;10;216;153.84;138.46;3000;7.6;1;2200;0;0;BON4849;;;;;;;;1;MS Excel XP;Microsoft Excel XP 2003;;;;;;SOFTWARE WINDOWS;240;99.99;Pce;0.37;;;;;;;;;;;;1000F;;;;;;;;;;Objet test 1;;;;;;;;;;;;;;;;;;;;;;;;;

25000;20;01042017;10:50;Installation réseau;1072.5;EUR;1.56;687.5;1;1100;3090;F;;;;;;;LGE10001;Restaurant;Microsoft Corp;Gates;William;Microsoft Way;PO Box 1;11122333;Redmond;USA;United States;F;01(555)10000;01(555)10001;01(555)100002;01(842)10001;info@microsoft.com;www.microsoft.com;2000;1;01042017;01041956;;;;;;;3;1;WINACCESSXP2003;Microsoft Access XP 2003;01042017;1;690;Pce;15;586.5;442.3;375.96;3000;7.6;1;2200;0;0;BON4850;;;;;;;;1;MS Access XP;Microsoft Access XP 2003;;;;;;SOFTWARE WINDOWS;690;222.3;Pce;0.48;;;;;;;;;;;;1000F;;;;;;;;;;Objet test 1;;;;;;;;;;;;;;;;;;;;;;;;;

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments