Company: Link Technologies
Case No: L12068. Project: 12.30: LinkSOFT Version 12.30
Logged By: Rashna (Edge Business Solutions) on 20 Nov 2020 02:38PM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 5.00 (Weight: 5.00)
Version: 12.30
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay
Resolve By: Saturday, 21 November 2020 11:59 PM [1462 days since logged date]
Status: Closed
Subject: Incorrect Stock Update through Inventory Transfers
Summary:    

Steps 

  1. Setup Replication between HQ and Branch
  2. Created a transfer in the demo database from "Retail to Main" in Branch.
    1. Product = PNT02. 
    2. Transfer Quantity - 50
  3. Ship stocked from HQ.
  4. Received stock in Branch. 
  5. The stock update from receive is incorrect. Refer to Table 1.
Stock Before Transfer (HQ and Branch)

Expected Stock After Transfer (HQ and Branch)

System Result

Retail - 10000

Main - 0

Retail - 9950

Main  - 50

HQ

Retail - 9950

Main  - 0

Branch

Retail - 10000

Main - 50



Setup
  1. Server - 10.0.0.13
  2. Databases - LINKSOFT_HQ and LINKSOFT_BRANCH
  3. Transfer - B1XF0000002
  4. Version - 12.2.1111
Audit Notes:Edited by rashna on 10/02/21 16:55. Edited by rashna on 25/11/20 08:07. Edited by alvis on 20/11/20 14:38. 
20 Nov 202002:28PM Comment 1 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 20-11-2020 08:26 PM Time Taken: 1.00

Hi Alvis, 

As per the Microsoft Teams meeting

  1. Case assigned to Alvis for correction
  2. Assign case to Sanjay for review and closure.
Thanks
Rashna

20 Nov 202002:38PM Comment 2 by Alvis (Link Technologies) Case L12068 added to project 12.3
20 Nov 202002:41PM Comment 3 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 20-11-2020 08:38 PM Time Taken: 2.00

Development work for this case has been completed.

The change will be available in version:12.2.1120 and 12.3

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

  1. Changed the background queue process to run under linkadmin context. linkadmin context is used for replication.

2. Affected Areas:

  1. Transfer receive

3. The issue was caused by:

  1. Replication uses linkadmin user to track changes, the background queue process that posts the transfer was not under linkadmin context.

4. Notes: 
5. Next Step: UAT

----------------------

Development Reference:


20 Nov 202004:36PM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 20-11-2020 10:32 PM Time Taken: 2.00
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
NoTest DescriptionPass/Fail
1
  1. Created a Transfer from in Branch for item PNT04.
  2. Transfer from Retail to Main
  3. Ship from HQ
  4. Receive from Branch
  5. The transfer should be received in  HQ and Branch

Expected Results after transfer

  1. Retail - 9950
  2. Main  - 50
Pass

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 11.0.0506
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-11-RASHNA

Next Step: 

  1. Assigned to Sanjay for Review and Closure

    25 Nov 202008:07AM Comment 5 by Rashna (Edge Business Solutions) ETC was changed from 21/11/2020 to 21/11/2020
    30 Nov 202009:48AM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 30-11-2020 03:48 PM
    Thanks Rashna

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

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