Subject: | Issues with GL integration Report |
Summary: | Hi Rashna,
As discussed on the call, the following 2 issues exist in the GL report in version 11:- The debit and credit amounts are not tying at the employee level due to FNPF and Insurance commission amounts.
|
Audit Notes: | Edited by rashna on 12/05/20 15:35. Edited by alvis on 12/05/20 14:22. Edited by rashna on 12/05/20 13:25. |
12 May 2020 | 01:36PM Comment 1 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 12-05-2020 07:25 PM Time Taken: 1.00 |
| Hi Alvis, I have verified the case in version 11.5.0508. - The issue is not in the standard "GL Integration Report".
- The issue occurs when the Coca Cola Customization is enabled in "Lt_SYS_Customisations".
Issue: - The pay values for "HSUPE" Liability, "LICI Commission" and "FBSPIN Commission" are summed and printed on the top of the report.
- Since, the above are missing on the individual employee record the GL report shows balances for all employee record. However, the report summary shows the report is balanced. Refer to Figure 1.
- I tested the case as below:
- Disabled "GL Grouping" for HSUPE, LICI and FBSPIN.
- Created pay for employee 100035. Payrun 267.
- Validated the "GL Integration Report". Refer to Figure 1.
Setup: - DB - CLIENT-CCA-LINKSOFT-TRG
- Server - LINKQA4\CP42
Figure 1: GL Integration Report - Coca Cola.
Thanks Rashna |
|
12 May 2020 | 02:22PM Comment 2 by Alvis (Link Technologies) Case L11972 added to project 11.5 |
12 May 2020 | 02:23PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 12-05-2020 08:22 PM Time Taken: 2.00 |
| Development work for this case has been completed. The change will be available in version:11.5.0512 1. The following changes were made(Include Database object names, Program classes and any other relevant information): - Changed Coca-Cola GL Integration customization to tag employee for Super Liability and Commission journals.
2. Affected Areas: - Coca-Cola GL Integration
3. The issue was caused by: - Change request
4. Notes: 5. Next Step: UAT |
|
12 May 2020 | 03:35PM Comment 4 by Rashna (Edge Business Solutions) ETC was changed from 31/05/2020 to 12/05/2020 |
13 May 2020 | 10:17AM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 13-05-2020 04:12 PM Time Taken: 1.00 |
| QA Results Tests carried out according to requirements specified on the case header Test Results Summary Table 1 - Summarised list of issues No | Test Description | Pass/Fail | 1 | Upgrade database to version 11.5.0512. - Create pay for employee 100035.
- Add "LICI" and "FBSPIN" to the pay.
- Generate the "Gl Integration Report". Validate that the report shows all components on the employee level.
- The total balance should be 0 for the employee
| Pass |
Figure 1: GL Integration Report
Environment Details - OS version: Windows Server 2012
- Application version: 11.5.0512
- Setup: Demo
- Server : 10.0.0.14\CP42
- Database:CLIENT-CCA-LINKSOFT-TRG
Next Step: - Closure
|
|