ST403MO – GENERAL SETTLEMENT PHASE 4

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, ST403MO. 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 ST403MO.LIS to create the file in text format. 7. Beginning Date: Enter the Business Date to query phase 3 in STLGROUP. 8. Ending Date: Enter the Business Date to load phase 3 to 4 in STLGROUP. 9. ID1: Enter the Data file name to load the surcharge dist. Use full path name. 10. ID2: Enter the Control file name used to load ID1 data file into STLGROUP. Use full path name. 11. ALT1: Enter the Data file name to load Mis/ped/rail road dist. Use full path name. 12. ALT2: Enter the Control file name used to load ALT1 data file into STLGROUP. Use full path name. 13. FCU: Formatting code. Keep the default printer setting that is present when the screen appears. 17. PARAM1 ROLLTYPE: Enter a valid rolltype. Leave blank to report on all rolltypes. 18. PARAM2 FREQ: Enter the frequency (D, M, Y) (Daily, Monthly, Yearly) TO QUERY THE SETTLEMENT SETTLE TABLES. 19. PARAM3 BANK INTEREST: Enter the amount earned. 20. PARAM4 COMM PCT: Enter comm. Percent. Default is 1%. 21. PARAM5 ASMT FEE PCT: Enter the Asmt Fee percent. Default is .5%.

Figure 2. SY 41 (BOTTOM)

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

EXCEL-TO-ASCII SETUPS

The following are sample steps to convert the EXCEL file to ASCII file before running ST403MO.

Open the sur charge distribution excel

Click on the record macro

Click on OK.

Click on Stop Recording

Click on macro it opens the following window

Click on the edit button.

This macro is for surcharge distribution file.

Remove the existing code and copy this code to the macro by changing the “NOV03SUR.PRN” name to new name.

Sub St403mosur_macro()

Columns("A:A").ColumnWidth = 4

Columns("B:B").ColumnWidth = 40

Columns("C:C").ColumnWidth = 6

Columns("D:G").Select

Selection.ColumnWidth = 13

Selection.NumberFormat = "0.00"

ChDir "S:\ACH"

ActiveWorkbook.SaveAs Filename:="S:\ACH\NOV03SUR.PRN", _

FileFormat:=xlTextPrinter, CreateBackup:=False

ActiveWorkbook.Close

End Sub

This macro is for misc. fees, pool, etc. distribution file.

Sub St430momis_macro()

Columns("A:A").HorizontalAlignment = xlLeft

Columns("A:A").ColumnWidth = 6

Columns("B:H").Select

With Selection

.HorizontalAlignment = xlRight

End With

Columns("B:H").Select

Selection.HorizontalAlignment = xlRight

Selection.ColumnWidth = 13

Selection.NumberFormat = "0.00"

ChDir "S:\ACH"

ActiveWorkbook.SaveAs Filename:="S:\ACH\DEC30MIS.PRN", _

FileFormat:=xlTextPrinter, CreateBackup:=False

ActiveWorkbook.Close

End Sub

Then close this window by using file -> close and return to EXCEL.

Click on macro button.

Click on the run button.

Click Yes

The file was created in that folder with this name:

The same process will be repeated for misc. fees like pool and peddler by using misc. fee macro.

Once both files are in the S:\ach folder, run the ST403MO to load these files into STLGROUP.

Updated 7/25/2006