Company: Link Technologies
Case No: L08414. Project: 08.20: LinkSOFT Version 8.2
Logged By: Vineshwar Prasad (Edge Business Solutions) on 15 Mar 2017 01:58PM
Priority: High
Product: Payroll & HR
Group: Change Request
Time Taken: 18.00 (Weight: 18.00)
Version: 8.290.0115
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, AwaitingApproval, Rashna, Vineshwar Prasad
Resolve By: Friday, 31 March 2017 12:00 AM [2571 days since logged date]
Status: Closed
Subject: Enhancement to Pay Category Cash to display in Payslip and GL integration Alteration.
Summary:    
Bula Vinaka Team,

Recently we have setup Payroll for Navini Island Resort. Since there are no ATM on that island, one of the requirement for this project was that employees will be paid part cash and part direct credit. The way we have setup is:

  • Payment Scheme as Direct.
  • Bank defined in Direct Credit for employee with an amount eg: E001 as $100
  • If employees net pay is $250, Direct shows $100 and $150 in the coinage report indicating Cash.
Now with this method, we have come across 2 issues:
  1. Amount of Cash paid is not indicated in the Payslip.
  2. The coinage report shows 1 cents and 2 cents as rounding is not being catered with the above setup.
Since this is the standard requirement for most island resort, we request if this can be facilitated in our Payroll.

The below needs to be considered for this change:

  1. Introduce Cash as a pay code
  2. Facilitate rounding in the pay verification to cater for this issue highlighted above.
  3. Review GL integration after this change.


Audit Notes:
20 Mar 201704:03PM Comment 1 by Alvis (Link Technologies) Case 8414 added to project 8.10.001
21 Mar 201703:59PM Comment 2 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 21-03-2017 03:59 PM Time Taken: 4.00
Development work for this case has been completed.


The change will be available in version: 8.10.001
Documentation update required(Yes/No. Add change details below):  Yes
QA required(Yes/No.Include areas that require testing): Yes

The following changes were made(Include Database object names, Program classes and any other relevant information):

  1. Created two new pay codes "CASH' and "CHEQUE"
  2. Changed pay calculations to add CASH/CHEQUE pay codes to current pay
  3. Added rounding for employee's that have split cash and banking amounts
  4. Changed the following reports to allow for this change:
    1. Pay slip A4, A5, A6, Consolidated
    2. Pay summary report
    3. Pay coinage report
    4. pay audit report
  5. Changed GL integration journal entries to handle this change
  6. Changed the following customer customizations:
    1. Sonaisali - recalculate pay
    2. FNPF - GL integration
    3. FICAC - GL integration

Documentation details:
  

29 Mar 201710:34AM Comment 3 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 29-03-2017 10:34 AM Time Taken: 1.00
Hi Team,

The case has been tested successfully.

1. Was this test completed using Demo / New / Other database? Demo
2. Did the test pass or fail? Pass
3. Tab order, spelling, alignment, font size consistency, screen size etc checked? Yes
4. Data verified, saved, edit, delete/void? Yes
5. Documentation update required? No
Additional Details (Risks, issues, special conditions required for this test to pass etc): 

Test Plan

326 - Direct Credit
Bank Details
Set Employee Bank
Pass
 
 
Test Employee with Bank Pay Code as Bank
Pass
 
 
Test Employee with Bank Pay Code as Bank with Amount
Pass
 
 
Test Employee with Bank Pay Code as Cash
Pass
 
 
Test Employee with Bank Pay Code as Cash with Amount
Pass
321 Employee Setup
Payment
Test with Pay Scheme - Direct
Pass
 
 
Test with Pay Scheme - Cash
Pass
332-3 Pay Edit
 
Should open up in less than 1 mintue
Pass
 
 
Bank Pay Code apperas with Amount
Pass
 
 
Cash Pay Code appears with Amount
Pass
 
 
Test Rounding Adjustment with Pay Scheme as Direct
Pass
 
 
Test Rounding Adjustment with Pay Scheme as Cash
Pass
Reports
 
Payslip - A4 , A5 , A6 , Consolidated
Pass
 
 
Pay Summary Report
Pass
 
 
Pay Coinage Report
Pass
 
 
Pay Audit Report
Pass
 
 
Pay Edit Report
Pass
 
 
Pay Banking Report
Pass
 
 
Employee Direct Credit Audit
Pass
 
 
GL Integration Report
Pass

Note :
1. Pay Code as CHEQUE has not been tested
2. Customer customization has not been tested

Regards
Vinesh



