Company: Link Technologies
Case No: L12371. Project: 13.03: LinkSOFT version 13.03
Logged By: Rashna (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 19 Aug 2021 02:27PM
Priority: High
Product: Point of Sale
Group: Enhancement
Time Taken: 26.00 (Weight: 32.00)
Version: 13.03.0917
Assigned To: Sanjay (Link Technologies)
Circulation: Rashna, Sanjay, Sitla, Vineshwar Prasad
Resolve By: Sunday, 12 September 2021 11:59 PM [1190 days since logged date]
Status: Closed
Subject: Ability to edit "Inventory Valuation" COST in Batch Mode
Summary:    

Hi Sanjay 

As per the development meeting on 19/08/2021 with Sanjay, Alvis, Sitla, Vineshwar, and Rashna.

  1. We have introduced the option to edit the cost in Valuation - Refer to case L12342.
  2. However, it was identified in client databases there are a large number (400 records) of records that need to be updated,
  3. Hence, we request an option to edit the cost using a utility that can update the cost in bulk.
Audit Notes:Edited by sanjay on 13/10/21 10:54. Edited by sanjay on 10/09/21 14:13. Edited by sanjay on 10/09/21 08:22. Edited by sanjay on 06/09/21 14:47. Edited by sanjay on 25/08/21 13:24. Edited by rashna on 19/08/21 14:27. 
06 Sep 202102:47PM Comment 1 by Sanjay (Link Technologies) ETC was changed from 20/08/2021 to 30/09/2021
06 Sep 202103:05PM Comment 2 by Sanjay (Link Technologies) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 06-09-2021 07:01 PM Time Taken: 1.00 Notes: ETC extended from: 30/09/2021 to 06/09/2021

Hi Vineshwar, I had a look at this request.

Resetting the inventory Valuation is a high-risk change, it is something that we do one-off when there is an issue in the system. 

Since this is a one-off reset, we should treat this as a consulting exercise and script this update instead of building a utility for this.

This functionality can also raise Audit concerns about our applications ability to reset valuation.

If you need us to reset KS data, place the DB on QA4 and I can get you a script to reset the valuation as one off-script.


08 Sep 202104:49PM Comment 3 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 09-09-2021 08:40 PM Time Taken: 2.00 Notes: ETC extended from: 06/09/2021 to 09/09/2021
Hi Sanjay,

Yes, we should not be editing the Valuation detail lines.

As for the issue, I have gathered details from the following client databases which have similar issues where the Valuation is calculated even when the SOH is zero;

Client

Server

Database

Examples of Items with Issues

Kundan Singh & Sons Holdings Ltd

LINKQA4\CP1

CLIENT-KUNDAN-HQ-LINKSOFT

9414735010950, 9414681500246, 9414681500239, 9310797246439, 9414681200559, 9642142312668, 9403146718470, 9310015242182, 9416216029413, 5555001340204

The Daily Stop & Shop

LINKQA4\CP1

CLIENT-DAILYSTOP-LINKSOFT

Y001, 9421902692123, 7503271500, 942190269243700, 9421902692123, 941445390443200, 941404300102200, 942101452530200, 941468150011600, 9421902692000

Yees Cold Storage Seafood Ltd

LINKQA4

CLIENT-YEES-HQ-LINKSOFT

1005681, 1503110, 1501781, KOSTC006, COWJS001, 1008483, 1009099, 1007320, 1600068

South Pacific Recordings Pte Ltd

LINKQA4

CLIENT-SPR-HQ-LINKSOFT

BB137, TD500MLBASICBLUE, TD500MLMIDGREEN, TRIPOD84, W2160, DF109, 8GB

Nayans Supermarket

LINKQA4

CLIENT-NAYANS-HQ-LINKSOFT

4800016081033, 8906098790842, 2000000010526, 8964000022993, 8906098790859, 9403146392335, 9300605001275, 038000391347

Tappoo City Chemist

LINKQA4

CLIENT-TAPPOOCHEMIST-LINKSOFT

DT02030433, DT01061829, DT02031165, DT01500677, DT01070976, DT05061937, DT02031244, DT01501677

 

Also, will we be reverting the changes done in case L12342.

Regards
Vineshwar

10 Sep 202108:22AM Comment 4 by Sanjay (Link Technologies) Case L12371 added to project 13.0X
10 Sep 202109:46AM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 12-09-2021 01:45 PM Time Taken: 1.00 Notes: ETC extended from: 09/09/2021 to 12/09/2021
Hi Vineshwar, thanks for the update. Seems like we need to add revaluation functionality to address this issue. I will review this and work out a solution.

10 Sep 202110:19AM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 10-09-2021 01:46 PM Time Taken: 14.00
PART A - Development work is in progress

1. The change will be available in version:13.03.0910

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

  1. Added the ability to REVALUE stock for a particular Line, or a location or for the entire period.
    1. Revalue Option will calculate stock value based on current stock cost on inventory Masterfile
    2. Recalculate Option will recalculate the cost based on Qty and Cost - No change to this functionality
    3. Manual Cost Adjustment - will adjust the stock value by passing adjustments to balance the stock value
  2. A log will be kept for each period stating which user action was applied. This can be seen by Expanding the Period in menu "Inventory ~> Valuation"
  3. Revalue can only be done for the LAST CLOSED PERIOD. This limitation is in place as we hold "current cost" in the inventory Masterfile

3. Affected Areas:

  1. Inventory Valuation Process

4. The issue was caused by:

  1. Enhancement

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


Figure 1 - ITEM Revaluation form


10 Sep 202111:08AM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 10-09-2021 02:19 PM Time Taken: 6.00
Added Recalculate and Revalue at Location and Period Levels

10 Sep 202101:19PM Comment 8 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 10-09-2021 05:19 PM Time Taken: 1.00
Assigned for UAT

10 Sep 202102:13PM Comment 9 by Sanjay (Link Technologies) ETC was changed from 12/09/2021 to 12/09/2021
20 Sep 202102:10PM Comment 10 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 20-09-2021 04:55 PM Time Taken: 1.00
The following tests were performed:

Table 1 - Test Results
#Test Case DetailsPass/FailComments
 1
  1. Create an item VI002 with a cost of $8 and a quantity of 100.
  2. Perform valuation validate that value is 800.
 Pass 
 2
  1. Change the cost to $4.6 on the master
  2. Revalue the item. Validate that the value is 460.
 Pass 
 3
  1. Change the valuation to 500 manually. Validate this is reflected in the movement report
 Pass 
 4
  1. Recalculate stock.
 Pass 
5
  1. A log will be kept for each period stating which user action was applied. This can be seen by Expanding the Period in menu "Inventory ~> Valuation"

Pass

6
  1. Revalue can only be done for the LAST CLOSED PERIOD. This limitation is in place as we hold "current cost" in the inventory Masterfile

Pass

Environment Details

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

Next Step: Closure


21 Sep 202109:06AM Comment 11 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 21-09-2021 01:06 PM
Thanks Rashna

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

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