Summary
The Financial Reporting Export provides a normalized “snapshot” of Colleague General Ledger data to facilitate reporting and analysis. The FRXE process provides export of general ledger activity from Colleague, which gets imported into Synoptix.
Body
Procedure
There are several automated scheduled jobs in the Process Handler within Colleague that support this data transfer.
| ESOB |
Estimated Opening Balances |
To establish opening balances to be used with Financial Statements. The process estimates the opening balances for the balance sheet accounts when the preceding fiscal year is open. |
Daily |
12:35 AM |
| FRXE |
CF Data Export |
To export Colleague general ledger files into the Synoptix financial data mart (FDM) table |
Daily |
1:00 AM |
| FRXR |
Data Mart Load History |
To produce a report that displays load history for a given Financial Data Mart date range
|
Daily |
5:00 AM |
Status
At 5:00 am daily a report is emailed with information regarding the latest data load. To confirm the successful completion of the process at any time, use the FRXL (FDM Load Status) screen in Colleague. At the "Data Mart LookUp" prompt enter "COLLIVE". A list of the successful loads will display showing the date and time.