Overview
This importer applied only to service providers who maintain a calendar month bill cycle. This means the invoice covers from 01st month - last day of the month.
If billing on calendar month, the default behaviour of the system is to generate invoices on the 3rd of every month. This is to cater for usage dated within the month but arriving on the 1st can be rated and invoiced.
This bulk import can be used to force the system to close the invoice period generate the invoice on the 1st month.
Forcing the generation of an invoice immediately will result in usage received on the 1st or 2nd but dated for the month prior cannot be invoiced in the bill run and must be wait to be billed on the next bill run.
If your account has Multiple Pending Invoices enabled, then your system behaviour may be different in regards to pending invoices and cardlines. Please see this article for more information.
Licencing
This feature is available to subscribers of the following:
- Emersion Core
- Optional Modules
- Upon Request (please contact your Account Manager)
Business Rules
- The account belongs to the caller of the bulk import
- The account does not have a pending invoice (unless multiple pending invoices is enabled)
- There are pending cardlines available to be invoiced
- The invoice period end date is less than or equal to three days in the future
- The invoice period is a system generated
- The invoice period is not already processed
- If the account is a 'collective' or 'summary' based agent, its child account should not have a pending invoice when the period is not already processed
When processing account invoice periods against an agent account, the accounts in the collective will have an invoice generated, but account invoice period for the agent account itself will not be touched and no invoice will be created for the agent account via the importer.
Preparing The Data for Import
To prepare your data for import, you will need to create a CSV import file or you can download the import file below. You will need to extract the csv file and save it.
A hard limit of 500 rows is supported via this tool, including the header row.
If you need to import more than this, create multiple import files and process them one-by-one.
Data Definition
This section contains a list of the required fields and a definition of what the system considers as valid inputs.
| Data field | Description | Mandatory? |
|---|---|---|
| ACCOUNT_ID | The Account ID. | Yes |
INVOICE_PERIOD_END_DATE Formatted as YYYY-MM-DD | The Invoice Period End Date. EG 2020-09-01 | Yes |
Viewing Imported Data
After importing data it is important to validate it was imported correctly. Choosing a random records and performing a visual check in Cumulus should reveal any mistakes relatively quickly that would be harder to see in an import sheet.
Invoices can be found via Customer > Invoices