Subject: | GL file integration from PAYROLL Processing from in generating incorrectly in V933. |
Summary: | Dear Sanjay, GL integration file is different in version 933, however, during testing the file was correct till beta 925 (beta). Refer to steps below: Version 925 (beta): - Restored Colgate’s DB as CLIENT-LINKSOFT_925
- Installed version 925 (beta)
- Upgrade the database
- Configured ESS:
- Activated: GLJournalFile
- Enabled processes: ESS026 & SYS009
- Created pay dated “31/08/2018”
- Updated pay
- File was generated correctly. [The file is attached to this case as 925.txt]
- Refer to image below:
Version 933: - Restored Colgate’s DB as CLIENT-COLGATE-LINKSOFT_933
- Installed version 933
- Upgrade the database
- Configured ESS:
- Activated: GLJournalFile
- Enabled processes: ESS026 & SYS009
- Created pay dated “31/08/2018”
- Updated pay
- File was generated correctly. [The file is attached to this case as 933.txt]
- Refer to image below:
Environment Details: - QA: 4
- BETA 925: CLIENT-COLGATE-LINKSOFT_925
- V933: CLIENT-COLGATE-LINKSOFT_933
Issue: - The file was correct till beta 925, there was no issues logged with Colgate’s GL file, therefore the file should have generated the same in V933.
Expected Outcome: - File in Beta 925 and file in V933 should be the same.
- File from BETA 925 is correct
Kindly take a look. Regards Aarti Gayaneshwar |
Audit Notes: | |
21 Mar 2018 | 09:24AM Comment 1 by Sanjay (Link Technologies) Case 9222 added to project 9.4 |
22 Mar 2018 | 11:22AM Comment 2 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 22-03-2018 12:00 AM Time Taken: 0.25 |
| Dear Team, Kindly requesting for an update for this case in v933. Regards Aarti |
|
26 Mar 2018 | 08:25AM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 26-03-2018 08:25 AM |
| Proceed with investigation and resolution in 9.4 |
|
26 Mar 2018 | 10:23AM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 26-03-2018 10:23 AM Time Taken: 1.00 |
| Development work for this case has been completed. The change will be available in version: 9.4.0.0 and 9.3.3.0.001
1. The following changes were made(Include Database object names, Program classes and any other relevant information):| - Changed OUTPUT file content to have the same format for pay codes that are grouped and not grouped.
- Changed the Journal transactions recompute process to tag pay codes as grouped when there is no matching entry in the pay code maintenance. This matching is done by "pay code" and "pay code" classification.
2. The issue was caused by: - The issue was caused by "pay codes" that did not have a matching entry in the pay code maintenance was tagged as grouped = N. This caused the OUTPUT file to behave differently.
|
|
06 Apr 2018 | 06:35AM Comment 5 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Development Followup Date: 06-04-2018 12:00 AM Time Taken: 0.50 |
| Hi Sanjay, Requesting for the update 9.3.3.0.001. Regards Aarti |
|
06 Apr 2018 | 11:00AM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 06-04-2018 11:00 AM Time Taken: 1.00 |
| Hi Aarti, The update is on Link FTP server. You can download from this link. regards Alvis |
|
30 Apr 2018 | 02:51PM Comment 7 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 30-04-2018 02:51 PM Time Taken: 1.00 |
| System test completed. The following were done: - Upgraded client database QA4 CLIENT-COLGATE-LINKSOFT_9400 to version 9.4
- Created a new pay for SAL pay team and updated the pay.
- Verified the journal file created and confirm that the format is correct. See screenshot below:
|
|
01 May 2018 | 02:30PM Comment 8 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 01-05-2018 02:30 PM Time Taken: 2.00 |
| Hi Sanjay, This case has been successfully tested. Test Environment - Version 9400 Beta 1
- Database - CLIENT_LINKSOFT_COLGATE on QA4
- Application on QA1
- OS - Windows 7
Test Plan Test No | Description | Status | 1 | Restore and upgrade the database to 9400. The upgrade should complete without errors | Pass | 2 | Enable FMIS integration process ESS026. This should execute without errors | Pass | 3 | Set the configuration for "EnableIntegrationScheduler" to Yes. This should be saved without errors. | Pass | 4 | Create the SAL pay for date 31/08/2018. Pay should be created and updated without errors | Pass | 5 | The CSV file should be successfully generated in ESS. | Pass | 6 | Compare the file output with the attached file labeled as 925.txt. The file format matches. | Pass |
Figure 1: File Output
|
|
02 May 2018 | 08:38AM Comment 9 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 02-05-2018 08:38 AM |
| Hi Rashna, Has documentation been updated?. If so, close this case. |
|
09 May 2018 | 01:28PM Comment 10 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 09-05-2018 01:28 PM Time Taken: 0.50 |
| Hi Sanjay, This is a customization for Colgate, this will not be included in the standard documentation. Thanks Rashna |
|
09 Oct 2019 | 08:14AM Comment 11 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019 |