| Subject: | Reports Export Data raises an error when generating data export for FMIS Integrated reports |
| Summary: | Reports Export Data raises an error when generating data export for FMIS Integrated reports. An example of this report is report name: "Tax Report by Bank Reconciliation (FMIS) (Show Data)" |
| Audit Notes: | Edited by sanjay on 19/10/21 10:51. Edited by sanjay on 18/10/21 15:48. |
| 13 Oct 2021 | 04:53PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 13-10-2021 10:52 PM Time Taken: 6.00 |
| PART A - Development work for this case has been completed. 1. The change will be available in version:13.10.1013 2. The following changes were made(Include Database object names, Program classes, and any other relevant information): - Corrected scripts for data extraction
3. Affected Areas: - Data Export for FMIS integrated reports
4. The issue was caused by: - Object Name changes not implemented correctly
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation):UAT
|
|
| 18 Oct 2021 | 03:48PM Comment 2 by Sanjay (Link Technologies) ETC was changed from 15/10/2021 to 15/10/2021 |
| 19 Oct 2021 | 10:51AM Comment 3 by Sanjay (Link Technologies) Case L12614 added to project 13.11 |
| 21 Oct 2021 | 12:08PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 21-10-2021 05:51 PM Time Taken: 6.00 |
|
The following tests were performed:
Table 1 - Test Results
| # | Test Case Details | Pass/Fail | Comments | | 1 | Tax Report by Bank Reconciliation (FMIS) (Show Data)
| Pass
| | | 2 | Tax Return Report (FMIS) - Test Functions: DF, CRYSTAL, DATA, EMAIL | Pass
| | | 3 | Purchase Orders Not Invoiced As At (FMIS) - Test Functions: DF, CRYSTAL, DATA, EMAIL
| Pass
| | | 4 | Pay FMIS Integration Report - Test Functions: DF, CRYSTAL, DATA, EMAIL
| Pass
| | 5
| Licence Revenue Analysis (FMIS) - Test Functions: DF, CRYSTAL, DATA, EMAIL
| Pass
|
| 6
| Invoice Payment Summary (FMIS) (Show Data)
| Pass
|
| 7
| GL Profit & Loss (FMIS) - Test Functions: DF, CRYSTAL, DATA, EMAIL
| Pass
|
| 8
| Fiji VAT Return Form (FMIS) - Test Functions: DF, CRYSTAL, DATA, EMAIL
| Pass
|
| 9
| Debtor Balance As At (FMIS) - Test Functions: DF, CRYSTAL, DATA, EMAIL
| Pass
|
| 10
| Creditor GL Transactions (FMIS)
| Fail
| Error in File FMS-JW006-ERPCreditorGLTransactions 10188_9528_{71E8169C-B4A4-4F8D-A5AA-C4C961198E86}.rpt: The table could not be found.
|
Environment Details - OS version: Win10
- Application version: 13.11
- Setup on:
- Server: LinkQA9
- Database: LINKSOFT
- LinkSOFT URL: HTTP://
- Login Details: Standard username and password for user "admin"
Next Step: Resolve error on item 10
|
|
| 21 Oct 2021 | 02:29PM Comment 5 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 21-10-2021 08:27 PM Time Taken: 4.00 |
| PART A - Development work for this case has been completed. 1. The change will be available in version: 13.11.1021B 2. The following changes were made(Include Database object names, Program classes, and any other relevant information): - Corrected report by relinking the report to the procedure.
3. Affected Areas: - Report - Creditor GL Transactions (FMIS)
4. The issue was caused by: - The procedure named had been changed without changing the report connectivity
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT
|
|
| 21 Oct 2021 | 04:13PM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 21-10-2021 10:11 PM Time Taken: 1.00 |
|
The following tests were performed:
Table 1 - Test Results
| # | Test Case Details | Pass/Fail | Comments | | 1 | Creditor GL Transactions (FMIS) - Test Functions: DF, CRYSTAL, DATA, EMAIL
| Pass
| | | 4 | | | |
Environment Details - OS version: Win10
- Application version: 13.11
- Setup on:
- Server: LinkQA4
- Database: LinkSOFT
- LinkSOFT URL: HTTP://
- Login Details: Standard username and password for user "admin"
Next Step: Closure
|
|