# 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

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:

To add these permissions:

Connect to the SQL Database Server using the SQL Server Management Studio (SSMS).
Go to Security > Logins folder.
Right-click the Open iT service account and select Properties.
Click the Securable page.
Look for Alter any linked server and Alter any login, then tick the checkbox in the Grant column.

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

Run the ConfigureInvoicing command using the Analysis Server Console Application to create a linked server and enable processing of the Application Cost Catalog.
Run the ProcessSQL command using the Analysis Server Console Application to immediately apply the updates. You may also wait for the next daily processing.

Go to the Analysis Server's Reporting tab.

If the Reporting tab is missing, run the ConfigureAll command using the Open iT Reporting Services Console.
Under View and Manage Reports, select Click here to open.
In the Open iT Reporting Services portal, go to LicenseAnalyzer Level 1 > Advanced folder.
Click on Invoice.
Specify all necessary parameters for the report.
Click View Report.
Once the report is generated, you can click on the Save icon to export the report in any of the supported formats.