Difference between revisions of "Data Import/Opening Balances"
(→Preparing your Data) |
(→Opening Balance Import Data Definition) |
||
| Line 29: | Line 29: | ||
|- | |- | ||
|INVOICE_DUE_DATE || The date the invoice was/will be due. | |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. | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 12:24, 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 occured from a source system to Emersion. Onve the customers are present, this tool will update the current balance of an account ready for the new bill run.
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. |
