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.