AC401 – fiscal year ROLLOVER

The AC401 creates beginning balances for all accounts and creates records for a future fiscal year. The following is performed:

 

·        GL_ACCOUNTS_HDR records are created for the new fiscal year.

·        GL_ACCOUNT active records are created for the new fiscal year.

·        GL_ACCTMAPPING records are created for the new fiscal year.

·        GL_ACTIVEPOSTDATE record is created for the new fiscal year.

·        GL_AUTH records are created for the new fiscal year.

·        GL_FISCALYR record is created for the new fiscal year with a status of ‘A’ for active and the current fiscal year status is changed to ‘null’.

 

 

 

 

 

·        GL_JOURNAL is created for the new fiscal year based on the net debit, credit balances for each account.

·        GL_QUERY is created for the new fiscal year.

·        GL_PRIMARYKEYS , tables ‘CHECKNO’, ‘GL_ACCOUNTS’ and ’GL_JOURNAL’ records are created for the new fiscal year.

·        GL_PRIMARYKEYS, table ‘GL_DISBURSE_HDR’, fld ‘DISBURSEID’ record is created for the new fiscal year and fld ‘DISBURSENO’ record is created with the value reset to ‘1’

 

NOTE: The specific fields with permissible entries to be filled in or left blank are listed below. Ignore fields that are not in the list next to the screens.

 

 

Figure 1. SY41 (TOP)

 1.    Job: Report name should always appear here. For example, AC401.

 2.    Server Name: Keep the server name that first appears.

 3.    Printer_Name: Select a valid printer or keep the displayed printer if one is present.

 4.    Jurisdiction: Enter your jurisdiction.

 5.    Tax Year: Enter the current Tax Year.

 6.    Spool File Name: Enter AC401.LIS to create the file in text format.

 7.    Beginning Date: Enter beginning date of new fiscal year.

 8.    Ending Date: Enter ending date.

 

 

 

 13. FCU: Formatting code. Keep the default printer setting that is present when the screen appears. If blank, enter HPLP132.

 17. PARAM1 New Fiscal Year:

          Enter the new Fiscal year.

 18. PARAM2 Post Date-MM/DD/YYYY:

          Enter the posting date for all journal entries for the new fiscal year.

 

 

Figure 2. SY 41 (BOTTOM)

Press [Submit Job]. The system will notify you when the report is finished.

 

REPORT SAMPLE

 

This image shows the listing for the AC401 Report.

 

Updated 7/21/2006