Cube: Invoice Payment

Use this cube to report on totals of payment and remaining balances for clients, funders, or invoices. You can complete your report with information from the following dimensions:

Billing Period, Branch, Branch rollback, Client, Client Name, Employee, Employee Creation, Employee Creation Name, Employee Name, Employee Update, Employee Update Name, Facility, Funder.

Cube Fields

Fields related to the invoice:

• Invoicing Model
• Invoice Number
• Invoice Number Version
• Invoice Regenerated
• Invoice Amount
• Invoice Balance
• Invoice Status
• Invoice Type
• Invoice Posting Year
• Invoice Posting Month
• Invoice Posting Day

Billing period range:

• Billing Period Start Year
• Billing Period Start Month
• Billing Period Start Day
• Billing Period End Year
• Billing Period End Month
• Billing Period End Day

Fields related to the payment:

• Payment Type
• Invoice Date Diff
• Payment Method Name
• Payment Method Type
• Payment Memo
• Payment Year
• Payment Month
• Payment Day
• Payment Creation Year: these fields refer to the date a payment transaction is entered into the system.
• Payment Creation Month
• Payment Creation Day
• Payment Creation Time

Measures

• Payment Amount Sum