Company: Link Technologies
Case No: L08399. Project: 08.20: LinkSOFT Version 8.2
Logged By: Vineet (Link Business Solutions) on 12 Mar 2017 09:08PM
Priority: High
Product: Payroll & HR
Group: Change Request
Time Taken: 13.00 (Weight: 13.00)
Version: 8.290.0115
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Vineet
Resolve By: Tuesday, 14 March 2017 12:00 AM [2574 days since logged date]
Status: Closed
Subject: Customization of Payroll GL Output file
Summary:    

Bula Vinaka Team

Further to our meeting with the XXXXX Group Team, they have requested for the below to be facilitated in the GL output file:

  1. HSUPE and FNTC expense to be distributed evenly in the respective Gross Pay codes. Example if an employee is paid $100 Normal Hours, $50 Time and Half and $30 Sick Leave, this HSUPE and FNTC levy should be expensed from these respective pay codes. Currently, its only being expensed from the GL account set at pay code of HSUPE and HGOVL respectively.
  2. Commission account for deductions that are grouped is not picked in the GL file. There are some deductions such as LICI which requires grouping.
  3. XXXXX Group has come across a scenario where some times deduction is made against an incorrect employee. Eg: Shoe deduction made against employee E001 instead of E002. They pay is sent to bank and updated. What the team does is, reimburse this to the employee in the following pay. Now reimbursement pay code needs to be shown in the GL output file with the employee id as a reversal. Currently the system does not facilitate for this scenario.

The setup for this has been done on QA 4 using CLIENT-XXXXX-GL. Figure 1.1 below shows details of how the sample output file should look like. A sample output file has been attached (XXXXX Group Sample Output File.csv)  for the same scenario

Figure 1.1


Best Regards
Vineet Ram
Consulting Manager

Audit Notes:
11 Apr 201709:51AM Comment 1 by Vineet (Link Business Solutions) Assigned To: AwaitingApproval Followup Date: 14-04-2017 12:00 AM

Hi Team

The case header has been updated with the respective details required together with a sample output file format. Please kindly review and advise on effort and release date

Regards
Vineet Ram


23 May 201710:40AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-05-2017 10:40 AM
Assigned to project 8.13

23 May 201710:41AM Comment 3 by Alvis (Link Technologies) Case 8399 added to project 8.13
23 Jun 201711:40AM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-06-2017 11:40 AM Time Taken: 8.00
Development work for this case has been completed.
The change will be available in version: 8.13
Documentation update required(Yes/No. Add change details below)
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. Added splitting of government levy expense entry to be based on the percentage of gross by pay code.
  2. Added splitting of employer super expense entry to be based on the percentage of gross by pay code.
  3. Corrected issue with GL account grouping for deduction commission pay codes
  4. Paycode additional field 1 is now used to denote if an allowance pay code is a refund of deduction pay code. This will then show the Employee ID in the CSV output file.

Documentation details:
  

03 Jul 201703:14PM Comment 5 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 03-07-2017 03:14 PM Time Taken: 1.00
System test completed, please proceed with UAT. 

06 Jul 201709:37AM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 06-07-2017 09:37 AM Time Taken: 2.00

. Was this test completed using Demo / New / Other database? Reddy Group Database
2. Did the test pass or fail? Failed
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): 

Hi Alvis, 

I setup the test database in QA4 as CLEINT-REDDY-LINKSOFT.

We created pay for 2 employees.

Attached is the Pay Edit Report, GL Report and the CSV output file for verification 

The following have been identified.

  • The Employee ID is not populated on the GL report  with refunds.
  • The GL Total on the Report and  the CSV file do not reconcile. The Report shows the total for an account, however the csv files shows two separate lines with hours and HSUPE&GOVL.
  • The GL total for 3001-TIH-RES-B04 on the report is 194.47
  • The Gl total on the csv file are 3001-TIH-RES-B04,WKL-2017-12 Payroll System,19.27 and 05/07/2017,12-2017,3001,WKL-2017-12 Payroll System,175.20. This should be summed on the file too.
Regards
Rashna

06 Jul 201702:02PM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 06-07-2017 02:02 PM Time Taken: 2.00
1. Was this test completed using Demo / New / Other database? Reddy Group DB with 813 Beta 1
2. Did the test pass or fail? Passed
3. Tab order, spelling, alignment, font size consistency, screen size etc checked? N/A
4. Data verified, saved, edit, delete/void? 
5. Documentation update required? No
Additional Details (Risks, issues, special conditions required for this test to pass etc): 

The following have been identified.

  • The Employee ID is not populated on the GL report  with refunds. - This was not in the initial requirement
  • The GL Total on the Report and  the CSV file do not reconcile. The Report shows the total for an account, however the csv files shows two separate lines with hours and HSUPE&GOVL. - Incorrect Setup. Changed GL grouping to "Yes" for Normal Hours.
  • The GL total for 3001-TIH-RES-B04 on the report is 194.47
  • The Gl total on the csv file are 3001-TIH-RES-B04,WKL-2017-12 Payroll System,19.27 and 05/07/2017,12-2017,3001,WKL-2017-12 Payroll System,175.20. This should be summed on the file too.
Regards
Alvis and Rashna

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

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