Importing Accounts and Addresses

Importing Accounts and Addresses

Before you start importing anything make sure that you use the clearing procedure to clear down any old data first.

You can either import both accounts and addresses in a single file or you can import addresses after accounts - but not the other way around. Whichever way you go, importing accounts and addresses is a two step process.

The import file must be in tab delimited text format and its name must be a maximum of eight characters with no spaces and a three character extension.

ACCOUNT columns

• ACCOUNT NO - required, alphanumeric plus "/" or "-" characters only.
• ACCOUNT NAME - required
• LEDGER CODE - required, must exist in Chart of Accounts File
• ACCOUNT TERMS - optional positive integer days to to pay 0 for Cash, 30, 60, 90 etc
• ACCOUNT CURRENCY CODE - optional, must exist in Currency File

ADDRESS columns

• ACCOUNT NO - required, must preexist in a chart of accounts
• ACCOUNT NAME - required
• ADDRESS BODY - required, should be up to four lines in quotes and separated by cr/lf characters.
• COUNTRY - required, no restrictions
• TELEPHONE - optional, free format so you can put multiple numbers and comments
• FAX - optional (ditto)
• EMAIL - optional (ditto)

In the following example the account and address data columns exist in a single file called ACCOUNTS.TXT.

Importing Accounts

First verify that accounts can be imported and correct any errors before proceeding.

IMPORTX D:\ACCOUNTS.TXT ACCOUNTS

Import the accounts

IMPORTX D:\ACCOUNTS.TXT ACCOUNTS (C)

Use NEOSYS, Finance, Ledgers, Chart of Accounts to check that the above has created accounts in the expected chart of accounts.

Importing Addresses

First verify the addresses can be imported and correct any errors before proceeding. Can only be done after importing the accounts.

IMPORTX D:\ACCOUNTS.TXT ADDRESSES

Import the addresses

IMPORTX D:\ACCOUNTS.TXT ADDRESSES (C)