Use this screen to print a report that displays ACRN project data and values. This screen evaluates record data in the Maintain ACRN Bills screen.
You can click the Preview Default Report button to view the report output on your screen, or you can click the Print Default Report button to send the report to a printer, file, or via email.
Use this screen when you need to determine whether project ACRN data has been entered correctly during initialization and/or to review ACRN allocation amounts that have been computed using the Calculate ACRN Billings screen (Projects » Billing » Calculate Billings).
You can print the Print ACRN Billing Edit Report at any time.
Printing before executing the Calculate ACRN Billings screen (Projects » Billing » Calculate Billings): the report will display 0.00 values in the Current ACRN Allocation Amounts column in that screen; however, this may be beneficial if you have initialized project data and would like to review your data entry.
Printing after executing the Calculate ACRN Bill process, but before the Post Bills process: the report will include the ACRN Funded Value, Current ACRN Allocation Amount, Total ACRN Allocation Amount, and Remaining ACRN Value. Using this report, you can determine whether the Current ACRN Allocation Amount should be edited before printing the Standard Bill. Also, the report will provide a warning if the total allocation amount (calculated by the Calculate ACRN Billings application or edited via the Maintain ACRN Bills screen (Projects » Billing » Billing Master)) does not equal the invoice amount (calculated by the Calculate Billings screen (Projects » Billing » Calculate Billings)). An inequality between the two amounts can occur if there is not adequate funding for the calculated allocation amounts, if there are over-ceiling amounts that could not be allocated (over-ceiling amounts are not currently allocated because no account ID exists for these records), or if someone incorrectly edited allocation amounts.
Printing after executing the Calculate ACRN Bills and Post Bills processes: the report will not display Current ACRN Allocation Amounts, but will provide an accurate Total ACRN Allocation Amount and Remaining ACRN Value amount, which may be useful if funds are diminishing. The Project Manager can use this report to determine whether additional funding may be required to complete the task.
Use this required drop-down list to select the range of projects to be included when you run this process. Valid options are:
All Select this option to include all projects in the process. The From and To fields will be disabled if you select this option.
One Select this option to include only one project. You must enter the project in the From field. The To field will be disabled if this option is selected.
Range Select this option to include a contiguous range of projects in the process. You must enter the beginning value for the range in the From field and the ending value of the range in the To field.
From Beginning Select this option to include all the projects from the beginning value of available projects to a specific project in the range. You must enter the last value of this range in the To field. The From field will be disabled if you select this option.
To End Select this option to include all the projects from a specific project to the end of all the available projects. You must enter the value with which you want the range to start in the From field. The To field will be disabled if you select this option.
Select this check box to create a customized, non-contiguous list in the list box. The list mode function is different from using a Range because you can include or exclude any projects of your choice.
Using the Range drop-down list, select one of the following options:
All
One
Range
From Beginning
To End
Enter the project in the From field and/or the To field. Click the Apply button to add this project or range of projects to the Noncontiguous Range list box. Once you have selected the list mode, any projects appearing in the From/To range will not be printed unless they have been added to the Noncontiguous Range list box with the Apply button. To remove a selection from the Noncontiguous Range list box, highlight the row and click the Remove button.
After you have selected the List Mode check box and entered a To/From project, click the Apply button to include the project (or range of projects) in the file.
Use this button to remove a project or a range of projects that you previously selected.
Use this drop-down list to select the range of Billing Groups that you want to include in your process. This option will be available only if the Assign Bills to User Groups check box is selected in the Billing Settings screen. Valid options are:
All Select this option to include all available groups in the process. The From and To fields will be disabled if you select this option.
One Select this option to process only one group. You must enter the group that you want to include in the From field. The To field will be disabled if you select this option.
Range Select this option to include a contiguous range of groups in the process. You must enter the beginning value for the range in the From field and the ending value of the range in the To field.
From Beginning Select this option to include all the groups from the beginning value of available groups to a specific group in the range. You must enter the last value of this range in the To field. The From field will be disabled if you select this option.
To End Select this option to include all the groups from a specific group to the end of all the available groups. You must enter the value with which you want the range to start in the From field. The To field will be disabled if you select this option.
Use this group box to include or exclude active and inactive ACRN projects.
Select this check box to include ACRN projects that are active because the Active check box is selected in the Maintain ACRN Bills screen (Projects » Billing » Billing Master).
Select this check box to include ACRN projects that are inactive because the Active check box is unselected in the Maintain ACRN Bills screen (Projects » Billing » Billing Master).
Select this check box to include ACRN projects that do not have any ACRN current allocation amounts. You would select this check box when verifying initialized project data.
Select this check box to include ACRN or ACRN/Line Item data and amounts designated as inactive in the Active field of the Maintain ACRN Bills screen (Projects » Billing » Billing Master). Leaving the check box empty is beneficial because it reduces the number of rows printed on the report for a project that has several inactive ACRN or ACRN/Line Items.
Select this check box to include ACRN or ACRN/Line Item data and amounts that have a remaining ACRN value equal to 0.00, according to the Remaining ACRN Value field in the table window of the Maintain ACRN Bills screen.
The following are source tables whose data is evaluated when you print this report:
PROJ_BILL_ACRN (Maintain ACRN Bills)
PROJ_ACRN_DETL (Maintain ACRN Bills)
PROJ (Maintain Project Master)