Importing Accounts and Addresses: Difference between revisions

From NEOSYS User Support Wiki
Jump to navigationJump to search
Line 40: Line 40:
Import the accounts
Import the accounts


  IMPORTX D:\ACCOUNTS.TXT ACCOUNTS (C)
  IMPORTX D:\ACCOUNTS.TXT ACCOUNTS (U)
 
Option O can be used to overwrite (destroy!) existing records. Use with extreme caution.


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

Revision as of 22:05, 12 December 2012

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 have accounts and addresses columns in a single file or separate files. Whichever way you go, importing accounts and addresses is a two step process and addresses can only be imported after accounts.

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.

The import is done in the NEOSYS maintenance mode using F5 and all NEOSYS listening processes must be shutdown.

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
  • CURRENCY CODE - optional, must exist in Currency File
  • TAX CODE - optional, must exist in Taxes 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, appears on statements and forecast of payments.
  • EMAIL - optional (ditto)
  • FAX - optional (ditto)
  • COMPANY REG NO - optional
  • COMPANY TAX NO - optional

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 (U)

Option O can be used to overwrite (destroy!) existing records. Use with extreme caution.

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)