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.

Run Statements
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 agency’s values.