Detail Transaction Ledger (for closed years) Report

Report Series Name

C-U-GL-DTL-Ledger-Dapg67-EOY

Report Name

Detail Transaction Ledger

Library

Source code is located in GLPUBLIC.

Use

Use this report to obtain detail transaction data to support an account balance for closed fiscal years that have been purged from the C-DETAIL file.

Refer to C-U-Gl-Detail-Ledger-Dapg67 to create the Detail Transaction Ledger for balances on the open years file (C-DETAIL).

Content

This report contains detail transaction information processed through NCAS modules and interfaces into General Ledger. The report pagebreaks as the Company/Center combination changes. The transactions on the report may be limited by effective date, company, account, and center ranges.

Totals

This report gives totals by period and account within center.

Column Headings

EFF DATE - the effective date to which the transaction is posted

DOCUMENT - lists the transaction key as applicable for the source system

AP Invoice Number

AR Check Number

BC Document ID

DS DAS Check Number

IN Transaction Type

PS PO Number, Buyer ID

all others positions 1-11 of GL-DOCUMENT-KEY field as passed to GL.

ENTY - lists either the paying entity, buying entity, or AR company code as applicable to the transaction type. This field may also be blank.

Additional Descriptive Info - lists additional identification information for the transaction as applicable for the source system.

AP Vendor Short Name; Control Group Date; Control Group Number

AR Customer Number, Batch Number, Date, Transaction Description

BC GL Description 1

DS DAS Control, Object, and RCC Codes

IN Item Number and Description (20 characters)

PS blank

all others GL Description 1

DEBIT - lists amounts posted as debits

CREDIT - lists amounts posted as credits

BALANCE - lists the balance. Beginning Balances are taken from the NCAS account balance as displayed on GL screen 16. Period Balances and Ending Balances are calculated as Beginning Balance + Debits - Credits.

SY - lists the abbreviation for the transaction source system.

AP Accounts Payable

AR Accounts Receivable

BC Budgetary Control

DS DAS Interface

IN Inventory

PS Purchasing

all others refer to Source Code ID Listing

Run Statements

The run statement member name is C-U-GL-DTL-Ledger-DAPG67-E-Run.

001000 option date-option('mm/dd/yyyy')

001100 run c-u-gl-dtl-ledger-dapg67-eoy ;

001200 from library glpublic ;

001300 into library xxxxxxxx ;

001400 variable from-effective-date ;

001500 'mm/dd/yyyy' ;

001600 variable thru-effective-date ;

001700 'mm/dd/yyyy' ;

001800 variable fiscal-year ;

001900 nnnn ;

002200 select c-gl-company-id ;

002300 'xxxx' ;

002400 select c-gl-account-id ;

002500 'xxxxxxxxxxxxxxxxxx' ;

002600 select c-gl-center-id ;

002700 'XXXXXXXXXXXX'

Type over the displayed variable values with your agency's values.

The Fiscal-Year variable is used in selecting the ending balance amounts on the report. Replace the 'NNNN' with the four-digit fiscal year identifier corresponding with the date values in the from-effective-date and to-effective-date fields. For example, if the effective date range is 07/01/1996 to 09/30/1996, the Fiscal-Year variable should be '1997'.

Use the From-Effective-Date, To-Effective-Date, C-Gl-Company-Id, C-Gl-Account-Id, and C-GL-CENTER-ID selection statements to limit the scope of the report. The criteria can be set to select single values or a range of values. Comment out the selection and value statements to select all values.