To illustrate the exported fields and data, the exported text file is opened in a spreadsheet. 

Once the text file is saved, you may launch your spreadsheet application i.e Excel, OpenOffice, LibreOffice, Ultra Office, etc. 

 If you do not enter and save the Export.txt file name, you may replace existing (previously exported) files. 

If the exported Text (*txt) file is opened (active), and you are trying to open the export file with the same name, a similar error message as the following will be displayed:

Cannot create file "D:\Export\Export.txt". The process cannot access the file because it is being used by another process. 

On your spreadsheet application, open the debtor (customer / client) accounts saved text (*.txt) file and confirm your tab delimited settings ("Separator Options") on the "Text Import" screen. 

export-debtor-text-import-spreadsheet-options

This will open your exported text file of the selected debtor (customer / client) accounts in a spreadsheet. An example of the exported file opened in "LibreOffice Calc" spreadsheet, is as follows: 

export-debtors-text-imported-spreadsheet

The exported data will be exported in 46 columns:

Column

Column heading

Source / fields

Field location (main form / tab)


A

SACCOUNTCODE

Debtor code

Main form

String (6)

B

SDescription

Name (Account description)

Main form

String (35)

C

SContactName

Contactperson

Main form

String (35)

D

SPostCountry

Postal address country

Main form

String (35)

E

SDelCountry

Delivery address country

Delivery address tab

String (64)

F

SPOSTAL1

Address

Main form

String (30)

G

SPOSTAL2

Address 2

Main form

String (30)

H

SPOSTAL3

Address 3

Main form

String (30)

I

SPOSTALCODE

Postal code

Main form

String (8)

J

SDELIVERY1

Delivery address

Delivery address tab

String (30)

K

SDELIVERY2

Address 2

Delivery address tab

String (30)

L

SDELIVERY3

Address 3

Delivery address tab

String (30)

M

SDeliveryCode

Delivery code

Delivery address tab

String (8)

N

STELEPHONE1

Telephone 1

Main form

String (20)

O

STELEPHONE2

Telephone 2

Main form

String (20)

P

SEMAIL

E-Mail

Main form

String (50)

Q

SFAX

Fax

Main form

String (20)

R

FCREDITLIMIT

Credit limit

Accounting information tab

Float(numeric)

S

FCHARGEAMOUNT

Charge amount

Accounting information tab

Float(numeric)

T

FDISCOUNT

Discount

Accounting information tab.

Float(numeric)

U

FInterest

Interest

Accounting information tab 

Float(numeric)

V

BOPENITEM

Open item

Accounting information tab

B=CheckBox

1 = Open item account (True - checked) 

0 = Not an Open item account (False - not checked) 

W

BINACTIVE

Inactive

Accounting information tab

B=CheckBox

1 = Account disabled (inactive) - (True - checked) 

0 = Account enabled (active) - (False - not checked) 

X

SMESSAGE

Message 

Delivery address tab

String (50)

Y

WDEFAULTPRICETYPEID

Default selling price

Accounting information tab 

Integer

Z

DLASTACTIVITY

Last invoice


Date

AA

SREFERENCE

Tax reference

Main form

String (20)

AB

SBANKNAME

Bank name

Accounting information tab

String (20)

AC

SBRANCHCODE

Bank account type

Accounting information tab

String (10)

AD

SBANKACCOUNTNUMBER

Bank account no.

Accounting information tab

String (45)

AE

SBANKACCOUNTNAME

Bank account name

Accounting information tab

String (30)

AF

SCREDITCARDNUMBER

Credit card number


String (35)

AG

SCREDITCARDTYPE

Credit card type



AH

SCREDITCARDHOLDER

Credit card holder


String (20)

AI

WDUEDAYS

Due days

Accounting information tab

Integer

AJ

SCOMPANYREGNO

Company reg. no.

Main form

String (35)

AK

SFREEFIELD1

Statement message 1

Delivery address tab

String (35)

AL

SFREEFIELD2

Statement message 2

Delivery address tab

String (35)

AM

SFREEFIELD3

Statement message 3

Delivery address tab

String (35)

AN

SGroup1

Debtor group 1

Main form

String (30)

AO

SGroup2

Debtor group 2

Main form

String (30)

AP

SSalesperson

Salesperson

Main form


AQ

SCurrency

Currency


String (35)

AR

SForeExAccount




AS

SDEFAULTACCOUNT

Use default account

Accounting information tab


AT

SDEFAULTTAX

Use default tax

Accounting information tab