Construction in Progress (CIP) Summary Report
Important
Information and features vary according to the roles to which you belong and the permissions associated with those roles. For more information, contact your module manager or your campus support team.
Use this page to run the CIP Summary report, which includes a list of asset CIP amounts grouped by their GL CIP account numbers. It should be used to reconcile asset CIP amounts with the general ledger.
In the Asset Management Reporting role, select "Can generate Construction in Progress (CIP) Summary report" in the Reports section. If users don't have this permission, they won't be able to access the Construction in Progress (CIP) Summary Report page.
This report is generated on the CIP Summary Report window in Desktop.
Note
The Fiscal Month field on the Desktop window corresponds to the Fiscal Period field in Jenzabar One Web.
The Reports field on the Desktop window corresponds to the Report Layout field in J1 Web.
Tip
Your school's Current Fiscal Year is set on the General Ledger Settings page in J1 Web or the General Configuration window in Desktop. The future fiscal year is the one immediately after the defined current fiscal year.
Choose the Fiscal Period you want to run the report for. Options include the months in your school's current and future fiscal years.
Choose a Report Layoutt. The default is the original layout, and options include any customized versions.
Enter a Report Title (30-character limit).
Select one or more File Format options. You can select from:
PDF
CSV
DIF
HTML
PSR
SQL
TXT
XLSX
XML
Click Generate.
If you selected a single file format of PDF, your report will open in a new tab of your browser. Use the PDF browser options to save your file.
If you selected multiple file formats or a single format other than PDF, you will see the Save As window where you can name and save your ZIP file. When you extract the .zip file, your report in the selected file formats will be available.
Important
Access to the folders where Jenzabar-provided original reports are stored is controlled by your institution. For more information, contact your campus support team or see Working with Reports in J1 Web.
Open InfoMaker.
Click File > Select Library.
On the Select Library pop-up, navigate to the shared folder where Jenzabar-provided original reports and queries are stored.
Select the PBL (PowerBuilder Library) file that contains the report or query you want to customize.
Click OK.
Click the Open icon.
On the Open pop-up, in the Object section, select the report or query you want to customize.
Click OK.
Customize the report or query as needed.
Save the customized version in the shared folder by adding a unique, easily identifiable extension to the file name.
Tip
By default, InfoMaker will save the customized version in the same folder that you opened the original version from. Confirm the file path is correct in the Library section.
On the corresponding report page in J1 Web:
Customized versions of queries will display in the Query or Data Set drop-down.
Customized version of reports will display in the Report Layout drop-down.
In most cases, yes. Customized versions of the report created in Desktop before your school started using J1 Web should be available as options in the Report Layout drop-down. If your school created new customized layouts in Desktop and copied them to the appropriate location on the J1 Web server, those reports are also available in the drop-down.
However, certain reports were modified to be used in J1 Web (i.e., the base report for J1 Web is different from the base report in Desktop). In those cases, the customized versions from Desktop will not work even when they are moved to the correct location on the J1 Web server. You'll need to re-customize those reports from the original version of the J1 Web report by following the instructions to Customize Reports for J1 Web.
See the help for each report page for guidance about customizing a specific report.
For the customized versions of the report created in Desktop to appear as choices in the Report Layout field drop-down, your campus support team needed to complete certain steps as part of the installation process. For more information, contact your campus support team or see Working with Reports in J1 Web.
Tip
Only custom versions of the report created in Desktop before J1 Web installation will appear as choices in the Report Layout field drop-down. Reports customized in Desktop after you've installed J1 Web are not available in the drop-down unless they have been copied over to the appropriate location on the J1 Web server.
r_gl_cip_summary_report
In the Asset Management Reporting role, select "Can generate Construction in Progress (CIP) Summary report" in the Reports section. If users don't have this permission, they won't be able to access the Construction in Progress (CIP) Summary Report page.
The report lists the following information for each asset created before or during the month selected:
Asset Account
Account Description
Asset Number
Asset Description
Cost Date
Invoice Number
Invoice Account
Asset Cost
Account Total
All Account Numbers Total
Many finance reports are created using long running processes. This means that when you generate a report, you won't see an immediate result. However, you can continue working in J1 Web while your report generates. When it's ready, you will receive a notification that you can access in the Notification Center.