18 Apr 201710:17PM Comment 4 by Vineet (Link Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 19-04-2017 12:00 AM Time Taken: 3.00

Bula Alvis

The below setup was done on:

  • QA4
  • CLIENT-Sonaisali-Linksoft DB
  1. Setup Employee 1065 Pay Scheme as Direct with one Bank account.
  2. Setup Employee 1132 Pay Scheme as Cash.
  3. Setup Employee 1139 Pay Scheme as Direct and Bank details as:
    • Bank BSP and amount as $0
    • Cash with amount of $100. So $100 will be given in as Cash and remaining will be banked.
  4. Setup employee 1154 Pay Scheme as Cheque.
  5. Setup employee 1183 Pay Scheme as Chequewith Direct Credit Details as Below:
    • Cheque amount $100
    • Cash amount $ 0. Meaning $100 Cheque and remaining Cash.
  6. Setup employee 1195 Pay Scheme as Direct with Direct Credit Details as Below:
    • Cheque : $50.02
    • Bank $50
    • Cash $0
  7. Created Pay for these employees and verified the below:
  1. Rounding on Pay Edit Screen (Issue)
  2. Verification of Pay Audit Report (Ok)
  3. Verification of Pay Banking Report (Ok)
  4. Verification of Pay Coinage Report (Ok)
  5. Verification of Pay Signature Report (Issue)
  6. Verification of Pay Summary Report. (Issue)
  7. Pay slip A4, A5, A6, Consolidated
Figure 1.1 Below shows the expected and Systems Result:


Issues:

  1. For Employee 1183, All amounts was shown in Cheque even though setup was done as part cheque, part Cash. It seems like system only splits payment when Pay Scheme is Direct and not for any other method. Figure 1.1 above shows the system result for employee 1183 having Pay Scheme as Cheque.
  2. For employee 1139. after creating the pay, if pay scheme was changed from Direct to Cash and Pay verified, then Pay Scheme changed back to Direct from Cash and Pay Verified, then rounding is impacted. The Bank totals should be $58.98 but soon after altering the pay scheme, it is changed to $59.00
  3. Pay Signature report does not have the names of employee 1139 and 1195 becauase their Pay scheme are Direct. Their names should be in the Report as they were paid partial Cash and Part Banking
Best Regards
Vineet Ram




19 Apr 201710:07AM Comment 5 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 19-04-2017 10:07 AM Time Taken: 2.00

Refer to comments in red below

  1. For Employee 1183, All amounts was shown in Cheque even though setup was done as part cheque, part Cash. It seems like system only splits payment when Pay Scheme is Direct and not for any other method. Figure 1.1 above shows the system result for employee 1183 having Pay Scheme as Cheque. Change the pay scheme to Direct when using Direct Bank Credit setup.
  2. For employee 1139. after creating the pay, if pay scheme was changed from Direct to Cash and Pay verified, then Pay Scheme changed back to Direct from Cash and Pay Verified, then rounding is impacted. The Bank totals should be $58.98 but soon after altering the pay scheme, it is changed to $59.00 Resolved in beta4
  3. Pay Signature report does not have the names of employee 1139 and 1195 becauase their Pay scheme are Direct. Their names should be in the Report as they were paid partial Cash and Part Banking. Resolved in beta4

20 Apr 201703:02PM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 21-04-2017 12:00 AM Time Taken: 2.00

Hi Team
Case has been tested with FICAC database. Test has been conducted with the steps in comment 4.

Following reports has been verified,

  1. Rounding on Pay Edit Screen (Issue), Fixed by Alvis during test
  2. Verification of Pay Audit Report (Pass)
  3. Verification of Pay Banking Report (Pass)
  4. Verification of Pay Coinage Report (Pass)
  5. Verification of Pay Signature Report (Pass)
I will continue test tomorrow and update the case with the results.

21 Apr 201701:21PM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 24-04-2017 12:00 AM Time Taken: 2.00
1. Was this test completed using Demo / New / Other database? FICAC database (10.0.0.14, DB: LINKSOFT, Payrun 1205)
2. Did the test pass or fail? Fail
3. Tab order, spelling, alignment, font size consistency, screen size etc checked? N/A
4. Data verified, saved, edit, delete/void? N/A
5. Documentation update required? No
Additional Details (Risks, issues, special conditions required for this test to pass etc): 

Following are issues on the pay summary report. Setup for the scenarios are as per comment 4

1. Error in Net Pay Distribution on the pay. Backing has summed the distribution for bank and cheque.

Net Pay = $10438.86

  Expected Distrubtion      System  Distrubtion 
Banking 5789.57      6814.16 (3624.7+1024.49)
Cash 3624.7      3624.7
Cheque 1024.49      1024.59
  10438.76      4649.29


2. The Pay Reconciliation at the bottom of the report has cash and cheque output twice.

Regards
Rashna


21 Apr 201701:50PM Comment 8 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 21-04-2017 01:50 PM Time Taken: 2.00

Hi Rashna,

I have resolved the issue in the report file. can you copy the update from beta4 and UAT.


24 Apr 201702:17PM Comment 9 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 24-04-2017 02:17 PM Time Taken: 2.00

This case has been tested in a copy of the Sonaisali database.

Issue in comment 7 has been tested successfully Refer to the figure 1 below. Items in comment 4 has passed. 

Case 8483 and 8484 has been logged for FICAC and FNPF.

Figure 1

Regards
Rashna




If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L08414 in the subject line of all emails regarding this issue.

Document size: 36.3 KB
For call complaints, please contact the Managing Director of the company using this form