Monthly Installments - Revision history

WikiSysop: /* CrossRoad Process */

2014-09-19T04:27:51Z

‎CrossRoad Process

2014-09-19T04:27:03Z

‎Import into CrossRoad

2014-09-18T17:07:01Z

‎Import into AccPac

2014-09-17T17:13:02Z

2014-09-17T16:52:12Z

2012-10-05T16:59:50Z

‎Import into CrossRoad

2012-10-05T16:15:41Z

‎Import into CrossRoad

2012-10-05T15:58:13Z

‎Approved Payments

2012-10-05T15:57:56Z

‎Import into AccPac

2012-10-05T15:37:05Z

‎Approved Payments

@@ Line 248: / Line 248: @@
 ===== CrossRoad Process =====
-In the Current Student window, choose the following menu sequence Import Installments Received. This will ask the operator to specify the file to import, and the year and term.
+In the Current Student window, choose the following menu sequence Students > Global Processes > Accounts Receivable > Installments > Import Installments Received. This will ask the operator to specify the file to import, and the year and term.
 The process will then attempt to record each line of the CSV. Records that cannot be applied are recorded in a file in the same location as the original with "-Errors.txt" appended. This file, if created, is automatically opened at the end of the process. The records in this file should be assessed and manually updated.

@@ Line 244: / Line 244: @@
 ==== Import into CrossRoad ====
-The morning of the day on which the Accpac exported balances will include the Rotessa payments, the import should be run. Using the saved CSV file exported above, use the rotimp.exe utility.
+The morning of the day on which the Accpac exported balances will include the Rotessa payments, the import should be run.
      rotimp 2012/13 1 export.csv

@@ Line 232: / Line 232: @@
 Copy the exported workbook to the last page of the Rotessa import workbook. Check that the data all transfers to the Data Entry tab. Check the date on that tab. Check that sufficient rows of the formulas are copied down on the first page of that workbook. Save this and close it.
-==== Import into AccPac ====
+==== Import into Sage ====
 Create a new Receipt batch. Choose File | Import. Make the file type Excel 2000 and then use the Browse button to open the Rotessa Import workbook. Click OK.

@@ Line 3: / Line 3: @@
 = Overview =
-This process is depicted in this swim lane chart. Note that a number of the processes include substeps detailed below.
+This process is depicted in this swim lane chart. [[Image:Installments.png|thumb]] Note that a number of the processes include substeps detailed below.
 = Enrolment =
@@ Line 45: / Line 45: @@
 == Exporting to CSV ==
-There are two sets of tools for this process
+Note that this documents both current and former process as we are in transition between the two.
-=== CrossRoad Global process ==
+=== CrossRoad Global process ===
 Rotessac.exe is the utility to create a csv file for importing into Rotessa. This file generates output that needs to be piped into a file to save the data.
@@ Line 97: / Line 112: @@
 Open instleml.tsv (or wherever you redirected the output) in Excel. It is tab delimited. Save that as a workbook such as U:\CrossRoad\DBF.MM\instleml.xlsx.
-Then use and edit the merge print template, L:\Installment Initial Email.docx
+Then use and edit the merge print template, Installment Initial Email.docx
 Merge this to Email messages.
@@ Line 104: / Line 119: @@
 == Exporting from CrossRoad ==
 The utility rotessap.exe is used for this. This will export any future dated payments for clients who have been exported. There are no parameters, but output needs to be redirected.

@@ Line 1: / Line 1: @@
 Monthly installments are integrated into both web services and the desktop client. There are several stages to this process. This is designed around exporting data to Rotessa.
 = Enrolment =
@@ Line 40: / Line 44: @@
 == Exporting to CSV ==
 Rotessac.exe is the utility to create a csv file for importing into Rotessa. This file generates output that needs to be piped into a file to save the data.

← Older revision		Revision as of 16:59, 5 October 2012
Line 210:		Line 210:

	The morning of the day on which the Accpac exported balances will include the Rotessa payments, the import should be run. Using the saved CSV file exported above, use the rotimp.exe utility.		The morning of the day on which the Accpac exported balances will include the Rotessa payments, the import should be run. Using the saved CSV file exported above, use the rotimp.exe utility.
		+
		+	rotimp 2012/13 1 export.csv
		+
		+	The output will display each record. If a matching CrossRoad record cannot be found, or the payment has already been applied, this will be noted.
		+
		+	Payments that were resubmitted due to incorrect bank information or NSF will not apply through this system and need to be done manually.

← Older revision		Revision as of 16:15, 5 October 2012
Line 208:		Line 208:

	==== Import into CrossRoad ====		==== Import into CrossRoad ====
		+
		+	The morning of the day on which the Accpac exported balances will include the Rotessa payments, the import should be run. Using the saved CSV file exported above, use the rotimp.exe utility.

@@ Line 196: / Line 196: @@
 Copy the exported workbook to the last page of the Rotessa import workbook. Check that the data all transfers to the Data Entry tab. Check the date on that tab. Check that sufficient rows of the formulas are copied down on the first page of that workbook. Save this and close it.
 ==== Import into AccPac ====
@@ Line 210: / Line 206: @@
 The batch should be posted according to normal Financial Services practices.

← Older revision		Revision as of 15:57, 5 October 2012
Line 202:		Line 202:

	==== Import into AccPac ====		==== Import into AccPac ====
		+
		+	Create a new Receipt batch. Choose File \| Import. Make the file type Excel 2000 and then use the Browse button to open the Rotessa Import workbook. Click OK.
		+
		+	Note that at the moment this gives a Bank Code mismatch error that has not been resolved. Depending on the error you may need to use Cancel to exit this window.
		+
		+	The number of records and dollar value should be matched against the Rotessa report. Then each student's payment should be applied.
		+
		+	The batch should be posted according to normal Financial Services practices.

@@ Line 186: / Line 186: @@
 === Approved Payments ===
 ==== Export Report ====
 ==== Import into Excel ====
 ==== Import into CrossRoad ====
 ==== Import into AccPac ====