Reference Summary Report - ENREPS

This report produces a list of encumbered POs with the option of also printing disencumbered POs.

Would you like the Short Format? Enter "Y" to receive the one-line format of the report. Enter "N" to receive the verbose format which displays all information available for this option. When the NU Common Codes Category/Value of ENRE/RVERBOSE is defined, the report will be generated in an extra verbose format. This extra verbose format will support billions.
Selection Criteria: Selection Criteria can be used to determine which Encumbrance transactions will be included on the report.
Major to Minor Sort Order separated by Commas: Enter the manner to sort the report, listing the major (or outermost) sort first, followed by the minor sort(s) separated by commas. Expand the question to display the available sort items. The Sort option entered will determine the order the report is printed. It is using Selection Criteria to determine what transaction activity will appear on the report.

01 – Organization Key
02 – Object Code
03 – Fund
04 – Resource
05 – Project Year
06 – Goal
07 – Function
08 – Program
09 – Department
10 – Location
11 – Type (L)
12 – Major Object
13 – Budget Control
19 – Fully Qualified Account

At Which Sort Levels would you like Page Breaks? It is sometimes desirable to have reports produce page breaks. This is useful when certain subsections of reported information are desired. If the sort option desired indicates a sort by Officer within Object Code a page break for each Budget Officer could be produced. In producing a page break by Budget Officer, the report can be separated at the page breaks then given to each Budget Officer. Respond "0" for no page breaks.
At Which levels would you like Totals? If the user selected multiple sort options on the prior question, enter the level to display total lines. All levels above the one specified will automatically show totals. Enter "00" for a Grand Total only report. Sort levels will accumulate independent of the Page Break selected.

01 – Sort Level 1
02 – Sort Level 2
03 – Sort Level 3
04 – Sort Level 4
05 – Sort Level 5
06 – Sort Level 6
07 – Sort Level 7
08 – Sort Level 8
09 – Sort Level 9
10 – Sort Level 10

Would you like to include Disencumbered Ref's? Since disencumbered POs have a status of DE or FP and are never included as encumbrance balances in the General Ledger, the default is No to this prompt. Check the box (Yes) to view all encumbered and disencumbered amounts.
A two character code to produce desired report: The scope of the Encumbered Balances for Purchasing Summary Information report can be limited based on encumbered balances:

AB – Reports all encumbered balances.
CB – Reports all negative EN balances. These occur when the sum of payments made in Accounts Payable are less than the amount of the original encumbrance. If disencumbered, the Purchase Order was originally encumbered for an amount greater than payment was made.
DB – Reports all positive EN balances. These occur when the sum of payments made in the Accounts Payable exceed the amount of the original encumbrance. This option is used to select Purchase Orders that do not have encumbrance balance remaining.
ZB – Reports zero-dollar encumbrances. These occur when the sum of payments made in Accounts Payable is exactly the same as the amount of the original encumbrance.

'As of' Date: This prompt supports prior period reporting of Encumbrance transaction information. It is common to "backdate" reports to a specific point in time.
From which perspective do you want totals? Select "PO" to have totals equal the encumbrances shown minus the payments shown. Select "GL" when wanting totals to reflect the contribution of what is shown to encumbrances balances in GL. They differ for three reasons:

Encumbrances contributions to GL by reference/account cannot be negative.
Particular accounts in an open reference can be closed, contributing zero to GL regardless of encumbrances minus payments.
Entire references can be closed, contributing zero to GL regardless of encumbrances minus payments.

Note that for GL balances to be valid, all records across all time for reference/account must be taken together. Selection criteria and sort ordering can thus invalidate GL totals.

Options

How do you want dollars formatted? Enter the three-character code to set how you would like to see dollar amounts formatted for this report.
Which Negative Amount Format to use: Enter the two-digit code for the negative amount format to use:

"00" – Use minus sign (e.g., -327698)
"01" – Use negative brackets (e.g., [32768])

Do you want GL Bal By Acct within Ref shown?