Data Commonly Imported at Startup

The most common data elements that are imported into a new StreamV system at startup include.

•      Customers:  The unique companies that you sell to.  Each customer record in StreamV must have a unique account and a unique company name.

•      Contacts:  The individuals that you do business with at each customer.  The combination of the first and last name and the contact company should be unique.

•      Vendors:  The vendors that you purchase from or process accounts payable invoices for.  Each Vendor record in StreamV

•      Chart of Accounts:  The Account Description file in StreamV is used to store the general ledger account numbers, subaccount numbers and account descriptions that are used by all segments of the company.  The Account Description file can be loaded automatically from the chart of accounts information from your old system.

•      Catalog or Item records:  The items that you sell.  In StreamV, the Catalog file contains all items available for sale.  The Inventory or Warehouse file contains the items that can actually be used for processing.  The Catalog file provides a centralized point for editing the common information for items that may exist in multiple locations, and it allows you to import vendor catalog information.

•      Open AR Invoices:  The open accounts receivable invoices from your old system are normally moved into StreamV at system startup.  The invoice records can are loaded with a converted balance to handle partially paid invoices, and to allow the system to audit the payment and other activity on the records.

•      Open AP Invoices: The open accounts payable invoices from your old system are normally moved into StreamV at system startup.  The invoice records can are loaded with a converted balance to handle partially paid invoices, and to allow the system to audit the payment and other activity on the records.

•      Pending Inventory: The Pending file is used to handle items that you own that are not physically present in inventory or the shop.    You may need to create Pending records for items like samples out in the field, items that were sent back to the vendor (and not yet credited or replaced), consignment inventory, etc).

•      Unvouchered Inventory:  The Unvouchered Inventory file is used to record the liability to your vendor for items that you have received into inventory, but have not yet processed an ap invoice for.  In StreamV, these Inventory Activity records are created at receiving, and they are matched to the invoice when the invoice is received from the vendor.  

Other data that can be imported at Startup includes

Table Data: Payment Terms, Product Lines, Groups, Shipping Methods, Operators, etc.  In most cases, Table data is created manually (which allows the system to validate the information being entered and to ensure that all required fields have been loaded.

Closed AR Invoice Headers:  The closed AR invoices from your old system can be imported into StreamV to allow you to view invoice history by customer.  The closed AR history may also be used to build customer accumulator data or statistics (like average days to pay, sales ytd, last year, etc).

Closed AP Invoice Headers:  The closed accounts payable invoices for a period of time can be converted to allow you to view invoice history by vendor in the new system.

AR Line Item Information:  Loading the invoice line item details for the open and closed invoices being converted allows you to see prior sale information (i.e. what did I charge the customer for this item in the past), run comparative sales reports (i.e. customer sales by item for a date range).

Journal Entry Detail:  The journal entry detail from a system can be imported into StreamV to allow you to view general ledger activity, and the posting details for accounts payable invoices.  The journal entry file is one of the trickier files to convert, and normally, the beginning gl balances are the only GL amounts that are moved over to the new system.

More:

Data Import Methods