| Custom Operational Reports
- Fixed Assets (Updated Oct-2007) |
| Description |
Purpose
Parameters/Filters/Sorts/ |
Data Displayed
Special Criteria |
|
DOE FA Asset Retirement Report (Custom)
|
| Reports assets retired and also shows the retirement type. |
Used to identify those fixed assets retired with a display of the retirement type. |
Displays Columns:
Asset Number – Description, Date Placed in Service, Retirement Type, Date Retired, Cost Retired,
Net Book Value Retired, Proceeds of Sale, Removal Cost, Gain/Loss, Trans Number |
Parameters:
Book - Required
Set of Books Currency - Required
From Period - Required
To Period - Required |
Special selection criteria:
th.transaction_key = 'R'
falu.lookup_type = 'ASSET TYPE' |
|
DOE Fa Clearing Acct. Reconciliation Report (CSV)
|
| The Production STARS
Fixed Assets (FA) Module Clearing Account
reconciliation process.
The objectives of this process and reporting
ability are as follows:
To identify the list of Clearing SGL accounts to be reconciled
To identify the level of reconciliation to be performed
|
Used to identify either the
cleared transactions or outstanding transactions |
Displays BATCH_NAME, JOURNAL_NAME,
JE_SOURCE, PERIOD, CCID, FUND, YEAR, ALLOTTEE,
REP_ENTITY, SGL, OBJ_CLASS, PROGRAM, PROJECT,
WFO, LOCAL_USE, FUTURE, DEBIT_AMT, CREDIT_AMT,CLEARED,
NET_AMT, PO_NUMBER, ASSET_NUMBER, JE_CATEGORY,
CID, ASSET_TYPE, ASSET_STATUS, OPI, ENV_LIAB_TYPE,
REFERENCE_4, GL_LAST_UPDATE_DATE, CUST_LAST_UPDATE_BY,
CUST_LAST_UPDATE_DATE |
Parameters:
|
Selection criteria:
- AND gcc.segment5 in ('19909300','17209300')
- AND gjh.actual_flag = 'A'
- AND gjl.status = 'P'
- AND gjh.currency_code = 'USD'
|
|
DOE FA CLEARING ACCT. RECONCILIATION
SUMMARY REPORT
|
| The Production STARS
Fixed Assets (FA) Module Clearing Account
reconciliation process.
The objectives of this process and reporting
ability are as follows:
To identify the list of Clearing SGL accounts to be reconciled
To identify the level of reconciliation to be performed
|
Used to identify the net amounts
by ‘cleared’ column and also
as a comparison checkpoint it shows the ending
balance from GL Balances table. |
Displays Cleared Type, Net Amount
output is in a text format. |
Parameters:
- SGL Account
- The hidden parameter is ‘Period
Name’. This parameter is populated
with the same period that the process
was last run
|
Selection criteria:
- AND gcc.segment5 in ('19909300','17209300')
- AND gjh.actual_flag = 'A'
- AND gjl.status = 'P'
- AND gjh.currency_code = 'USD'
|
|
DOE FA GL Reconciliation Report Procedure
|
| This procedure populates
temporary tables based upon the input parameters
and submits three different reports for the
user to view. DOE FA GL Reconciliation (custom)
DOE FA GL Reconciliation - by Fund/SGL (Custom)
DOE FA GL Reconciliation Details (Custom)
- CSV |
This report process automates
the comparison of the two following FA/GL
reports so only exceptions are reported.
DOE Fixed Asset Module Balances by AFF CSV
(Custom)
DOE GL Fixed Asset Balances CSV (Custom)
|
Differs based upon report |
| |
-- TOTAL Column Values are only
those SGLs 17% or 18% or 19909300
-- IC values are all the Reporting entities in ICPAR parent valueset
-- PMA values are all the allottees between 90 and 95
-- FERC values are allottee 96
-- NON-IC values are CIDs – RL13200, RL14047, RL14655, RL12367, and
M0RDONATE |
|
DOE FA GL Reconciliation (Custom)
|
| Compares the account
balances in the general ledger with the balances
associated with the appropriate Asset Categories
in the Fixed Asset module |
Use this report to compare the
sub-module accounting data to accounting
data stored in the general |
WFO: 3000018
Order Num: CAP AGR492P00990000500 Rec. Account |
| SGL Account, Asset Category,
Date, Exceptions Only, Cumulative |
|
|
DOE FA GL Reconciliation - ASSETS (Custom)
|
|
Report lists Additions and Adjustments
of assets in a specific period
|
Used to identify new and adjusted assets
for Period Asset reconciliation
|
Displays GL-Header Description, Fund SGL,
Allottee, Entered DR, Entered CR
|
|
Parameters: Period
|
-- GL JE Source = Assets --
Segment5 contains any of 17110000, 17120000,
17300000, 17400000, 17500000, 18100000, 18200000,
18300000, 18320000, 18900000, 19909300 |
|
DOE FA GL Reconciliation - CIP (Custom)
|
| Report lists Additions
and Adjustments of CIP assets in a specific
period |
Used to identify new and adjusted
CIP assets for Period Asset reconciliation |
Displays GL-Header Description,
FundSGL, Allottee, Entered DR, Entered CR |
| Parameters: Period |
-- GL JE Source = Assets
-- Segment5 contains either 17200100 or 17209300 |
|
DOE FA GL Reconciliation - CSV (custom)
|
| Compares the account
balances in the general ledger with the balances
associated with the appropriate Asset Categories
in the Fixed Asset module |
Use this report in CSV output
to compare the sub-module accounting data
to accounting data stored in the general |
WFO: 3000018
Order Num: CAP AGR492P00990000500 Rec. Account |
| SGL Account, Asset Category,
Date, Exceptions Only, Cumulative |
|
|
DOE FA GL Reconciliation - DEPRECIATION
(Custom)
|
| Report lists Period
Depreciaion by Allottee |
Used to identify asset depreciation
by allottees for Period asset reconciliation |
Displays GL-Header Description,
FundSGL, Allottee, Entered DR, Entered CR |
| Parameters: Period |
-- GL JE Source = Assets
-- Segment5 contains any of 17190000, 17390000, 17490000, 17590000, 18190000,
18290000, 18390000, 18490000, 18909900, 18990000 |
|
DOE FA Mass Additions Verification Report
|
| Report lists records from the Mass Additions table. |
Used to identify and check the work before posting the Mass Additions |
Displays in CSV format: INVOICE_NUM, ADD_TO_ASSET_ID, ASSET_TYPE, LAST_UPDATE_DATE,
POSTING_STATUS, FIXED_ASSETS_COST, ASSET_CATEGORY, ACCOUNTING_DATE, AP_DIST_LINE_NUMBER, INVOICE_DATE,
PO_NUMBER, FUND, YEAR, ALLOTTEE, REP_ENTITY, SGL, OBJ_CLASS, PROGRAM, PROJECT, WFO, LOC_USE,
FUTURE |
Parameters:
Post Status |
This report shows only the active transactions that are in Mass Additions Table.
If the Mass Addition transaction is added to an asset, then the asset category and Asset history
distribution AFF are displayed. Otherwise, the new asset’s category and Mass Additions
Distribution depreciation expense account’s AFF is displayed. |
|
DOE FA Reconciliation to Invoice/Payments
(Custom)
|
| Detailed report for
reviewing FA to Invoice/Payments |
Report used for FA to Invoice
reconciliation |
Displays PO Number, PO Line
Num, PO Shipment Num, PO Distribution Number,
PO Distribution ID, PO Price, Unit of Measure,
Quantity Ordered, Quantity Received, Quantity
Billed, CCID, AFF, Invoice Number, Invoice
Distribution Amount, Invoice Creation Date,
PO T-code, Invoice T-code, Payment T-code |
| Parameters: Period Name, SGL
Account, PO Number |
-- Displays only matched invoices
-- Displays POs that have been received with the receiving transaction
type of DELIVER or RETURN TO RECEIVING |
|
DOE FA Reconciliation to PO Receipts
(Custom)
|
| Detailed report for
reviewing FA to PO Receipts |
Report used for FA to PO Receipts
reconciliation |
Displays Org, PO Number, PO
Release Num, PO Line Num, PO Shipment Num,
PO Distribution Number, PO Distribution ID,
PO T-code, Receipt Num, Receiving Transaction
ID, Receipt T-code, Transaction Quantity,
Transaction Type, Transaction Creation Date,
GL Date, AFF, Fund Expiration Date, Fund
Cancel Date, ASAP Flag, Last Updated By,
Location |
| Parameters: Period Name, SGL
Account, PO Number |
-- Display POs that have been
received with the receiving transaction type
of DELIVER or RETURN TO RECEIVING |
|
DOE FA STALE CWIP Report (CSV output)
|
| Used to identify (Construction Work In Progress) CWIP Ending Balances
that need to be reviewed,completed,written off or confirmed that the asset is not complete. |
Reports only those assets that are equal between two ending balances based on two
periods |
Displays ASSET_ID, ASSET_NUMBER, CID, PERIOD_FROM, PERIOD_TO, ENDING_BALANCE_FOR_PERIOD_FROM,
ENDING_BALANCE_FOR_PERIOD_END, VARIANCE, LAST_ACTIVITY_DT, FUND,APPROP_YR, ALLOTTEE, REPORT_ENTITY,
SGL, OBJECT, PROGRAM, PROJECT, WFO, LOCAL, FUTURE, CREATION_DATE |
Parameters:
- Period From thru To (required)
- Allottee
|
|
|
DOE Fixed Asset Balances (Custom)
|
|
Report lists the AFF components, CID and
balances for a selected accounting period
for all FA SGL values (17* and 18*).
|
This report is used to facilitate analysis
of Fixed asset data.
|
Displays Appr Yr, Allottee, Report Entity,
SGL, Object Class, Program, Project, WFO,
Cid, Balance
|
|
Parameters : Fund, allottee, reporting
entity, object class, program, project, wfo,
CID, AFF
|
Only display SGL values of 17* and 18*
|
|
DOE Fixed Asset Module Balances by
AFF CSV (Custom)
|
| Provides a CSV file
with the AFF components , PO Number, and
Module information |
Facilitates Fixed asset data
research and analysis |
Displays Asset Num, manufacturer_name,
model_number, serial_number, po_number, Type,
Status, Asset Type,Cost, deptn_amt, deprn_reserve,
COST - deprn_reserve, date_placed_in_service,
asset_key_ccid, location_id, fund, appr yr,
allottee, rpting ent, sgl, obj class, program,
project, wfo, local use, segment11, book_type_code,
org_id, ccid |
Required parameters: None
Optional parameters: Fund, allottee, reporting entity, object class, program,
project, wfo, Po Number(CID), Asset_type |
DECODE (faa.asset_type, 'CAPITALIZED', |
|
DOE GL Fixed Asset Balances CSV (Custom)
|
|
Report lists the AFF components, CID and
balances for a selected accounting period
for all FA SGL values (17* and 18*).
|
This report is used to facilitate analysis
of Fixed asset data.
|
Displays Appr Yr, Allottee, Report Entity,
SGL, Object Class, Program, Project, WFO,
Cid, Balance
|
|
Parameters : Fund, allottee, reporting
entity, object class, program, project, wfo,
CID, AFF
|
Only display SGL values of 17* and 18*
|
|
DOE PYA Transactions Report (CSV output)
|
| Provides Allottee
Reports Generated From PYA Pool Process |
The PYA Pool Process generates
the PYA Transactions Report in CSV output
Generate separate reports for each allottee from the PYA Transaction Report |
Display the following columns:
Period Name, Allottee, Document Number, Source Module, Fund Status,
Fund Class, Expended/Unexpended, Paid/Unpaid, Upward/Downward,
Offset Account, Transaction Code, Include Flag, Never Process Flag,
Amount, Prior PYA Amount Processed.
Depending on answer to Reporting Entity parameter report displays:
(1) Reporting Entity From and To Parameters not populated and
(2) Reporting Entity From and To Parameters populated |
Parameters:
- Allottee (required) From Thru To
- Reporting Entity From Thru To
|
The Prior PYA Amount Processed is obtained from the
sum of the amount from the fv_pya_transaction_history table based
on the source document number and never_processed_flag of ‘N’. |
| Fixed
Assets Depreciation (Custom) |
|
Lists depreciation information including
depreciation method, service life, acquisition
cost, current depreciation, year-to-date
depreciation, and accumulated depreciation
|
Use this report to identify depreciation
information for personal property assets
|
Lists Asset Number, Asset Serial Number,
Asset Description, Manufacturer, Location
Flexfield, Original Cost, Current year
(PTD Depr), Total Accumulated Depreciation,
Net Book Value
|
|
Book, Location Flexfield, AFF, Asset Key
|
|
|
Fixed Assets and General Ledger Comparison
Report (Custom)
|
|
Compares account balances in the GL with
associated FA Asset Category balances
|
Report provide a report comparing FA accounting
data to accounting data stored in the general
ledger not available in standard reporting
|
Displays SGL ACCOUNT, ASSET CATEGORY,
PRN-EQU, FIXED ASSET BALANCE, GL BALANCE
|
|
Selection parameters: SGL Account, Asset
category, Period Sort
by: SGL account, Asset category
|
|
|
Status of Fixed Assets (Custom)
|
|
Lists total acquisition cost, depreciated
to date, and calculated net book value
of assets
|
Use this report to provide information
required at times of disposition by sale,
disposal, or transfer of assets
|
Displays Asset Number, Asset Category,
Description, Cost, Depreciation, Net Book
Value
|
|
Select by: Book, Asset Category, Account
Flexfields, Date Sort
by: AFF, Asset Category, Asset Number
|
|
