ERPro User Portal

1day since
Next Release 6.11

How to import Leave Adjustment from Excel File?

1. Prepare an Excel Spreadsheet with the following format with exact column order. (Download sample from attachment)
 
 
WHERE
[EE_NO] - Employee No.
[ADJ_DATE] - Adjustment Date
[DAYS] - positive for leave increment, negative for leave deduction
[NATURE] -  A for Annual Leave Adjustment, C for Compensation Leave Adjustment
[REMARKS] - maximum number of characters is 60
 
2. Save the worksheet as Excel File
 
3. In HRPro, go to Leave Management -> Leave Adjustment, open any Leave Adjustment Record. Click the Import Button and locate the file you save in step 2.
 
 
4. The Leave Adjustment Records are imported.
 
 
Enhanced in HRPro 5.7
 
 

Attachments (1)

  • LeaveAdjustments.xlsx - on Nov 19, 2008 8:19 PM by Jansen Lam (version 1)
    9k Download