Individual Late Invoice Records Explained

To access the individual record data double click on a Summary Report table line item. This will populate the individual record table.

The Individual Record data table contains more detailed information, please see below the column descriptions.

Partner: This is the Business Partner number for the individual customer.

Contract Account: This is the Contract Account number that relates to the Business Partner number.

Standard Company Code: This is the a code that defines an organizational unit used in accounting.

Account Class.: This defines the customer type. e.g. Domestic or Business use.

Last Print Document: This is the last Invoice Document that was created for the contract that has not been outsorted. This populates when the Milestone is above the ‘‘INVT’‘ Milestone and there is an Invoice Document on the customer account.

Print Date: This is the date last Invoice Document that was sent for printing. This populates when the Milestone is the ‘‘PRDT’‘ Milestone and there is an an earlier Invoice Document on the customer account.

Process: This refers to the process the lock present on the customers account relates to. e.g. Dunning, Payments etc.

Lock Category: This refers to what object a lock has been applied. e.g. The lock the specifically relates to a Print Document.

Lock Reason: This is the business reason the lock was applied and the contract remains uninvoiced. e.g. Customer Complaint, Bill Complaint etc.

Blocked: This is a quick indicator to show this record has a Lock registered against it.

Contract: This is the Contract number that relates to the Contract Account number.

Installation: This is the Installation number that relates to the Contract Account number.

Start billing period: This is Day+1 of the last invoice produced. This is the earliest Billing Period date that remains uninvoiced.

Last Bill Document: This is the last Billing Document produced for the contract that has not been outsorted. This only populates when the Milestone is above the ‘‘BOUT’‘ Milestone.

Scheduled billing date: This is the earliest Scheduled Billing Date that remains uninvoiced.

Milestone: This is the last successful invoicing step completed for the contract.

Price: This is an estimated value of the un-invoiced energy consumption excluding VAT/Tax/HST for the late billed period. This is calculated based upon the average price per day for a customer with the same attributes i.e. average price is calc using billing history and captured based on customer account type – Company Code, Contract Account Category, Account determination ID for IS-U contracts, Division, Billing class, Rate category, Late Billing Price, Transaction Currency. The average price is then multiplied by the late billed days to determine the price.

Transaction Currency: This is the currency the account is assigned.

Late Billed Days: This is the number of days the contract has remained un-invoiced based on the selection when producing the report. i.e. Start of Bill Per. => Key Date or Sched. Bill Date => Key Date.

Billing block reason: This is the business reason the block was applied and the Contract remains un-invoiced. e.g. Customer Complaint, Bill Complaint etc.

Blocked: This is a quick indicator to show this record has a block registered against it.

Move-In Date: This is the Contract Move-In Date

Move-Out Date: This is the Contract Move-Out Date.

All of the records provided within this section are subject the initial selection criteria.