Listing of Idle Distributions

Report Series Name
C-U-GL-Idle-Distributions

Report Name
Listing Of Idle Distributions

Library
Source code for this report is located in GLPUBLIC.

Use
Use this report to review your agency’s chart of account distributions for which there has been no GL posting activity since a specified date.   Distributions that are not being used and are not expected to be used in the future should be inactivated.  Correct any non-zero year-to-date balances before inactivating the distributions. 

Note:  For some agencies the results will be too large to update the reporting viewing (RVLS) screen.  It is recommended that you run this report directly to TSO or Systemware (XPTR, XTND).

Content
The report series compares the Last Activity Date on the company/account/center record to the date specified in the run-time parameters.  Distributions with a Last Activity Date prior to the parameter date or a Last Activity date of 00/00/0000 are selected for the report.  A Last Activity Date of 00/00/0000 means there has never been activity against this distribution.  For distributions with a Last Activity Date of 00/00/0000, the report indicates whether the distribution was added before the current fiscal year. 

The report series includes two reports:  ACCTLST and CNTRLST.  ACCTLST lists distributions where all account family members have had no activity since the specified date or have a Last Activity Date of 00/00/0000.  CNTRLST lists all distributions where every distribution in the center has had no activity since the specified date or has a Last Activity Date of 00/00/0000. 

The report series can be run for a specific company or range of company codes.  Additional exclusions include:

  • Equity accounts (3xxxxx)
  • Suspense account (99999999899)
  • Capital improvement centers (4xxx)
  • Special system centers (9999, 99999, 999999999999)
  • Inactive status code on company/account/center record

Totals
N/A

Column Headings

  • Company
  • Account
  • Account description
  • Center
  • Center description
  • Ytd balance
  • Last activity date
  • Distribution code (values are N or S)

N = This distribution has not been posted against since the parameter date; or if the Last Activity Date is 00/00/0000, this distribution was set up before July 1 of the current fiscal year.

S = This distribution was set up in the current fiscal year and has not been posted against.

Run Statements
The run statement member name is C-U-GL-Idle-Distributions-Run.

000100 option date-option (‘mm/dd/yyyy’)

000200 run c-u-gl-idle-distributions ;
000300 from library (glpublic) ;
000400 into library xxxxxxx ;
000500 variable inactive-date ‘mm/dd/yyyy’ ;
000600 select gl-company-id (‘XX  ‘ ‘XX99’)

Type over the displayed values with your agency’s values.