Company: Link Technologies
Case No: L08810. Project: 08.20: LinkSOFT Version 8.2
Logged By: Rashna (Edge Business Solutions) on 13 Sep 2017 08:55AM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 4.00 (Weight: 4.00)
Version: 8.290.0115
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay, Vineet
Resolve By: Wednesday, 30 August 2017 05:19 AM [2389 days since logged date]
Status: Closed
Subject: Issues with Lot Bin transfers
Summary:    

Hi Sanjay, 

A client has reported that when transferring items from one employee to another- the items appear on both the employees' listings.

  • Database - CLIENT-XXXXX-LINKSOFT
  • QA - QA4
  • Version - 817

I did a test transfer and the below were identified.

  • Transfer ID - XF0000005880
  • Affected product - P0000000643
  • The transfer was made from bin 161 to Meli.
  • Item exists in both the bins.
  • Also for Location "Emp", the In stock amount does not match the bin amount in the lot bin details.


Regards
Rashna

Audit Notes:
13 Sep 201702:55PM Comment 1 by Alvis (Link Technologies) Case 8810 added to project 8.18
13 Sep 201702:58PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 13-09-2017 02:58 PM Time Taken: 2.00

The following were completed:

  1. Corrected issue where lot bin serial had ref numbers in "transfer" process.

The issue was caused by the "Transfer" process using blanks for reference numbers. If there was a number in lot bin serial table this issue was then caused.



21 Sep 201709:33AM Comment 3 by Vineet (Link Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 21-09-2017 09:33 AM Time Taken: 1.00

Bula Vinaka Guys

I have tested this on our demo Linksoft using part number EL001. Issue was not replicated. So I restored the FICAC DB on QA4 again, upgraded it to version 8.18 from version 8.12 and used the steps below steps to do the transfer:

  1. Transferred product P0000000643 SERIAL JWC522S6432 from Emp location to JHB.
  2. After shipment, the inv_list quantity was reduced BUT Lot Bin detail amount remained the same with this serial number for EMP location JWC522S6432

Setup is on QA4. DB Name: CLIENT-FICAC-LINKSOFT

Best Regards
Vineet Ram


21 Sep 201709:45AM Comment 4 by Sanjay (Link Technologies) Assigned To: Vineet (Link Business Solutions) Followup Date: 21-09-2017 09:45 AM

Hi Vineet,

Please apply data fix script to FICAC database then retest.

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

DELETE FROM LBS_LOT_BIN_SER WHERE company_id = '1001' and location = 'EMP' and part_no = 'P0000001190' and bin_no = '112' and lot_ser = 'G1000GHJ11903' and ref = 'N/A'
DELETE FROM LBS_LOT_BIN_SER WHERE company_id = '1001' and location = 'JHB' and part_no = 'P0000000473' and bin_no = 'ST' and lot_ser = '9UL854384731' and ref = 'N/A'
DELETE FROM LBS_LOT_BIN_SER WHERE company_id = '1001' and location = 'JHB' and part_no = 'P0000000504' and bin_no = 'ST' and lot_ser = 'P00000005043' and ref = 'N/A'
update LBS_LOT_BIN_SER SET ref = ''

UPDATE LBS_INV_LIST SET
in_stock = ISNULL((SELECT
SUM(s.qty)
FROM LBS_LOT_BIN_SER s
WHERE s.company_id = l.company_id
AND s.part_no = l.part_no
AND s.location = l.location
),0)
FROM LBS_INV_LIST l
JOIN LBS_INVENTORY i ON l.company_id = i.COMPANY_ID and l.part_no = i.part_no
where i.lot_bin_track = 'Y'

21 Sep 201710:36AM Comment 5 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 21-09-2017 10:36 AM Time Taken: 1.00

Bula Vinaka team

After applying the updates provided by Alvis, I have retested this on client database. This issue could not be replicated for the 2 products I tried. P0000000643 and P0000000644.

Best Regards
Vineet Ram
Consulting Manager


09 Oct 201908:14AM Comment 6 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
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L08810 in the subject line of all emails regarding this issue.

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