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: - 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.
- Commission account for deductions that are grouped is not picked in the GL file. There are some deductions such as LICI which requires grouping.
- 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 2017 | 09: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 2017 | 10: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 2017 | 10:41AM Comment 3 by Alvis (Link Technologies) Case 8399 added to project 8.13 |
23 Jun 2017 | 11: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): - Added splitting of government levy expense entry to be based on the percentage of gross by pay code.
- Added splitting of employer super expense entry to be based on the percentage of gross by pay code.
- Corrected issue with GL account grouping for deduction commission pay codes
- 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 2017 | 03: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 2017 | 09: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 2017 | 02: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 |
|