| Subject: | Purchase Order received with a backdated date creates multiple Journals in Jiwa if the AP Integration date is AFTER the GL Journal Integration Data |
| Summary: | 1. Problem Details
Purchase Order received with a backdated date creates more than 1 Journal in Jiwa.
2. Environment Details
Version - 14.90.230621.GA
|
| Audit Notes: | Edited by sanjay on 29/09/23 14:20. Edited by sanjay on 22/09/23 16:21. Edited by sanjay on 30/08/23 14:53. Edited by sanjay on 29/08/23 15:17. |
| 29 Aug 2023 | 01:59PM Comment 1 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 30-08-2023 01:55 PM Time Taken: 3.00 Notes: ETC extended from: 29/08/2023 to 30/08/2023 |
| Bula Team,
We have reproduced the issue in a copy of the client's Database internally.
Steps;- Integration Start Date - 01/07/2023
- Created PO
- PO Number - LTPO018948
- Date - 03/08/2023
- Received Date - 15/06/2023
This creates multiple Journals in Jiwa.
Regards
Vineshwar Prasad |
|
| 29 Aug 2023 | 03:16PM Comment 2 by Sanjay (Link Technologies) Case L12935 added to project 15.00 |
| 29 Aug 2023 | 03:30PM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 31-08-2023 03:17 PM Time Taken: 5.00 |
| Diagnostics shows the issue is created by the AP Integration Start Date set to "01/07/2023" while the GL Journal Integration Date is set to "01/01/2000". This causes the Purchase Receipt to remain OPEN if the Receive date is between 01/01/2000 and 30/06/2023. To resolve the issue, we will add the Journal ID to the FMIS Reference. Ideally, the GL and AP dates should be the same since we want the AP Invoice and GL Journal to be created together. |
|
| 29 Aug 2023 | 04:17PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 31-08-2023 03:30 PM Time Taken: 7.00 Notes: ETC extended from: 29/08/2023 to 31/08/2023 |
| PART A - Development work for this case has been completed. 1. The change will be available in version: 15.00.230829 2. The following changes were made(Include Database object names, Program classes, and any other relevant information): - Once GL or AP integration is processed, we allocate the Purchase Receive FMIS Reference and mark the Purchase Receipt as "FMIS Integration Completed"
3. Affected Areas: - Purchase Receipt, GL and AP Integration
4. The issue was caused by: - When the GL Integration date is after the Purchase Invoice integration, the Purchase Receipt did not get marked as "Completed". This caused multiple Purchase Invoices to be created.
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT
|
|
| 30 Aug 2023 | 03:17PM Comment 5 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 01-09-2023 03:14 PM Time Taken: 4.00 |
|
The following tests were performed:
Table 1 - Test Results
| No | Test Case | Expected Result | Pass/Fail | Comments | | 1 | Set "GL Integration Start Date" to 01/01/2023 and AP integration Start date to 01/08/2023", Create a purchase Receipt for 01/07/2023 and Post
|
| Pass
|
| | 2 | Verify AP Invoice
| Should not be created as Start date is outside the AP Integration Start Date
| Pass
|
| | 3 | Verify GL Journal
| Should be created as Start date is within the GL Integration Start Date. Only ONE GL Journal should be created | Pass
|
|
Environment Details - OS version: Win11
- Application version: 15.00
- Setup on:
- Server: LinkQA4
- Database: LinkSOFT
- LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
- Login Details: Standard username and password for user "admin"
Next Step: Closure
|
|