Company: Link Technologies
Case No: L12334. Project: 12.50: LinkSOFT Version 12.50
Logged By: Rashna (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 22 Jul 2021 01:23PM
Priority: Medium
Product: Point of Sale
Group: Software Defect
Time Taken: 14.00 (Weight: 16.00)
Version: 12.50.0726
Assigned To: Sanjay (Link Technologies)
Circulation: Rashna, Sanjay, Vineshwar Prasad
Resolve By: Friday, 16 July 2021 11:59 PM [1218 days since logged date]
Status: Closed
Subject: Transactions is in the "Integration Que" with status "Order Detail lines are incomplete. Possible reason: waiting for replication"
Summary:    
1. Problem Details (South Pacific Recordings Pte Ltd)

Ranjani advised that there are few Transactions from POS that they cannot locate in MYOB. Refer to below transaction;
  1. WHRC0000124
    1. The transaction was created in HQ on 08/10/2020.
    2. We checked the "Transaction Report", the details of the order are in the report. 
  2. WHRC0000125
2. Environment Details
  1. Version - 12.44.0713GA
  2. Database - CLIENT-SPR-LINKSOFT
  3. Serevr - QA4
  4. URL - https://10.0.0.13/LinkSOFT
  5. Login - admin/Linkfiji123
Audit Notes:Edited by sanjay on 23/07/21 11:44. Edited by sanjay on 23/07/21 08:18. Edited by sanjay on 23/07/21 08:08. Edited by sanjay on 23/07/21 08:08. Edited by rashna on 22/07/21 13:23. Edited by rashna on 22/07/21 12:35. 
15 Jul 202102:51PM Comment 1 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 16-07-2021 04:44 PM Time Taken: 1.00 Notes: ETC extended from: 16/07/2021 to 16/07/2021
Bula Team,

We did a Team Viewer meeting with Ranjani and worked on the case. The following was done;
  1. Verified the Invoices in LinkSOFT mentioned in case header
    • Invoices were created correctly in LinkSOFT
    • Invoices were created at Warehouse Location (HQ Server)
  2. Invoices could not be located under Integration -> Sales Order View

We verified the menu Point of Sales -> Integration Queue and found the invoices with the Status as "Order Detail lines are incomplete. Possible reason: waiting for replication".

We have advised Rajani that we will get our technical team to diagnose this issues. We will advise once we get an update.

Regards
Vineshwar Prasad


22 Jul 202101:26PM Comment 2 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 23-07-2021 01:23 PM Time Taken: 1.00

As per the development meeting with Sanjay, Alvis, Vinesh, Sitla, and Rashna

  1. Rewrite the case with a clear issue.
  2. Provide the database with a log of transactions mentioned in the case header.

Thanks
Rashna


23 Jul 202108:07AM Comment 3 by Sanjay (Link Technologies) Case L12334 added to project 12.50
23 Jul 202108:15AM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 27-07-2021 10:08 AM Time Taken: 9.00

We had a look through the code and found a possible reason this could happen.

The Invoice header has a TransactionCompleteMarker that calculates a value based on all relevant tables. this marker is incorrect when a transaction is modified after the original transaction is created.

For example, if a Credit sale is performed, the transaction marker has a value. This marker changes if an account payment is made. This will cause a " waiting for replication" message as the markers are different and the system suspects the transaction is INCOMPLETE

PART A - Development work for this case has been completed.

1. The change will be available in version:12.50.0723

2. The following changes were made(Include Database object names, Program classes, and any other relevant information):

  1. Do not take into account changes made after the transaction is saved. THerefore account payments are treated as a separate transaction

3. Affected Areas:

  1. Replication of transactions that can have multiple effects, e.g. Credit Sale Payments, Layby Payments

4. The issue was caused by:

  1. Programming error

5. Notes: 
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT


23 Jul 202108:18AM Comment 5 by Sanjay (Link Technologies) ETC was changed from 16/07/2021 to 16/07/2021
12 Aug 202112:55PM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 13-08-2021 02:48 PM Time Taken: 2.00
The following tests were performed:

Table 1 - Test Results
#Test Case DetailsPass/FailComments
 1
  1. Create replication from with HQ and a Branch
 Pass 
 2
  1. Process the following transactions in the Branch
    1. Deleted transaction.
    2. Cash Sales
    3. Credit Sale
    4. Credit Sales with Partial Payment
 Pass 
 3 
  1. Process the following transactions in the HQ
    1. Deleted transaction.
    2. Cash Sales
    3. Credit Sale
    4. Credit Sales with Partial Payment
 Pass 
 4
  1. Validate that the transactions in 2 above are replicated and marked as completed under "Linkweb-POS-Integration" in HQ.
  2. Validate that the transactions in above are marked as completed under "Link web-POS-Integration" in HQ.
 Pass 

Environment Details

  1. OS version:
  2. Application version: 12.50.0723GA
  3. Setup on:
    1. Server:LinkQA4
    2. Database: LINKSOFT-HQ and LINKSOFT-B1
    3. LinkSOFT URL: HTTP://10.0.0.13/LinkWEB-HQ and HTTP://10.0.0.13/LinkWEB-B1
  4. Login Details: Standard username and password for user "admin"

Next Step:

  1. Vineshwar to upload the latest SPR database and create a separate case for testing on the client database.
  2. This case can be closed as UAT in the standard database has passed.

12 Aug 202105:01PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 13-08-2021 07:01 PM Time Taken: 1.00
Thanks Rashna

If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12334 in the subject line of all emails regarding this issue.

Document size: 11.8 KB
For call complaints, please contact the Managing Director of the company using this form.