Por Subir

GL TRANSACTION ACCOUNT STATEMENT REPORT
07/22/06



This report is one of the two types of Oracle “Monthly Account Statements” which are automatically run at the close of each accounting period and electronically distributed throughout UAB. However, this report can also be run ad hoc by end users, using the following procedure.

This report can be run on Oracle General Ledger(GL) data or Oracle Grants/Projects Accounting (GA) data. These instructions are applicable only to the Oracle General Ledger data, and therefore do not address the “GA” tab of the online parameters form.
You have your choice of three different versions of the Oracle GL Account Statement Transaction (MAST) report.  These options represent different levels of summarization of GL transactions.You can think of these three versions as ‘stepping’ or ‘drilling’ up/down through three different levels of information. The three versions are described below, followed by an example of the different levels of summarization:


• Detail Transaction Report 
o You would run this version only if you are doing very detailed analysis or problem-solving, because for Purchasing/Payablestransactions it is down at the Requisition/PO/Invoice line level.
o Since it is so detailed, you would normally run this version only on one specific account string at a time.
o This version lists all journal lines at exactly the level of detail in which they were originally posted to Oracle General Ledger. 


• Recap Transaction Report 
o Originally, uponimplementation in 2004, the Summary version was the version which was distributed as the official monthend Account Statement Transaction Reports. However, at the request of end users, this was changed in 2006 to use the Recap version. 
o This will probably be the most frequently run ad hoc version, since it retains all of the references which the user might need to track or reconciletransactions by document. 
o All posted non-$0.00 transactions are tallied up by the unique combination of references (Description / Requisition# / PO# / Invoice# / Check # / Ref/Posted Date) within Accounting Key & Period.


• Summary Transaction Report
o Originally, upon implementation in 2004, the Summary version was the version which was distributed as the officialmonthend Account Statement Transaction Reports. However, at the request of end users, this was changed in 2006 to use the Recap version. 
o This version is highly summarized; and as such, some of the references  (Requisition# /PO# /Invoice# /Check# /Ref/Posted Date) cannot be displayed on the report.  
o Within Accounting Key & Period, for the Claim On Cash balance sheet objectcode, all "Offset-Indirect Update" lines are collapsed into one line for the Period. 
o Within Accounting Key & Period, for each of the balance sheet bank cash object codes: Manual GL JEs will be summarized into one line for the Period with a standard displayed Description of “Net Manual GL JE Activity”; STARS transactions will be summarized into one line for the Period with a standarddisplayed Description of “Net STARS Activity”; TMS transactions will be summarized into one line for the Period with a standard displayed Description of “Net TMS Activity”; Payables transactions will be summarized into one line for the Period with a standard displayed Description of “Net AP Activity”; and any other types of transactions which might happen to post to a bank cash object code will besummarized by each unique displayed Description field.
o Within Accounting Key & Period, for Accounts Payable sourced transactions against each of the income statement utility expense object codes, all lines with a check number are summarized by check number ;  and all other lines for a particular vendor & reference combination are summarized.  
o Except for the special object...