tx405 - End of Year Tax Setup Rollover Program

The End of Year Tax Setup Rollover Program (TX405) prepares the tax collection and billing system for the next year of tax collection by reading through each annualized tax setup table and transferring information to the next year of tax collection indicated by the parameter.

If no value is entered in “Add No Months”, any dates entered in the FEEDEF,SAFEEDEF, TECYCLE, and INTSCHED tables, such as a delinquency or due date, must be updated manually by the user within IAS after the roll process to reflect the new delinquency or due date. If the value is entered in “Add No. Months”, the date will be the number of months plus the old delinquency or due date. Any date entered in the FEEDEF table (such as a delinquency date) will be automatically updated within IAS in the rollover process.

If Check Holidays = “Y”, then the tax set-up dates will skip weekends and holidays. The system automatically puts the new date at the next business date.

The program specifically copies setup records forward from the current year to the new record as a base for the new year.

The rates stored in the rate tables must be updated physically within IAS after the roll process to reflect the proper rates for the new year. The program specifically copies setup records forward from the current year to the new record as a base for the new year.

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 TX405. 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 rollover tax year (New tax year). 6. Spool File Name: TX405.LIS to create the file in text format. 13. FCU: Formatting code. Enter “PDF” to print in PDF format. Otherwise keep the default printer setting that is present when the screen appears. 17. PARAM1 ROLL TYPE: The roll type to roll up or ‘ALL’ to roll all roll types. 18. PARAM2 BILL/COLL/RATE/ALL: Enter 'BILL' to roll tax billing setup tables: TESYS, TECYCLE, CYCLGRP, FEEDEF, TAXDEF, AND TAXDEFADD. Enter ‘COLL’ to roll tax collection set of tables: TCSYS, PYDIST, PYYEAR, PYMTCOND, INTSCHED, and ALTSCHED. Enter ‘RATE’ to roll rate tables: RTDIST, RTDTOC, RTCYCL, RTAUTH, RTRATE, RTMILL, RTRED. Enter ‘SETL’ to roll settlement set up tables: STLDIST, STLFLAG, STLMOD, STLSCHED. Enter ‘'INTSCHED' to roll interest schedule table (INTSCHED). Enter 'ALTSCHED' to roll alternate schedule table (ALTSCHED ). Enter ‘ALL’ to roll all the above tables from the current tax year to the next tax year (default is ‘ALL’). 19. PARAM3 BILL/COLL/RATE/ALL/N: If future data is present you want to delete, enter a delete flag from the following tables: Enter 'BILL' to delete future year data from tax billing setup tables: (TESYS, TECYCLE, CYCLGRP, FEEDEF, TAXDEF, AND TAXDEFADD). Enter 'COLL' to delete future year data from following setup tables: TCSYS, PYDIST, PYYEAR, and PYMTCOND. Enter ‘RATE’ to delete future year data from the following tables: RTDIST, RTDTOC, RTCYCL, RTAUTH, RTRATE, RTMILL, RTRED. Enter ‘SETL’ to delete future year data from the following tables: STLDIST, STLFLAG, STLMOD, STLSCHED. Enter ‘'INTSCHED' to delete future year data from the interest schedule table (INTSCHED). Enter 'ALTSCHED' to delete future year data from the alternate schedule table (ALTSCHED ). Enter 'ALL' to delete all future year records from all tables mentioned previously. Default is “ALL”. 20. PARAM4 ADD NO MONTHS: Adds entered number of months to the tax set-up dates. 21. PARAM5 CHECK HOLIDAYS (Y/N): Enter “Y” to skip weekends and holidays for tax set-up dates. (Dates in FEEDEF, SAFEEDEF, TECYCLE, and INTSCHED tables)

Figure 2. SY 41 (BOTTOM)

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

Report Sample

Figure 3. User can check FEEDEF listing for previous and new year dates.

Figure 4. User can check INTSCHED listing for previous and new year dates.

Figure 5. User can check TECYCLE listing for previous and new year dates.

Updated 6/12/2008