Outstanding Encumbrance Listing Report
Report Series Name
C-U-AP-PS-OUTSTNDG-ENCUMB
Report Name
OUTSTANDING ENCUMBRANCE
LISTING
Library
Source code is located in
APPUBLIC
Use
Use this report to research
purchasing and accounts payable encumbrance balances for selected accounting
distributions.
Content
This report shows outstanding
encumbrances for payables and purchasing. It includes run-time variables
for selecting transactions by company, accounts, and centers.
Totals
This report gives totals
for center, account and company.
Column Headings
- COMPANY - company charged on this purchase order/invoice line
- ACCOUNT - account charged on this purchase order/invoice line
- CENTER - center charged on this purchase order/invoice line
- SRC SYS - source system code. Options are AP (accounts payable), PS (purchasing) or INV (inventory).
- BE/PE - buying entity or paying entity code
- PO#/INV# - purchase order number or invoice number
- LINE - purchase order line number or invoice line number
- VENDOR - vendor short name as listed in the NCAS vendor file
- REMAINING ENCUMBRANCE - amount of the outstanding purchase order and invoice encumbrances.
The run statement member name is C-U-AP-PS-OUTSTNDG-ENCUMB-RUN
000600 OPTION LIBRARY(APPUBLIC)
000700 RUN C-U-AP-ENCUMBRANCE-EXTRACT
000800 INTO LIBRARY XXXXXXX
000900 SELECT AP-PAYING-ENTITY
001000 'XXXX'
001100 SELECT AP-LINE-EXP-GL-COMPANY-ID
001200 'XXXX'
001300 SELECT AP-LINE-EXP-GL-ACCOUNT-ID
001400 'XXXXXXXX'
001500 SELECT AP-LINE-EXP-GL-CENTER-ID
001600 'XXXXXX'
001700 *
001800 *
001900 *
002300 OPTION LIBRARY(APPUBLIC)
002400 RUN C-U-AP-PS-OUTSTNDG-ENCUMB
002500 INTO LIBRARY XXXXXXX
002600 SELECT PUR-PO-BUYING-ENTITY
002700 'XXXX'
002800 SELECT PUR-PO-LINE-GL-COMPANY-ID
002900 'XXXX'
003000 SELECT PUR-PO-LINE-GL-ACCOUNT-ID
003100 'XXXXXXX'
003200 SELECT PUR-PO-LINE-GL-CENTER-ID
003300 'XXXX'
Type over the displayed variable values with your agencys values.