The Load process generates revenue ledger records for the selected fiscal year that are received by the General Fund, along with the associated data needed for the Data File Load (DFL).
If the Full Account Format option is selected on the Fund Accounting Profile page, the General Fund field on the Profile page has no drop-down values. If the General Fund field is empty, the load process does not filter revenue ledger records by fund and loads revenue records for all funds for the selected fiscal year.
The first character of the revenue ledger account code is stripped off if it contains an alphabetic character. The revenue source code is determined from the revenue ledger key organization based on the levels of the organization specified in the Profile.
Before the standard state code lookup runs, the system checks the AFR Revenue Crosswalk table for any pre-rollup rules that match the local revenue values at the configured levels. If a matching rule is found, the system uses the state value from the crosswalk rule instead of the local value when searching the AFR State Revenue Codes table. If no matching rule is found, the load process continues with the original local values. Set up pre-rollup crosswalk rules on the PA Annual Financial Report - AFR Revenue Crosswalk page before loading data.
The amount is calculated as the sum of the year-to-date receipts through period 13 for the specified fiscal year.
Each revenue source code is compared to the list of acceptable state-defined revenue codes in the AFR State Revenue Codes table. If the revenue source code is not found, the process attempts to roll up the code by replacing the last non-zero digit with a zero. It re-searches the state-defined revenue code list. This process continues until the state-defined revenue code is determined. If a state-defined revenue code cannot be determined, an ERROR statement is logged.
The details of the AFR revenue code and calculated amounts are saved for each revenue key organization and account.
Use the PA Annual Financial Report - Load Revenues page to specify the criteria for loading the required data for the report.
-
On the PA Annual Financial Report - Revenue Detail page, select Load.
-
Select the Year.
-
Select Accept.
-
If data for the selected criteria is loaded, select OK to delete and reload the data.
-
If errors are encountered, save the Load Error log. The file name is AFRexp_load.log.
If the Full Account Format option is selected on the Fund Accounting Profile page, the load error log includes the full account string for each record that generated an error, in addition to the key organization. -
Select OK.
-
Navigate to the log location using the View Files page.
-
Download and inspect the log. Refer to Maintain data and update the data as necessary.
-
Repeat these steps until no errors are encountered and all required data is loaded.