Company: Link Technologies
Case No: L12159. Project: 12.30: LinkSOFT Version 12.30
Logged By: Sanjay (Link Technologies) on 15 Feb 2021 01:49PM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 20.00 (Weight: 20.00)
Version: 12.30
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay
Resolve By: Friday, 19 February 2021 11:59 PM [1375 days since logged date]
Status: Closed
Subject: Kit Items cost calculations can result in incorrect values
Summary:    

Kit items are items that have one or more sub items made up of "Purchased/Misc' items from inventory. There is a configuration that allows Kit Item COSTS to be updated via a trigger when a "Kit Component" is added to a Kit.

There are a few issues with this model:

  1. If a location is added after a kit component is added, the location gets a ZERO cost as the trigger is not fired until the kit component is added
  2. Inventory valuation will be incorrect as the kit item itself is a NON STOCK ITEM
  3. Inventory Sales may result in an incorrect item cost for kit items depending on the order in which the kit items were added/edited

To resolve the issue, we are redesigning the Kit items as follows:

  1. Kit items are non-stock items (we will change this in a future release where we allow Kit items to be packaged and sored as "Stock" by increasing the KIT stock and reducing the respective "Purchased" items
  2. Kit items COSTS will be calculated from the Kit Components 
  3. Add/Edit Kit items will prevent users from updating cost fields as we are using component costs
  4. Kit Costs will be a calculated number based on its components
  5. Remove Triggers that are updating Kit Costs
  6. Remove Configuration "AutoUpdateKitCost"
Audit Notes:Edited by sanjay on 17/02/21 13:33. 
16 Feb 202109:17AM Comment 1 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 16-02-2021 03:10 PM Time Taken: 16.00 Notes: Edited by sanjay on 16/02/21 09:18. 

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

1. The change will be available in version: 12.30.0215

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

  1. The following changes have been completed:
    1. Kit items "COST" calculated from the Kit Components. The items cost method is used to sum up the Kit cost
    2. Prevent editing COSTS for Kit items as we are using component costs
    3. Kit Costs will be a calculated number based on its components
    4. Remove Triggers that are updating Kit Costs
    5. Remove Configuration "AutoUpdateKitCost"
    6. Changed reports showing Kit Items cost to use Component Cost
  2. Added kit items to WEB Invoicing

3. Affected Areas:

  1. Web invoicing
  2. Product Master Maintenance
  3. Reports showing Kit Cost

4. The issue was caused by:

  1. Correction to Inventory Valuation and Reports showing Kit Cost

5. Notes
6. Next Step
: UAT

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

PART B - Development Reference:

1. Changes implemented was according to the approved design (Y/N): Y - One additional change included that was not in the approved specification  (PART A, item 2.2

2. Variations to the approved design: Yes


17 Feb 202101:33PM Comment 2 by Sanjay (Link Technologies) ETC was changed from 19/02/2021 to 19/02/2021
19 Feb 202103:30PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 19-02-2021 07:56 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

Create 3 parent items as below

CodeCost TypeCost
P00001Last Cost3
P00002
Last Cost4
P00003Standard Cost5.50
Pass
2

Create 3 kit Items as below. Validate the expected kit cost matches system cost

CodeCost TypeKit ComponentConversionExpected Kit Cost
P00004
Last Cost
P00001
P00001 = 1
6
P00005
Last Cost
P00001, P00002

P00001 = 1
P00002 = 2

11
P00006
Last Cost
P00001, P00002, and P00001

P00001 =1
P00002 = 2
P00003 = 3

27.50
Pass
3Process a sale for item P00005 from Link web. The sale should be completed without errorsPass
4

Validate that the kit cost is correctly reflected in the below reports

  1. Inventory Master Listing
  2. Inventory Cost Listing
  3. Inventory Listing
  4. Inventory Sell Price Listing
Kits items are not printed in the "Inventory Cost Listing" report

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 12.30.0219BETA
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-123

Next Step

  1. For Review

    22 Feb 202102:29PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 22-02-2021 08:19 PM Time Taken: 2.00
    Hi Rashna, we have updated the "inventory Cost report" to state:

    Kit Items do not appear in this report as it is a non-stock item.

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

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