| Subject: | Sales orders are posted to the ledgers using the date on which the integration was setup instead of the transaction date |
| Summary: | 1. Problem Details When sales orders are integrated into Jiwa, the sales order's initiated date in Jiwa is the actual transaction date that came in through POS. However, when these sales orders are processed, the posted dates change to reflect the integration date (the date the integration was created). The problem with the above is that the transaction date does not match with the posted date. This is an issue because 2017 transactions are being posted in 2018 causing transactions to reflect in the incorrect financial year.
2. Error Message (Include screenshot of error)
Figure 1: POS Transaction - Date is 29/08/2017 
Figure 2: Sales Order in Jiwa - Initiated Date matches the Transaction Date in POS
.JPG)
Figure 3: Journal Set - Posted Date does not match the Transaction Date
.JPG)
3. Environment Details
Server Name: 10.0.0.14
Jiwa Database Name: CLIENT_XXXXX_JIWA_UAT
Linksoft Database Name: CLIENT_XXXXX_LINKSOFT_UAT - Demo database
POS-Web Address: Hosted in QA2 http://localhost/POS-TRG/
All default logins
|
| Audit Notes: | |
| 01 Jun 2018 | 08:21AM Comment 1 by Sanjay (Link Technologies) Assigned To: Karishma Kartika Devi (Link Fiji) Followup Date: 01-06-2018 08:21 AM |
| Hi Karishma, This is not an issue with LinkSOFT. Please goto JIWA support for advice. regards
Alvis |
|
| 01 Jun 2018 | 09:11AM Comment 2 by Karishma Kartika Devi (Link Fiji) Assigned To: Alvis (Link Technologies) Followup Date: 01-06-2018 09:11 AM |
| Hi Alvis, I have tested this case in the Jiwa demo environment without having integration setup: - Created a sales order in Jiwa
- Put the initiated date as 28/08/2017
- Processed the sales order
- The journal set got updated with the transaction date ie. 28/08/2017
Note: The sales order posted date is the same as the initiated date From the above results, the issue mentioned in the case header does not seem to be an issue from Jiwa's end. Requesting if we can schedule a time to discuss this case further. Please advise. Regards
Karishma |
|
| 01 Jun 2018 | 09:17AM Comment 3 by Sanjay (Link Technologies) Assigned To: Karishma Kartika Devi (Link Fiji) Followup Date: 01-06-2018 09:17 AM Time Taken: 1.00 |
| Hi Karishma, Can you create a sales order in EXTRA JIWA and POST. Send me both screenshots showing sales order you created in JIWA and a sales order flowed from POS. I need this to be in the same database so I can isolate where the issue is. regards
Alvis |
|
| 01 Jun 2018 | 10:24AM Comment 4 by Karishma Kartika Devi (Link Fiji) Assigned To: Alvis (Link Technologies) Followup Date: 01-06-2018 10:24 AM Time Taken: 0.50 |
| Hi Alvis I have replicated the issue in the setup done in QA2. Refer below for screenshots:
Figure 1: Sales Order Created in Jiwa - Initiated Date = 31/08/2018
.JPG)
Figure 2: Journal Set Posted as a Result - Initiated Date = Posted Date
Figure 3: Sales Order Flowed from POS - Initiated Date = 01/09/2017
Figure 4: Journal Set Created as a Result - Posted Date (01/06/2018) is different from Initiated Date
 |
|
| 01 Jun 2018 | 03:44PM Comment 5 by Alvis (Link Technologies) Case 9317 added to project 09.4 |
| 01 Jun 2018 | 03:46PM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 01-06-2018 03:46 PM Time Taken: 1.00 |
| Development work for this case has been completed. The change will be available in version: 9.4 beta4 1. The following changes were made(Include Database object names, Program classes and any other relevant information):| - Corrected the issue in the JIWA integration API script.
2. The issue was caused by: - Sales orders created in JIWA had the date posted defaulted to current machine date. This has been corrected in beta4 to use transaction date.
3. Next Step - UAT
|
|
| 04 Jun 2018 | 03:47PM Comment 7 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 04-06-2018 03:47 PM Time Taken: 1.00 |
| System test completed. Verified sales order transaction date and journal posted date are the same.
|
|
| 05 Jun 2018 | 02:40PM Comment 8 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 06-06-2018 12:00 AM Time Taken: 1.00 |
| Hi Sanjay,
This case has been successfully tested.
Documentation is not required for the case.
Test Environment
- Version 9400 Beta 4.
- Database - LINKSOFT and JIWA database on QA1
- Application on QA1
- OS - Windows7.
Test Plan | Test | Description | Status | | 1 | Create JIWA and POS integration | Pass | | 2 | Create a sales of date 01/04/2018 | Pass | | 3 | Sales order should be created with date 01/04/2018 | Pass | | 4 | Activate SO, journal set should be created with date 01/04/2018 | Pass |
Thanks Rashna |
|
| 05 Jun 2018 | 03:31PM Comment 9 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 05-06-2018 03:31 PM |
| Thanks Rashna |
|
| 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 |