Importing Accounts Receivable Data

Accounts Receivable data is stored in the following primary files

Customer – The Customer Table contains all of the customers in the system.  A customer record with a unique name and account number should exist in this file for each company pointed to by an AR invoice..  Customerr records can be entered into the system manually or they can be imported from csv or other files automatically using standard utilities.  The CRM system is used by the Accounts Receivable, Order Processing and other systems, and customer data is usually loaded early in the StreamV system startup process. 

Contacts

Invoices – The Invoices or Invoice Header file contains one record for each customer  invoice entered into the system (open or closed).  Invoice Header records contain information that applies to the whole invoice (customer name, invoice number and date, terms, invoice amounts, etc.).  Each Invoice record has a unique Invoice Number.  The Invoice Number in the system is shared by all invoice types (invoices, credits, overpayments)  Open Invoice records have a balance and a blank paydate.

Beginning Balance Invoice records can be entered into the system using a specialized program called AR Beginning Balances Entry, or they can be imported from csv or other files.  Beginning Balance AR Invoices have specific requirements, and specific fields must be loaded so that the system can properly audit the activity against the invoice after conversion.

Journal Entry – The Journal Entry file stores the sales posting and invoice payment and adjustment detail for each invoice in the Invoices file.  Imported invoices – from a prior system, will not normally have any journal entry lines associated with them (the logic is that they were posted to the prior system and are included in the AR Balance you are bringing over to the GL from the old system).

More:

Accounts Receivable System Startup Tasks