# Invoice Reporting

The Open iT Invoice template is a standard report in Analysis Server primarily used for pay-per-use agreements and chargeback/showback.

Sample Invoice Report

Sample Invoice Report

Here are the definition of each terms in the invoice template.

Item Description
Attention to The name of the person to whom the report is addressed.
Cost Center The name of the cost center or cost center code.
Description The title or explanation of the report.
Period The span of time covered in the report.
Fixed Charges The total amount of fixed cost depending on the type of agreement.
Usage Charges The total amount of charge for extra usage.
Total Amount The total amount of charges, which is the sum of Fixed Charges and Usage Charges.
Units Included A fixed number (of licenses) incorporated in the agreement equivalent to the value set in the Units Included as defined in the Application Cost Catalog.
Fixed Cost The standard fixed cost corresponding to the Units Included.
Total Usage The total amount of usage. This is metered as elapsed time, the sum of distinct users per day, or the sum of max used licenses per day.
Exceeding Usage The amount equivalent to the difference between Total Usage and Units Included. If Total Usage is the same as Exceeding Usage, there is no Units Included defined for that application.
Exceeding Usage Amount The total cost of exceeded usage. This is the amount equivalent to Exceeding Usage multiplied by the Unit Cost.
Open iT Invoice: Definition of Terms

The following sections will guide you on the required steps to set up an invoice report once the LicensePlanner configurations are done.

# Setting Necessary Permissions to Manage Linked Server

The minimum permission required to create or delete a linked server are:

  • ALTER ANY LINKED SERVER
  • ALTER ANY LOGIN

To add these permissions:

  1. Connect to the SQL Database Server using the SQL Server Management Studio (SSMS).

  2. Go to Security > Logins folder.

  3. Right-click the Open iT service account and select Properties.

  4. Click the Securable page.

  5. Look for Alter any linked server and Alter any login, then tick the checkbox in the Grant column.

# Configuring Invoice Reporting

Before proceeding, make sure that you have the necessary permissions to manage linked server.

  1. Run the ConfigureInvoicing command using the Analysis Server Console Application to create a linked server and enable processing of the Application Cost Catalog.

  2. Run the ProcessSQL command using the Analysis Server Console Application to immediately apply the updates. You may also wait for the next daily processing.

# Creating an Invoice Report

  1. Go to the Analysis Server's Reporting tab.

  2. Under View and Manage Reports, select Click here to open.

  3. In the Open iT Reporting Services portal, go to LicenseAnalyzer Level 1 > Advanced folder.

  4. Click on Invoice.

  5. Specify all necessary parameters for the report.

  6. Click View Report.

  7. Once the report is generated, you can click on the Save icon to export the report in any of the supported formats.

We value your feedback!

Please take a few minutes to complete our survey and share your thoughts on your recent experience with our documentation.

Take survey

Close