Reporting API - Detailed Invoice Line Items

Reporting APIs can return detailed invoice line items. A comprehensive list of available Reporting API and functionalities can be found here:

APPXITE REPORTING API

Partners now have the flexibility to utilize a simplified view featuring consolidated invoice line items. However, when necessary, they can switch to a more detailed breakdown of invoice information. This allows for an easy understanding of charges across various subscriptions, while also providing access to specific details regarding pro-rated charges when needed.

In order to get detailed invoice line items in the API response the switch 'expand' in 'invoice-rows' endpoints (both 'general' and 'preview') needs to be populated with either values 'AllDetails' or 'CorrectionDetails' based on the requester preferences.

'CorrectionDetails' will show correction invoice line items, whereas 'AllDetails' will show all invoice line items. If you execute the call 'invoice-rows' without 'expand' enabled the entities retuned will be aggregated as per the subscriptionID. If you execute the call 'invoice-rows' with 'expand' enabled the entities retuned will not be aggregated anymore and there will separate entity as per each invoice line with 'vendorInvoiceRowId' populated. That value corresponds to Microsoft or other vendor invoice row id.

Additionally, it should be noted that rolled-up invoice line items are aggregated and the total amount is rounded to two decimal places. Conversely, expanded invoice line items are presented without any rounding, preserving the precise number of digits as provided by the vendor. To illustrate this, below is an overview of a sample calculation.

Overview of consolidated invoice line items vs expanded invoice line items:

Microsoft example:

You bought 10 seats of the “Microsoft 365 Business Standard“ subscription on October 1st and added and removed seats several times until October 7th.

October has 31 days. Unit Price = 3. Number of days in the charge cycle 31; used/unused days = 27 (10/5 to 10/31), including 10/5.

Microsoft invoice lines:

Note: For change event on 6th of October Effective Unit Price = 3 / 31 * 26 = 2.51 (cut down to two decimal digits). Please note the Microsoft does not apply rounding as full Effective Unit Price = 3 / 31 * 26 = 2.516129032 and thus rounded number should be 2.52 EUR. 

Reporting API invoice lines:

Consolidated invoice line items:

In consolidated invoice line-item view AppXite platform will provided all invoice line items with charge type Correction = -29 + 20.3 - 19.6 + 33.6 – 32.4 + 27 - 26.1 + 18.27 – 17.57 + 12.55 = - 12.95 EUR

Expanded invoice line items:

Additionally, if we use 'Expand' = 'AllDetails' for either of endpoints shown below, additional invoice 
details will be displayed in the field vendorDetails. That information comes directly for a vendor, and it can be for example the exact account or domain name the charge is for, or any other details:

• invoice-rows/{requesterId}
• invoice-rows/{requesterId}/preview