Subject: | "Purchase Order Post to FMIS" creates duplicate GL Journals when the "AP Invoice" integration is turned off. |
Summary: | When a Purchase Order is posted from menu 577,following integration views are created: - General Journal
- AP Invoice
Thus the following should be enabled under Integration: - AccountsPayableInvoice
- GeneralLedgerJournal
The below was done: - I enabled the integration for "General Ledger Journal".
- Created and received a purchase order from Backoffice.
- Posted the purchase order to FMIs from menu 577 in Backoffice.
- The message read "Transaction Posted". This created the journal entry, however, the purchase order was not removed from menu 577. I was able to tick and post again which created the duplicate entry. Refer to Figure 1.
The PO was only posted and removed from menu 577 when I enabled "Accounts Payable Invoice". We need to modify this to avoid duplicates. Test Environment - JIWA Database - JIWA11895
- Link Database - LINKSOFT-JIWA7
- Server - 10.0.0.14
Figure 1: Duplicate Gl Journals
|
Audit Notes: | Edited by alvis on 10/02/21 16:57. Edited by rashna on 28/04/20 16:51. Edited by sanjay on 16/04/20 10:05. |
08 Apr 2020 | 02:44PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 09-04-2020 04:35 PM Time Taken: 1.00 |
| Development work for this case has been completed. The change will be available in version:11.5.0408 1. The following changes were made(Include Database object names, Program classes and any other relevant information): - Changed Purchase order Post to AP to check both "AP Invoice" and "GL Journal" is enabled before posting.
2. Affected Areas: - Purchase order Post to AP
3. The issue was caused by: - Improvement
4. Notes: 5. Next Step: UAT |
|
24 Apr 2020 | 03:44PM Comment 2 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 28-04-2020 05:37 PM Time Taken: 4.00 |
| Hi Rashna, System test completed. Please perform UAT in V11.5.0424. |
|
28 Apr 2020 | 04:51PM Comment 3 by Rashna (Edge Business Solutions) ETC was changed from 08/04/2020 to 28/04/2020 |
29 Apr 2020 | 09:30AM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 30-04-2020 11:23 AM 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 | Setup integration with JIWA 7 and LinkSOFT. Enable following integration rules. - GL Journal
- GL Master
- AP Master
| Pass | 2 | Create and POST a purchase order to FMIS. The integration should not integrate the PO. | Pass. | 3 | Enable AP Invoice. This should create the - AP Invoice View
- GL Journal View.
There should be any duplicates | Pass |
Environment Details - OS version: Windows Server 2012
- Application version: 11.5.428
- Setup: Demo
- Server : 10.0.0.14
- Database: LINKSOFT-DEMO-11-RASHNA
Next Step: - Closure
|
|