Difference between revisions of "Data Import/Opening Balances"
(→Opening Balances Import) |
|||
| Line 2: | Line 2: | ||
This import is used to set the opening balance of end-user accounts. It is most often used after a migration of customers has occurred from a source system to Emersion. Once the customers are present, this tool will update the current balance of an account ready for the next bill run to generate new invoices. | This import is used to set the opening balance of end-user accounts. It is most often used after a migration of customers has occurred from a source system to Emersion. Once the customers are present, this tool will update the current balance of an account ready for the next bill run to generate new invoices. | ||
| − | The tool also supports storing a history of account balances. This is done through the INVOICE_START | + | The tool also supports storing a history of account balances, for example, the last 6 months worth of invoice data. This is done through the ORIGINAL_INVOICE_ID, INVOICE_START and INVOICE_END fields in the import. |
= Preparing your Data = | = Preparing your Data = | ||
Revision as of 12:28, 28 June 2016
Opening Balances Import
This import is used to set the opening balance of end-user accounts. It is most often used after a migration of customers has occurred from a source system to Emersion. Once the customers are present, this tool will update the current balance of an account ready for the next bill run to generate new invoices.
The tool also supports storing a history of account balances, for example, the last 6 months worth of invoice data. This is done through the ORIGINAL_INVOICE_ID, INVOICE_START and INVOICE_END fields in the import.
Preparing your Data
To update the opening balances of the accounts, you will need to create a CSV data file or you can download the data file below.
media: opening-balance-import-template.csv
Enter the data into the import sheet. Leave no rows blank. You must ensure the data meets all validation requirements. These are contained in the data definition table below. When you submit the data file for import, the system will parse the file looking for errors. If the system finds no errors, the system will import the notes into the system. The file needs to be error-free in order to import the data. In the event errors are found, no data will be imported into Emersion. Review the bulk upload processing notification email, correct the file and try again.
Opening Balance Import Data Definition
| Data field | Description |
| ACCOUNT_ID | The id of the account. |
| CARDLINE_AMOUNT_EXTAX | This cannot be a past date. Must be in the date format DD/MM/YYYYY. |
| CARDLINE_AMOUNT_TAX | The invoice due date. This date cannot be in the past and can not be before the issue date. This must be in the date format DD/MM/YYYYY. |
| BALANCE_DUE_EXTAX | The amount the customer owes without tax |
| BALANCE_DUE_TAX | The tax amount the customer owes. |
| CARDLINE_DESCRIPTION | Write a description for the cardline that will appear on the invoice. |
| INVOICE_ISSUE_DATE | The date the invoice was/will be issued. |
| INVOICE_DUE_DATE | The date the invoice was/will be due. |
| ORIGINAL_INVOICE_ID | The original invoice ID if applicable. |
| INVOICE_START | The original invoice start date. |
| INVOICE_END | The original invoice start date. |
