您所在位置：网站首页 > 办公文档 > 解决方案YEAR END CLOSE - Department of Transportation.docx

YEAR END CLOSE - Department of Transportation.docx

2页

卖家[上传人]：新**

文档编号：509591289

上传时间：2023-04-25

文档格式：DOCX

文档大小：13.28KB

文档加载中……请稍候！
如果长时间未打开，您也可以点击刷新试试。

下载文档到电脑，查找使用更方便

10 金贝

/ 2 举报版权申诉马上下载

文本预览

下载提示

常见问题

1、YEAR END CLOSEPurpose:The Year End Close (YEC) process is performed to finalize the financial results of the fiscal year ending and to calculate the financial balances to be carried over to the next fiscal year.Procedure:FTAs Fiscal Year ends on September 3011 and the Team Web YEC process is performed in October. In order for the YEC process to run smoothly any data discrepancies in database arc researched, identified and corrected. To achieve the goal, several SQL queries are run by either DBA

2、or Help Desk lead to update the production database. The YEC process can be divided into four categories: Disconnect Financial Dialogs, Reconciliation, Rollover activities. Start Up Activities.Disconnect Financial Dialogs:Certain financial screens will be disabled in the Team Web interface and to do this, cripts are run to hide the appropriate menu links on the main page.This category includes the actions required to close all the financial activities for the previous Fiscal Year. This category

3、includes the following steps:1. Reset Reservation: A SQL script is run to zero out all the reservations in Operating_Budget table for the previous Fiscal Year.2. Clear Obligation: All the records in Obligation table are deleted for the previous Fiscal Year. Prior to doing that, a copy of Obligation table is saved as prior_yearvvyy_ Obligation, where yyyy is the year of the closing fiscal period.3. FPC (Financial Purpose Code) Transfers: All the available money has to be transferred to the projec

4、t before YEC or otherwise; all the undisbursed/unliquidated money associated with the projects has to be deobligated before starting YEC.4. Fund Substitution or Fund Adjustments has to be made on any project, which have been awarded, before starting the YEC.5. Clear all the projects with reservations and no obligations to $0. Zero out the un-obligatcd reservations in Amendnient_Funding table and remove the total and change all ready for award projects back to reservations required.6. Clear all h

5、olding pots for recoveries io $0. Clear Dc-obliga(ions for prior Fiscal Years at each Ycar-End- Close. Create table prior_year_deobligation as select * from deobligationg. Delete from deobligation where Fiscal Year the new fiscal year and aniount0. Then select distinct cost_ctr from session.operbud. Set operbud_sequence up for the new FY by inserting the FY and cost center values. Create another temp (able called scssion.opcrating_budgct_tcmp to update the opcrating_budgct table for carry over the pending balance into quarter 1 of current FY, by selecting value of ql_pending= (sum of FPC transfers in for prior FY - sum of FPC transfer out for prior FY + sum of recoveries for prior FY - sum of

《YEAR END CLOSE - Department of Transportation.docx》由会员新**分享，可在线阅读，更多相关《YEAR END CLOSE - Department of Transportation.docx》请在金锄头文库上搜索。

点击阅读更多内容

TA的资源