frequently asked questions

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. 

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

Compulsory

Remark: for the Stock movements (value 60 in field 2) there can be lines with a negative value in the fields 53 and 57. In that case, the Total amount in local currency must reflect these amounts.

Optional

Defaulted to the local currency if empty

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

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

Optional

The admitted values are:

F - French

E - English

A, D, G - German

Optional

The admitted values are:

1 - Detailed

2- Summarized

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

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.

Remark: do not use the codes of the Addresses' models.

Optional

The admitted values are:

F, 1 - French

E, 4 - English

A, D, G, 2 - German

I, 3 - Italian

5 - Other

Dupont & Dupond SA

Av. de la Gare 123

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

The range of accepted vales goes from 1 to 9999

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).

Optional

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

Compulsory

The quantity can be negative if the value in field nr. 2 is 60. In this case the Stock movement will be a Stock Entry. In this case fields 57 and 6 must be adjusted accordingly.

The accepted range of values goes from 1 to 100

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

Optional

The accepted values are:

0, 1 = Included

2 = Excluded

If left empty, it will defaulted to 0 = Included

Optional

The accepted values are:

0, 1 = Gross

2 = Net

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

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.

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

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.

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

Optional

The codes for the possible Invoices Layout can be returned with the method Messages

Optional

The codes for the possible Invoices Layout can be returned with the method InvoiceLayouts

Optional

The accepted values are:

0 = Normal settlement

1 = Voluntary settlement

Optional 

The codes for the possible Payment terms can be returned with the method PaymentTerms

Optional

It's currently not possible to import a pdf file via the API.

Optional

Optional

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

The codes for the possible Payment methods can be returned with the method PaymentMethods

Optional

The accepted values are:

0 = Send reminders

1 = Do not send reminders

If left empty it is defaulted to 0

Optional

Please refer to this page:

Creditor Bank Instructions in the DocumentImport file for documents

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.