Company:	Link Technologies
Case No:	L12976. Project: 15.10: LinkSOFT Version 15.10
Logged By:	Vineet (Link Business Solutions) on behalf of Sanjay (Link Technologies) on 22 Nov 2023 05:16PM
Priority:	High
Product:	Point of Sale
Group:	Software Defect
Time Taken:	18.00 (Weight: 8.00)
Assigned To:	Development
Circulation:	Development, Sanjay, Vineet
Resolve By:	Monday, 27 November 2023 05:14 PM [161 days since logged date]
Status:	Closed

Subject:

Returns done in POS does not recalculate stock in the valuation table

Summary:

Section A. Describe what the issue is about. Include Error Message (and screenshots (600px x 800px 100kb max size)

When a return is done in POS with a reason selected to credit the stock, the valuation process does not take this into account, causing a mismatch between Inventory movement and valuation report for the same period

Section B. Environment Detail

LinkQA8-LBS2

Link Technologies - DEMO

LinkSOFT-Demov15

http://10.0.0.18/LinkSOFT-Demov15/

Section C. The issue can be reproduced by performing the following steps:

Task No	Task Description	Transaction Quantity	Calculated Running Balance (Retail)	System Stock Product Master (Retail)	System Stock Inventory Movement (Retail)	Valuation Stock (Retail)	Status
1	Create Item LBS001. Purchase Item. Setup Conversion Box12 to Each : 12	0	0	0	0	0	Pass
2	Create Item LBS002. Purchase Item. Setup Conversion Box12 to Each : 12	0	0	0	0	0	Pass
3	Raise Purchase Order and Receive 10 Cartons of Box12 with 10 Each FOC	130	130	130	130	130	Pass
4	Adjust in 10 of LBS001 and LBS002	10	140	140	140	140	Pass
5	Transfer 25 of each from RETAIL to MAIN	25	115	115	115	115	Pass
6	Sales 10 of each	-10	105	105	105	105	Pass
7	Returns 2 as Damaged from sale in (7) above	2	105	105	105	105	Pass
8	Returns 2 as Incorrect Price sale in (7) above	2	107	107	107	105	Fail
	As a secondary measure re-ran the valuation process POS012. No difference to Valuation
9	Create a price class LBSASRT and assign to these items
10	Scan and sell 2 of each on Price Class	-4	105	105	105	105	Pass
11	Return 1 of Each as Incorrect Price sale in (11) above	1	106	106	106	105	Fail
12	Create a KIT as LBSKIT and assign these 2 items to that KIT with Conversion as 1:1
13	Sell 5 of this KIT	-5	101	101	101	101	Pass
14	Return 2 KIT with reason as Incorrect Item / Wrong Size	2	103	103	103	101	Fail

Audit Notes:

Edited by sanjay on 18/12/23 11:05. Edited by sanjay on 29/11/23 16:08. Edited by sanjay on 22/11/23 17:16. Edited by vineet on 22/11/23 13:56.

22 Nov 2023

05:16PM Comment 1 by Sanjay (Link Technologies) Case L12976 added to project 15.10

22 Nov 2023

05:18PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 22-11-2023 11:16 PM Time Taken: 12.00 Notes: ETC extended from: 22/11/2023 to 22/11/2023

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

1. The change will be available in version: 15.10

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

Transaction Type "Returns" does not trigger the valuation of the item if the "Return to Stock" checkbox is enabled on the "Return Reason". This has been corrected.

3. Affected Areas:

Valuation. The workaround is to manually enable Valuation which can be done at the Period, Location, or Item level.

4. The issue was caused by:

Valuation Design Flaw

5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT and Patch for V14.9 and V15.00

27 Nov 2023

12:20PM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 27-11-2023 05:14 PM Time Taken: 6.00 Notes: ETC extended from: 22/11/2023 to 27/11/2023

The following tests were performed:

Test Setup Instructions:

Standard Demo Environment

Table 1 - Test Results

No	Test Case	Expected Result	Pass/Fail	Comments
1	Perform a sale of ITEM SS001 in SEPT 2023	Valuation should be triggered for period 2023 Month 9	Pass
2	Sell item SS001 with backdated to Jan 2023	Valuation should be triggered for all months in 2023	Pass
3	Return an item in SEPT 2023 with Return Reason that does not place item back in stock	Valuation should not be triggered	Pass
4	Return an item backdated to June 2023 with a return reason that required items be returned to stock	Valuation should be triggered for 2023 periods 6 +	Pass

Environment Details

OS version: Win11
Application version: 15.10 and Patch 14.90 and 15.00
Setup on:
1. Server: LinkQA4
2. Database: LinkSOFT
3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
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: L12976 in the subject line of all emails regarding this issue.

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