|
|
| (6 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 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. | + | =This Content Has Moved House= |
| | + | This article has been moved to our new home for documentation and help content, the new Emersion Knowledge Base. |
| | | | |
| − | = Preparing your Data =
| + | We are sorry for the untidiness while we are shifting locations and we appreciate your patience during the transition to out new home. |
| − | 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
| + | [https://resources.emersion.com/display/EKB/Opening+Balances Take me to the Emersion Knowledge Base article] |
| − | | |
| − | 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
| |
| − | INVOICE_START
| |
| − | INVOICE_END
| |
Latest revision as of 13:09, 18 September 2017
This Content Has Moved House
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.
Take me to the Emersion Knowledge Base article
