Investment Activity Report (GLR083)
-
Print
-
DarkLight
-
PDF
Investment Activity Report (GLR083)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
This report was implemented in CMS Wave and will be updated in Financials Wave. The information in this article is the planned design for Financials Wave.
Investment Activity Report can be generated on demand to show Month-to-date (MTD) Beginning balance, Additions (Interest earned, amount debited to Revenue Accounts and Investment Accounts,), Deductions (Admin fees, amount credited from Expense Accounts and Disinvestment Accounts) and Net balance for all the applicable accounts for the provided Business Unit, Fundrange, Fiscal Year, and Accounting Period range.
- SPIA balances are entered into Florida PALM as a part of Investment activity interface. GL Journals will be created and posted to the ACTUALS ledger for the same.
- The report will show the Balances which will include additions/ investments and deductions/disinvestments for the provided selection criteria on a run control page.
- Attribute value will be derived from Attribute - POOL TYPE for the selected Fund values.
This report is used to monitor Trust Fund investment balances and activity. Agencies use this report to reconcile Trust Fund investment activity and balances.
Report Navigation: NavBar > Navigator > Florida PALM > Reports > GL > Investment Activity Report
Query Name: FLP_INVESTMENT_ACTIVITY_REPORT
See the sample layout report below.
Business Roles
The following business roles have access to this report:
Business Process Models
This report can be found in the following business processes:
Selection Criteria
The report data can be filtered by the following selection criteria:
Data Field | Data Field Details |
|---|---|
Business Unit | Required |
Pool Type | Optional |
Fund From | Required |
Fund To | Required |
Fiscal Year | Required |
Accounting Period From | Required |
Accounting Period To | Required |
Report Layout
The layout of the report is listed below.
Report Detail Section 1 - Investment Activity Report
Data Field | Florida PALM RECORD.FIELD mapping |
|---|---|
Beginning Balance | Opening MTD balance calculation |
Transaction Date | PS_JRNL_HEADER.JOURNAL_DT |
Transaction Type | PS_TRX_HEADER_TR.TRADE_TYPE |
Account | PS_JRNL_LN.ACCOUNT |
Account Description | PS_GL_ACCOUNT_TBL.DESCR |
Additions | Sum (PS_JRNL_LN. MONETARY_AMOUNT) |
Deductions | Sum (PS_JRNL_LN. MONETARY_AMOUNT) |
Balance | The sum of the net value of each day's transactions for the GL account and fund + Beginning balance |
Report Detail Section 2 - Account Summary
Data Field | Florida PALM RECORD.FIELD mapping |
|---|---|
Transaction Types | List Transaction Types from Detailed Section 1 above |
Addition Transaction Types | Count The number of Transaction types for Addition types Listed in Detailed Section 1 above |
Deduction Transaction | Count The number of Transaction types for Deduction types Listed in Detailed Section 1 above |
Addition Subtotals | Sum all in Addition Column listed in Detailed Section 1 above |
Deduction Subtotals | Sum all in Deduction Column listed in Detailed Section 1 above ) |
Net Amount | Formula of Additions less Deductions |
Total | Formula to sum all items specified in Detailed Section 2 |
Version History
Date | Revision Description |
|---|---|
10/25/2023 | Original Version |
Was this article helpful?
