Import debtor 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 or bizexdoc*.csv |
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:
- a) documents already existing in the WinBIZ database
- 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.