Follow

DocumentImport file for debtors payments

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

 

You can use the file used to import the commercial documents also to import the debtor payments linked to the documents.

The payments can be imported for:

  1. a) documents already existing in the WinBIZ database
  2. b) documents that are in the same file in which the payments are

 

The structure of the information is the same as for the other documents, even if only a few fields are considered in the import

 

Field Nb.

Source

Description

Field type

Example

Comment

1

Header

Number of the document paid by this payment

N(10)

1000

Compulsory

 

If no document with this number exist, the row will be completely ignored.

2

Header

Document type

N(2) 

24

Compulsory

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

14:59

Optional

5

Header

Reference

C(60)

Closing payment

Optional

6

Header

Total amount in local currency

N(15, 2)

18350.50

Compulsory

7

Header

Currency ISO code

C(3)

USD

Optional

 

The currency of the payment must be the same of the document. Otherwise the currency of the document will be used.

8

Header

Exchange rate

N(12, 6)

1.28546

Optional

9

Header

Amount in foreign currency

N(15, 2)

14275.43

Optional

10

 

 

 

 

See main documentation

11

Header

Collective third party account

C(12)

1100

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 to 19

 

 

 

 

See main documentation

20

Address

Address code

C(15)

LGE10001

Compulsory

21 to 146

 

 

 

 

See main documentation

147

Document

Payment method code

C(40)

CCP120

Optional

148 to 159

 

 

 

 

See main documentation

 

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.

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

Comments