| Subject: | Customization for Colgate - GL integration file |
| Summary: | 1. Issue Description (Current behaviour and expected behaviour):
Colgate team has advised that after the upgrade, the GL file has changed. Client has been upgraded from version 8007.11 - 829. In version 8007.11, their customization was not part of the standard customization framework. This was migrated in case: 8037. Refer to image below: Before Upgrade: 
After Upgrade: 
The files are also attached.
2. Environment Details: (Application version and Patch and any other information that will help identify the issue)
829 |
| Audit Notes: | |
| 07 Jan 2018 | 07:25PM Comment 1 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 09-01-2018 12:00 AM Time Taken: 3.00 |
| Dear Alvis, Colgate team has advised that after the upgrade, the GL file has changed. Steps performed during Upgrade:
- Took a backup of the Linksoft database
- Installed Linskoft 829
- Upgraded the database
- Enabled Colgate’s customisation: update LT_SYS_Customizations set Enabled = 1 where Description = 'Post upgrade customizations for Colgate-Palmolive (Fiji) Ltd'
- Ran the 999 scripts again
- Made pay
- GL file did not match with the original file
The environment is setup in QA4 as:
- 8007 – CLIENT-COLGATE-LINKSOFT-8007
- 829 – CLIENT-COLGATE-LINKSOFT-829
Kindly take a look and advise. Regards
Aarti. |
|
| 09 Jan 2018 | 02:41PM Comment 2 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 11-01-2018 12:00 AM Time Taken: 1.00 |
| Hi Alvis, After analysing case 8037, the following was performed:
- Applied Updates
- Executed 999 scripts
- Create Pay
- Updating pay, the following was received:
The environment is setup in QA4, DB: CLIENT-COLGATE-LINKSOFT-829. Regards
Aarti Gayaneshwar
|
|
| 10 Jan 2018 | 09:31AM Comment 3 by Alvis (Link Technologies) Case 9035 added to project 900 |
| 15 Jan 2018 | 10:49AM Comment 4 by Alvis (Link Technologies) Case 9035 removed from project 900 |
| 15 Jan 2018 | 10:49AM Comment 5 by Alvis (Link Technologies) Case 9035 added to project 8.3 |
| 16 Jan 2018 | 08:23AM Comment 6 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 16-01-2018 08:23 AM Time Taken: 1.00 |
| The issue was caused in the custom script for GL integration. This has been resolved. An update will be available for version 8290.002. regards
Alvis |
|
| 16 Jan 2018 | 03:15PM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 16-01-2018 03:15 PM Time Taken: 4.00 |
| Hi Alvis, I have tested the case in our test enviornment. The below was done - Upgraded database to 8.2.9
- Enabled Customization for Colgate in the LT_SYS_Customization
- Applied script
UPDATE LBS_CONFIG SET value_str = 'LBS_GL_Integration_CUSTOM_ColgatePalmoliveFijiLtd' WHERE flag = 'FMIS.GL.CUSTOM.PROCEDURE' UPDATE LBS_CONFIG SET value_str = 'CUSTOM' WHERE flag = 'FMIS.GL.SYSTEM' UPDATE LT_SYS_Customizations SET Enabled = 1 WHERE Description = 'Post upgrade customizations for Colgate-Palmolive (Fiji) Ltd' EXEC [dbo].[LT_SYS_Customizations_PROCESS] @ModuleID = 'SYS' ,@Process = 'Post Upgrade'
Ran script 9999. After running the script , we created pay and updated pay. At pay update we got the error as mentioned in comment 2 on the case. We applied updates 8290.002. Pay was successfully updated. However, the GL file created was not in the customized format as it was in version 8007. Attached are two file formats from the two version.
Note: In version 8007.11, the File System Name was CSV. Setup Details 8.2.9 - Database - CLIENT-COLGATE-LINKSOFT
- Database Location - QA4
- Application Location - QA4
- FMIS File Path - C\FMIS on QA4
- Pay Number - 554
8007.11 - Database - CLIENT-COLGATE-LINKSOFT-8007
- Database Location - QA4
- Application Location - QA1
- FMIS File Path - C\FMIS8007 on QA4
- Pay Number - 559
Can you please advise what needs to be corrected so the csv file is generated with customized file format.
|
|
| 16 Jan 2018 | 04:16PM Comment 8 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 16-01-2018 04:16 PM Time Taken: 1.00 |
| Hi Rashna, I have changed the script in version 8.2.9.0.002 so that the output file is same as the previous version. To apply this update for Colgate, follow these steps: - Upgraded database to 8.2.9
- Apply update 8.2.9.0.002
- Apply scripts below
UPDATE LT_SYS_Customizations SET Enabled = 1 WHERE Description = 'Post upgrade customizations for Colgate-Palmolive (Fiji) Ltd' EXEC [dbo].[LT_SYS_Customizations_PROCESS] @ModuleID = 'SYS' ,@Process = 'Post Upgrade'
- Generate the output file and verify.
regards
Alvis |
|
| 17 Jan 2018 | 09:04AM Comment 9 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 17-01-2018 09:04 AM Time Taken: 2.00 |
| Hi Team, I have tested the case with below steps - Installed version 829 of the website release date 1/3/2018.
- Restored Colgate database (8007.11) as CLIENT-COLGATE-LINKSOFT. This was done in QA4
- Upgraded database to 8.2.9.
- Applied 8.2.9.0.002
- Applied below script
UPDATE LT_SYS_Customizations SET Enabled = 1 WHERE Description = 'Post upgrade customizations for Colgate-Palmolive (Fiji) Ltd' EXEC [dbo].[LT_SYS_Customizations_PROCESS] @ModuleID = 'SYS' ,@Process = 'Post Upgrade'
- Created and Updated Pay
- Verified GL output file
The GL output file was per the customized format for Colgate. Figure 1: Test Results 
This case is now closed.
|
|
| 09 Oct 2019 | 08:14AM Comment 10 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 |