Generate Joint Interest Billing Reports

Perform the following steps to run the process to generate joint interest billing reports. Only joint venture distributions in Process Complete status are recognized by this process.

Navigate to Tools, Scheduled Processes.
On Schedule New Process, search for the Submit Joint Interest Billing Report process by job.
To select the data for the report, complete the following fields:
- Joint Venture. Select a particular joint venture to include processed distributions for only this joint venture in the report. Leave this field blank to include the distributions for all your joint ventures.
- Stakeholder. Select a particular stakeholder to include processed distributions for only this stakeholder in the report. Leave this field blank to include the distributions for all stakeholders.
Use the Process By drop-down list to select distributions by period or accounting date.
- If you select Period, then specify a period in the field provided. If you leave this field blank, the process will select processed distributions that have an accounting date corresponding with the earliest open period.
- If you select Accounting Date, you must enter a date range in the following fields, otherwise the process will issue an error.
  - From Date
  - To Date
For the Report Date, enter the date the joint interest billing report is generated. If you leave this field blank, the current date will be used as the report date.
To select the report template to use, complete either of the following fields:
- Template Source. Select the template specified in the joint venture definition or the template specified for each stakeholder.
- Override Template. Select a template from the drop-down list. The list displays all the available BI Publisher templates for joint interest billing report.
For the Delivery Method, select a value from the drop-down list. The default delivery method is Email.

Note: You must select the same delivery method that you specified in the bursting definition SQL query in BI Publisher.
If you select Email as the delivery method, complete the Sender’s Email Address field.
This information is required if you specified Stakeholder as the Template Source or selected an override template. If you specified Joint Venture as the Template Source but haven’t entered a sender’s email address on the joint venture definition, you must complete this field. The sender’s email address you enter here will override the email address on the joint venture definition, if available.
Click Submit.
The process uses a combination of a parent process and subprocesses to generate the reports and deliver them to stakeholders based on the delivery method you specified.
To view the reports you generated:
- Click an instance of the Print Joint Interest Billing Report: Subprocess in the Search Results section. You can view a list of all the reports created from this subprocess in the Output and Delivery section.
- Click a report name to open and view the report. You can then proceed to download or generate the report.
To view the processing details in a report, click the Process Details tab, select the “…more” link next to Attachment, and then click the .txt file.

Note: If the process can’t generate reports for some stakeholders or joint ventures due to errors, the report includes the details of the errors, such as template not found for a particular joint venture, stakeholder email address not specified, and so on.