GL fiscal year Closing - FY20

Overview

This article demonstrates the steps in the fiscal year close

 

Audience

Internal to IT

 

Information

Opening Fiscal Year:

Separate procedure should be created for opening the next fiscal (currently done by Finance
without notification to IT)

When EX:. fiscal 2020 is opened  (some time/months AFTER fiscal 2018 is closed)

 

-schedule  job for ESOB needs to be (deleted if present and re-) scheduled with appropriate parameters (for 2 open periods eg. 2019 & 2020).

Delete and re-create the scheduled jobs for FRXE and FRXI
  (note that run-time parameters now need to include fiscal 2020 in addition to 2019)

Fiscal Year Close

Before closing

  - note the scheduled times and delete ESOB (if present), FRXE, and FRXI scheduled jobs (via PRSC).

 

 

Note before closing, FRXE shows 2018 & 2019 as “Open”

 

After closing FY 18

Scheduled jobs for FRXE & FRXI need to be re-scheduled with proper parameters (eg. just 2019 open)

- Run FRXE (manually – un-scheduled) -> which triggers FRXH – which copies the closed year to history

 

(and afterwards, the status column on FRXE displays Closed (prev. Open)

 

See next Step within details below –

      SQL command on Synoptix Database , to exclude "YE"  Closing Entry transactions from the datamart

     (NOTE THAT ELLUCIAN DID DO THIS STEP WHEN ASSISTING TO CLOSE 2018)

     (not sure if it matters when this is done relative to running FRXE > FRXH manually)

 

1.   Log in to both UI and Command Prompt (Call the finance department to confirm they’re logged in)

  

2.   Log in to Shelby

 

 

3.   Stop Listeners ( 1: production_svr02 2) production APP_listner) Start in reverse order

4.   To search USERS who are currently logged in to Colleague UI: LISTUSER

 

5.   Search specific USERS who are currently logged in to Colleague UI: !LISTUSER  | FINDSTR /I USERNAME

6.   Force who is logged in off Colleague UI:  !DELETEUSER (ENTER THEIR IPHANTAM #)

7.   Take Snapshot of the database

8.   Call Josue to give him the OK to Proceed

9.   Have Josue call back when he is done with the Fiscal Year close

10.  Turn listeners back on

11.  Test UI and Spirit

12.  In Spirit Online, search for sections for any term to confirm Spirit is running correctly

 

 

Details

Article ID: 128422
Created
Mon 2/22/21 10:51 AM
Modified
Wed 9/22/21 2:38 PM