The Accounting tab has several fields that are not common fields found on all accounting transactions. Those common fields can be found in the Accounting topic in the Transactions User Guide. The transaction does display only a subset of the many common chart of account fields and of those displayed, many do not allow direct data entry.
Field Name |
Required/Optional |
Field Description |
Cash Amount |
Optional |
The amount of investment earning received is recorded in this amount and then used by the system in the creation of a posting line for Posting Pair A, which is a debit to cash and a credit to investment revenue as delivered. |
Accrued Interest Receivable Amount |
Optional |
The amount of accrued interest receivable to be reduced. The system will create a posting line for Posting Pair D with this amount, which is a debit to investment revenue and a credit to accrued interest receivable as delivered. Those accounts are being reduced after being recorded initially at the time the investment was purchased. |
Discount Amount |
Optional |
The amount of discount to be reduced. The system will create a posting line for Posting Pair B with this amount, which is a debit to investment discounts and a credit to investment revenue as delivered. Those accounts are being reduced after being recorded initially at the time the investment was purchased. Discount and Premium cannot be entered on the same accounting line. |
Premium Amount |
Optional |
The amount of premium to be reduced. The system will create a posting line for Posting Pair C with this amount, which is a debit to investment revenue and a credit to investment premium as delivered. Those accounts are being reduced after being recorded initially at the time the investment was purchased. Discount and Premium cannot be entered on the same accounting line. |
Investment ID |
Required |
This field is the common Description found on other accounting lines with a different label. On the IV transaction type, this description is always required and the Transaction Control (DCTRL) edit for a Required AL Description is not used. Through the constant entry of an investment ID that ties to a defined point in your investment tool(s), the accounting entries in CGI Advantage can be tied back to that tool as this field is written to the Accounting Journal. |
Collect Date |
Required |
The date on which investment earnings were collected. If left blank, the current application date will default to the accounting line. This date is recorded for informational purposes. |
From Date |
Required |
The start date for a period of investment earnings. When those earnings are allocated to the participants of the pool, this From Date defines the starting date for which each participant's average daily balance is calculated. For accrue interest, discount, or premium this date is the start of the amortization period. If left blank the current application date will default. |
To Date |
Required |
The end date for a period of investment earnings. When those earnings are allocated to the participants of the pool, this To Date defines the ending date for which each participant's average daily balance is calculated. For accrue interest, discount, or premium this date is the end of the amortization period. If left blank the current application date will default. |
Bank |
Required |
As investment earnings are always recorded with a cash account, the transaction completes the Bank account field with the Pool Fund's Pool Fund Bank Account from the Investment tab of the Special Fund Accounts (SPECFUND) page. |
This tab contains a limited number of editable fields for the specification of the pool. If the pool does not use a sub fund, then leave that Sub Fund field blank. There is no need to enter BLNK as with Treasury Accounting setup pages. Other COA may infer from various inference pages, with the Infer Department Unit and Special Fund Accounts being the two primary inference pages.