Company: Link Technologies
Case No: L12776. Project: 14.10: LinkSOFT version 14.10 - October 2022
Logged By: Vineshwar Prasad (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 22 Aug 2022 04:30PM
Priority: Medium
Product: Point of Sale
Group: Software Defect
Time Taken: 16.00 (Weight: 16.00)
Assigned To: Development
Circulation: Development, Navneet Kumar, Sanjay, Vineshwar Prasad
Resolve By: Friday, 30 September 2022 12:00 AM [617 days since logged date]
Status: Closed
Subject: Stock Transfer did not update the SOH
Summary:    
1. Problem Details

Stock Transfer has been received but the SOH has not been updated

2. Environment Details

Version - 13.20.1215.GA
Audit Notes:Edited by sanjay on 22/08/22 16:30. Edited by sanjay on 22/08/22 15:59. 
08 Aug 202203:03PM Comment 1 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 09-08-2022 02:53 PM Time Taken: 1.00 Notes: ETC extended from: 09/08/2022 to 09/08/2022
Bula Team,

We connected onsite and worked on the case. The following was done;
  1. Verified setup for Product: 13GBFR
  2. Verified Status of Stock Transfer which was on "Received". Transfer Number: LTXF035582
  3. Verified Inventory Movement Report. Transfer LTXF035582 was not included in the Movement Report
  4. Verified Stock Transfer Report and found "Ship Date" and "Receive Date" missing
We have run the Inventory Recompute process to verify the extent of the mismatch. Once this is completed then we will check why the Dates are not updated on the report.

Regards
Vineshwar Prasad

09 Aug 202203:50PM Comment 2 by Navneet Kumar Assigned To: Navneet Kumar Followup Date: 12-08-2022 02:28 PM Time Taken: 3.00 Notes: ETC extended from: 09/08/2022 to 12/08/2022
Bula Team,

The Inventory Re-compute Process did not resolve the issue. The "Ship Date" and "Receive Date" is still missing from the Transfer.

We have taken a copy of the Database to setup an Environment internally on our Test Server. We will get our technical team to diagnose why the dates are missing.

Regards
Navneet Kumar


11 Aug 202202:10PM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 15-08-2022 02:04 PM Time Taken: 1.00

Discussion Notes - Sanjay and Vineshwar:

  1. Create a testing environment on QA4 using Shopfittings DB
  2. We cannot reproduce the issue in our demo/testing environments
  3. Try and reproduce the issue on 1 above
  4. Schedule a discussion with Sanjay as soon as 3. is attempted.



12 Aug 202210:46AM Comment 4 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 16-08-2022 10:34 AM Time Taken: 1.00 Notes: Edited by vineshwar on 17/08/22 07:38. ETC extended from: 12/08/2022 to 16/08/2022
Bula Team,

The following was done;
  1. Setup test Envrionemnt internally
  2. Created Inventory Item TEST001
    1. Added Location WW - Waqadra Warehouse
    2. Added Location SVBLK - Suva Bulk
  3. Created Inventory Adjusted IN of 100 for Location WW - Waqadra Warehouse
  4. Created Stock Transfer of Qty 25 from Location WW to SVBLK
  5. Submitted, Ship & Received successfully
We could not reproduce the issue. We will get our technical team to investigate further.

Regards
Vineshwar Prasad

22 Aug 202203:58PM Comment 5 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 23-08-2022 03:50 PM Time Taken: 2.00 Notes: ETC extended from: 16/08/2022 to 23/08/2022
Discussion Notes with Sanjay and Vineshwar
  1. We were able to reproduce the issue by getting the User to manually remove the Shipped Date before receiving the Transfer
  2. Please ensure that Users do not remove the Shipped Date before receiving the Transfer
There are 26 Transfer lines that had this issue. This can be corrected using the script in Figure 1 below;

Figure 1: Script to correct Transfers where Shipped Date has been removed
UPDATE LBS_XFER_HD SET ship_date = h.LastSavedDateTime, rec_date = h.LastSavedDateTime
FROM LBS_XFER_HD h
JOIN LBS_XFER_DET d ON h.xfer_no = d.XFER_NO
WHERE h.status = 2
AND h.ship_date IS null

22 Aug 202203:59PM Comment 6 by Sanjay (Link Technologies) Case L12776 added to project 14.10
06 Sep 202203:04PM Comment 7 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 07-09-2022 04:39 PM Time Taken: 4.00
PART A - Development work for this case has been completed.

1. The change will be available in version:14.10

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

  1. Added validation so that when the Transfer is in "Transit", the Ship Date is required.

3. Affected Areas:

  1. Transfer Request - In transit

4. The issue was caused by:

  1. User can set the "Ship Date" to "Blank" causing the shipment to be outside the date range expected

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


27 Sep 202210:31AM Comment 8 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 28-09-2022 12:19 PM Time Taken: 4.00
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Create a transfer. Ship the transfer
The "Ship Date" is allocated. Edit and change the ship date. 
Pass

2
Edit and remove the Ship Date. The system should not allow to "Save"
Pass
The system raises an error saying "Ship Date" is required
3



Environment Details

  1. OS version: Win11
  2. Application version: 14.10
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


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

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