Advance Leave Encashment

This option is for leave encashment for advance leaves.

There are two scenarios here:

1. If payment type is selected as continuous in leave encashment screen, then the leave encashment salary will be credited through the payroll.

2. If payment type is selected as advance in leave encashment screen, then the leave encashment salary will not be credited through payroll but in the print layout, encash amount can be viewed.

Settings>>Customization>>Leaves>>Leave Encashment>>Print layout

Note: Employee Account and Salary Account should be mapped in the Employee master

Follow the below steps for FA posting:

1. Create two account master fields in leave encashment screen as shown in the below screen.

In the above two screens, two accounts are created. One is Company account in the first screen and Emp account in the second screen.

Employee account is created to credit the encash amount and add these two fields in page layout of leave encashment.

2. Run below stored procedure in the database.

Before running the script, replace the below highlighted field names with the created account field names in leave encashment screen.

<KeyValuePair> <Key>LeaveCompanyAccount</Key> <Value>' + @SalAccount + '</Value> </KeyValuePair>

<KeyValuePair> <Key>LeaveEmployeeAccount</Key> <Value>' +@EmpAccount+'</Value> </KeyValuePair>

Script:

Create PROC pPay_LoadAccounts @xmlIn AS XML

,@xmlOut AS XML OUT

AS

BEGIN

DECLARE @EmployeeID AS INT

DeCLARE @EmpAccount AS VARCHAR(1500)

DeCLARE @SalAccount AS VARCHAR(1500)

SELECT TOP 1 @EmployeeID = xmlData.data.value('Value[1]', 'varchar(max)')

FROM @xmlIn.nodes('/ArrayOfKeyValuePair/KeyValuePair') AS xmlData(data)

WHERE xmlData.data.value('Key[1]', 'varchar(max)') LIKE 'iEmpId'

SET @xmlOut = convert(XML, N'<ArrayOfKeyValuePair></ArrayOfKeyValuePair>')

SELECT top 1 @EmpAccount=m.iEmployeeAccountName+'|'+convert(varchar(100),m.iEmployeeAccount) ,@SalAccount=m.iSalaryAccountName+ '|'+ convert(varchar(100),m.iSalaryAccount)

FROM vaPay_Employee m

WHERE m.iMasterId=@EmployeeID

SET @xmlOut = convert(XML, N'<ArrayOfKeyValuePair></ArrayOfKeyValuePair>')

DECLARE @newFeatures XML;

SET @newFeatures = N'

<KeyValuePair> <Key>LeaveCompanyAccount</Key> <Value>' + @SalAccount + '</Value> </KeyValuePair>

<KeyValuePair> <Key>LeaveEmployeeAccount</Key> <Value>' +@EmpAccount+'</Value> </KeyValuePair>

';

SET @xmlOut.modify('

insert sql:variable("@newFeatures")

into (/ArrayOfKeyValuePair)[1] ')

END

3. After executing the script, write the rule for the employee field. Edit the Employee account from the customization screen.

As mentioned in the screen, Apply on Load, on leave, No condition to be checked. In the properties grid, Emp account field to be selected against which the stored procedure details to be entered as mentioned in the above screen.

Note:

· Emp Account is the created account field of leave encashment screen.

· 4. Create work flow for posting FA of leave encashment automatically.

Settings>>Approval>>Work flow

Select evaluate on field according to the authorization flow defined.

Approve – if authorization is defined.

Create – If no authorization is available.

If authorization flow is defined, Approve option to be selected. If no authorization is available, create option to be selected.

Define the work flow with filter for payment type is equal to advance type. Refer work flow screen.

5. Go to the next tab (Actions)and select create module.

6. Select destination module as FA posting, on selection of FA posting, voucher field will be loaded. Select Credit Notes (Linewise)/Payroll from the drop down box.

7. Once the voucher is selected a grid with source fields and destination fields will be loaded.

Select source fields and destination fields as below for credit and debit accounts.

8. Whenever the employee applies for leave encashment, automatically company account and employee accounts will be loaded in the screen.

Employee will enter the required leaves for encashment and save the screen.

9. On saving the leave encashment screen, and selecting payment type as Advance, system will automatically post the FA based on the work flow defined.

Refer below screen where company account and employee salary account is loaded against credit and debit accounts respectively.