Data Import/Opening Balances - Revision history

Scarpenter at 03:09, 18 September 2017

2017-09-18T03:09:05Z

Dcowan: minor clarification to data preparation

2017-06-28T04:12:41Z

minor clarification to data preparation

Dcowan: clarified opening balance importer field definitions

2017-06-28T04:11:05Z

clarified opening balance importer field definitions

Scarpenter at 02:28, 28 June 2016

2016-06-28T02:28:17Z

Scarpenter: /* Opening Balances Import */

2016-06-28T02:27:03Z

‎Opening Balances Import

Scarpenter: /* Opening Balance Import Data Definition */

2016-06-28T02:24:38Z

‎Opening Balance Import Data Definition

Scarpenter: /* Preparing your Data */

2016-06-28T02:16:56Z

‎Preparing your Data

Scarpenter at 02:16, 28 June 2016

2016-06-28T02:16:35Z

Scarpenter: Created page with "{{+DISPLAYTITLE:Opening Balances Import}} = Overview = This import is used to set the opening balance of end-user accounts. It is most often used after a migration of customer..."

2016-06-28T02:16:00Z

Created page with "{{+DISPLAYTITLE:Opening Balances Import}} = Overview = This import is used to set the opening balance of end-user accounts. It is most often used after a migration of customer..."

New page

{{+DISPLAYTITLE:Opening Balances Import}}
= Overview =
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 ==
{| 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

@@ 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=
-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.
+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]

@@ Line 9: / Line 9: @@
 [[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.
+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. As this is currently a back-end only import, Emersion staff will inform you of any errors that may require correcting.
 == Opening Balance Import Data Definition ==

@@ Line 16: / Line 16: @@
 |Data field ||Description
 |-
-|ACCOUNT_ID	||The id of the account.
+|ACCOUNT_ID	||The id of the account. Must belong to you.
 |-
-|CARDLINE_AMOUNT_EXTAX     ||This cannot be a past date. Must be in the date format DD/MM/YYYYY.
+|CARDLINE_AMOUNT_EXTAX     ||Must be a numeric figure and cannot be empty. Can be a negative (indicated by a - sign). See notes below.
 |-
-|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.
+|CARDLINE_AMOUNT_TAX	||Must be a numeric figure and cannot be empty. Can be a negative (indicated by a - sign). See notes below.
 |-
-|BALANCE_DUE_EXTAX || The amount the customer owes without tax
+|BALANCE_DUE_EXTAX || The ex tax component of the total balance of this particular invoice. Cannot be less than zero or empty. See notes below.
 |-
-|BALANCE_DUE_TAX ||  The tax amount the customer owes.
+|BALANCE_DUE_TAX ||  The tax component of the total balance of this particular invoice. Cannot be less than zero or empty. See notes below.
 |-
-|CARDLINE_DESCRIPTION || Write a description for the cardline that will appear on the invoice.
+|CARDLINE_DESCRIPTION || Write a description for the cardline that will appear on the invoice. 255 characters max.
 |-
-|INVOICE_ISSUE_DATE || The date the invoice was/will be issued.
+|INVOICE_ISSUE_DATE || The date the invoice was/will be issued. Date Format: DD/MM/YYYY.
 |-
-|INVOICE_DUE_DATE || The date the invoice was/will be due.
+|INVOICE_DUE_DATE || The invoice due date. This date cannot be in the past and can not be before the issue date. Date Format: DD/MM/YYYY.
 |-
-|ORIGINAL_INVOICE_ID || The original invoice ID if applicable.
+|ORIGINAL_INVOICE_ID || The original invoice ID, if applicable. 50 characters max.
 |-
-|INVOICE_START || The original invoice start date.
+|INVOICE_START || The original invoice start date. Date Format: DD/MM/YYYY.
 |-
-|INVOICE_END || The original invoice start date.
+|INVOICE_END || The original invoice start date. Date Format: DD/MM/YYYY.
 |}

@@ 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.
-The tool also supports storing a history of account balances. This is done through the INVOICE_START, INVOICE_END and ORIGINAL_INVOICE
+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 =

@@ Line 1: / Line 1: @@
 = 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.
+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.
 = Preparing your Data =

← Older revision		Revision as of 02:16, 28 June 2016
Line 1:		Line 1:
−	~~{{+DISPLAYTITLE:~~Opening Balances Import}}	+	= Opening Balances Import =
−	~~= Overview~~ =
	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 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.