|
|
| (3 intermediate revisions by 2 users not shown) |
| Line 1: |
Line 1: |
| − | = Opening Balances Import =
| + | {{DISPLAYTITLE: Opening Balance 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. | + | =This Content Has Moved House= |
| | + | This article has been moved to our new home for documentation and help content, the new Emersion Knowledge Base. |
| | | | |
| − | The tool also supports storing a history of account balances. This is done through the INVOICE_START, INVOICE_END and ORIGINAL_INVOICE
| + | We are sorry for the untidiness while we are shifting locations and we appreciate your patience during the transition to out new home. |
| | | | |
| − | = Preparing your Data =
| + | [https://resources.emersion.com/display/EKB/Opening+Balances Take me to the Emersion Knowledge Base article] |
| − | 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 ==
| |
| − | {| class="wikitable"
| |
| − | |+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.
| |
| − | |}
| |
This article has been moved to our new home for documentation and help content, the new Emersion Knowledge Base.
We are sorry for the untidiness while we are shifting locations and we appreciate your patience during the transition to out new home.
