9.2 Daily SF Fund Balancing to the GL
Purpose: Use this document as a reference to the automated job process in ctcLink which stages financial transactions from SF, fund balances those entries, and then delivers that data to Finance.
Audience: Bursar, Student Financials staff, Accounting staff.
You must have at least one of these local college managed security roles:
- ZD_DS_QUERY_VIEWER
If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.
This automated job consists of running several processes and is managed by the SBCTC.
Daily SF Fund Balancing to the GL
Job # C9990006 (E-215)
- This job takes the non-student related transactions, sums those transactions by accounting line (called fund balancing,) and then batch publishes the data to the finance pillar. The job process runs nightly at 10:00pm.
Use the below queries to confirm each step has been processed.
For the cashiering entries, use:
QCS_SF_E215_ACCTG_LN
QCS_SF_E215_ACCTG_LN_JGEN
QCS_SF_E215_FUND_BAL
Job #C9990007 (E-214)
- This job takes the student related transactions, sums those transactions by accounting line (called fund balancing,) and then batch publishes the data to the finance pillar. The job process runs Monday - Friday at 10:30pm.
Use the below queries to confirm each step has been processed.
For the accounting entries, use:
QCS_SF_E214_ACCTG_LN
QCS_SF_E214_ACCTG_LN_JGEN
QCS_SF_E214_FUND_BAL
What happens if Fund Balancing (E215 & E214) fails? If a journal has been created, delete it and allow it to be recreated via the following nightly job run.
- Process complete.
0 Comments
Add your comment