Differences

spay:procguide:salincr_import [2022/01/15 15:10] mclement		spay:procguide:salincr_import [2022/01/15 18:00] (current) mclement
Line 1:		Line 1:
	====== Salary Increase Excel Import ======		====== Salary Increase Excel Import ======
-	Salary increase amount can also be imported through the Employee Transactions using an Excel file as shown below.	+	Salary increase amount can also be imported through the Employee Transactions using an Excel file as shown below. Contact our Support Team for assistance for the import configuration.
-	===== Government Salary Increase Excel Import=====	+	===== Salary Increase Excel Import=====
-	{{:spay:procguide:spay_sal_inc_excel_import2.png|}}	+	{{:spay:procguide:spaysalincexceltemplate1.png|}}
-	If you are importing from Excel for the first time, you must contact our Support Team for assistance concerning the import configuration.	+	**  * Step 1:** Fill in an Excel file in the above format
-		+
-	If the import configuration exists, make sure the Excel file name, the sheet name and the column names are as per the import definition	+
-	To import the Government Salary Increase Excel file, follow the steps below:	+	**  * Step 2:** Save the file
		+
		+	To import the Salary Increase Excel file, follow the steps below:
	**  * NB: The file should be saved in Excel 97-2003 (.xls) format**.		**  * NB: The file should be saved in Excel 97-2003 (.xls) format**.
Line 21:		Line 21:
	**  * Step 2:** Click Import icon		**  * Step 2:** Click Import icon
-	{{:spay:procguide:spay_sal_inc_import1.png|}}	+	{{:spay:procguide:spayimportexceltemplate.png|}}
-	**  * Step 3:** Double-click the Government Salary Increase Import from the list	+	**  * Step 3:** Double-click the Import from the list
-	**  * Step 4:** Browse the Government Salary Increase Excel file	+	**  * Step 4:** Browse the Salary Increase Excel file
	**  * Step 5:** Click import button from the toolbar		**  * Step 5:** Click import button from the toolbar
-	{{:spay:procguide:spay_govinc_emp_trans_menu_criteria_2020.png|}}	+	{{:spay:procguide:spaysalincemptransimport.png|}}
-	{{:spay:procguide:spay_sal_inc_emp_trans.png|}}	+	**  * Step 6:** Go to Employee Transaction
-	**  * Step 6:** verify the number of records and the total amount imported through the Employee Transactions	+	**  * Step 7:** Choose or Insert criteria for PDcode 120
-	===== Company Salary Increase Excel Import=====	+	**  * Step 8:** Click Apply
-		+
-	If company increase is to be differentiated from government increase, you must use a different payment code e.g 121 (other than code 120). You must contact our Support Team for assistance concerning the import configuration of the company increase. Otherwise, payment code 120 can cater for the sum of government and company increase.	+
-		+
-	To import the Company Salary Increase Excel file, follow the steps below:	+
-		+
-	**  * NB: The file should be saved in Excel 97-2003 (.xls) format**.	+
-		+
-	**  * Repeat Steps 1 & 2 of the Government Salary Increase Excel Import:**	+
-		+
-	{{:spay:procguide:spay_comp_inc_import.png|}}	+
-		+
-	**  * Step 3:** Double-click the Company Salary Increase Import from the list	+
-		+
-	**  * Step 4:** Browse the Company Salary Increase Excel file	+
-		+
-	**  * Step 5:** Click import button from the toolbar	+
-	{{:spay:procguide:spay_compinc_emp_trans_menu_criteria_2020.png|}}	+	{{:spay:procguide:spayemptranssalinc.png|}}
-	{{:spay:procguide:spay_comp_inc_emp_trans.png|}}
-	**  * Step 6:** verify the number of records and the total amount imported through the Employee Transactions