Dear Sanjay,

Testing of the csv file has been performed in the client database but the system did not output the file correctly.

The files are attached to this case as:

1. Before Upgrade
2. After Upgrade

Refer to steps below: 

1. Upgrade HA backup
2. Configured the following in ESS:
   • Activated: GLJournalFile
   • Enabled processes: ESS026 & SYS009
3. Created STFTN pay in Linksoft
4. Updated Pay
5. csv file generated incorrectly

1. The same pay for payteam STFTN was used to compare the before and after upgrade file

Environment Details:

1. QA: 3
2. DB: CLIENT-HA-LINKSOFT
3. V: 9.2.4.0.000

Refer to image below:

Figure 1: GL Setup

Hi Rashna,

Can we verify this together. There are some configurations and GL codes not setup

regards
Alvis

Dear Alvis,

Unable to test this case as the GL file is not putting in the demo environment. Reference case: 9135, subject: GL file is not generating in demo database.

Regards
Aarti

Hi Aarti,

I have verified this and the file is created in my environment. Can you re-install your applications and try again.

regards
Alvis

After the GTM session with Alvhe following was performed:

1. Restored DB as CLIENT-HA-LINKSOFT
2. Upgraded to V925
3. Configured ESS:
   1. Activated: GLJournalFile
   2. Enabled processes: ESS026 & SYS009
4. Ran the HA Script
5. Configure the following:
   1. SET @FMIS_GL_Super = ''1008350''
   2. SET @FMIS_GL_HGOLV_Clearing = ''1008380'' – SET THIS IN 233 – GL Govt
   3. SET @FMIS_GL_HGOLV_Expense = ''5000540'' – set in HGOVT paycode
   4. SET @FMIS_GL_SALARY_Clearing = ''1005270''
   5. SET @FMIS_GL_TAX_Expense = ''1005270''
   6. SET @FMIS_GL_TAX_Clearing = ''1008360''
   7. SET @FMIS_GL_LEAVE_Expense = ''5000540''
   8. SET @FMIS_GL_LEAVE_Provision = ''1009020'' – SET THIS IN 233 – GL Leave
   9. SET @FMIS_GL_BONUS_Expense = ''500480''  – set in HBONUS paycode
   10. SET @FMIS_GL_BONUS_Provision = ''1009021'
6. Create HBOUNS pay code
7. Created POFTN Pay for 2 employees:
   • In V8009
   • In V925
8. Pasted the customised GL file in location “C:\Program Files (x86)\Link Technologies\Reports”
9. Verified the GL integration report and updated the missing GL codes for pay codes
10. The GL integration file before and after does not match

Attachments:

1. HA Script
2. Version 7.4.0.2 Updates – contains customised GL file

Environment Details:

1. Before Upgrade:
   1. Application:QA3 
   2. DB: CLIENT-HA-LINKSOFTB4UPGRADE 
   3. DB: QA4
   4. V: 8009
2. After Upgrade:
   1. Application: QA3
   2. DB: CLIENT-HA-LINKSOFT 
   3. DB: QA4
   4. V: 925

Refer below:

Figure 1.1: Customized File

Figure 1.2: After upgrade, pasted customized file, the report did not output as required

Issues:

1. The customized report did not out as required in V925
2. The total report figure in both the pays were different in both version

Kindly require assistance in this.

Regards
Aarti

Hi Aarti,

Issue 1: report format has changed as we have standardized the GL report. This will remain as is.

Issue 2: Amounts not matching. We have checked the amounts and the amounts are matching. The cause is as follows:

1. GL Accounts entered for 1st report and 2nd report are not the same in your example. 
2. We have corrected the accounts for 2.1 above and the results are shown below.
3. GL Summary report is summarised by GL accounts.

regards
Alvis/Sanjay

This case has been tested, please find test plan below:

 Environment Details:

1. Before Upgrade:

• QA: 4
• DB: CLIENT-HA-LINKSOFTB4Upgrade
• DB: 4
• V: 8009

2. After Upgrade:

• QA: 3
• DB: CLIENT-HA-LINKSOFT
• DB: 4
• V: 926 

The files are attached to this case.

Kindly Review.

Regards
Aarti Gayaneshwar