Company: Link Technologies
Case No: L12305. Project: 12.44: LinkSOFT Version 12.44
Logged By: Vineshwar Prasad (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 02 Jul 2021 02:39PM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 15.00 (Weight: 20.00)
Version: 12.44.0709
Assigned To: Sanjay (Link Technologies)
Circulation: Rashna, Sanjay, Vineshwar Prasad
Resolve By: Friday, 16 July 2021 11:59 PM [1027 days since logged date]
Status: Closed
Subject: Purchase Order Received at zero quantity updates the Cost to zero when Costing method is Last Cost
Summary:    
1. Problem Details

Purchase Order received at zero quantity updates the Cost to zero when costing method is "Last Cost".

2. Error Message (Include screenshot of the error)



3. Environment Details

Application Hosted on: http://linktechnologies.com.au/DEMO-LinkSOFT
Company
 Link Technologies - Demo
Version
 12.43.0630.GA

4. Other Relevant Information

Users prepare Purchase orders for multiple items. Delivery is done Partially on one Purchase Order. When any item on the Purchase Order is not received, the quantity field is edited to zero and other items are received. Zero quantity inserts transaction in Inventory Valuation which makes the last cost to zero. Sales Transactions are then recorded at zero cost.

The issue can be reproduced by performing the following:
  1. Create Inventory Item1
    1. Code - Item001
    2. Cost Method - Last Cost
  2. Create Inventory Item 2
    1. Code - Item002
    2. Cost Method - Last Cost
  3. Create Purchase Order 1
    1. Line 1 - Item001
      1. Quantity - 10
      2. Cost - $10.00
  4. Fully Receive Purchase Order 1
    1. Line 1 - Item001
      1. Quantity - 10
      2. Cost - $10.00
  5. Valuation for Item001: 10 x $10.00 = $100.00
  6. Create Purchase Order 2
    1. Line 1 - Item001
      1. Quantity - 20
      2. Cost - $20.00
    2. Line 2 - Item002
      1. Quantity - 10
      2. Cost - $10.00
  7. Partial Receive Purchase Order 2
    1. Line 1 - Item001
      1. Quantity - 0
    2. Line 2 - Item002
      1. Quantity - 10
      2. Cost - $10.00
  8. Valuation for Item001 = $0.00
-----------------------------------------------------------------------
--- TO BE COMPLETED AFTER THE CASE HAS BEEN RESOLVED ---
Has the problem been solved?:

Steps that were taken to resolve the issue:

Has the final solution review been done with the customer? (Yes/No)  Notes from discussion with the customer:
Audit Notes:Edited by sanjay on 09/07/21 10:59. Edited by sanjay on 09/07/21 10:56. Edited by sanjay on 09/07/21 08:12. Edited by sanjay on 08/07/21 14:58. 
08 Jul 202102:58PM Comment 1 by Sanjay (Link Technologies) Case L12305 added to project 12.43
08 Jul 202103:06PM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 09-07-2021 08:58 PM Time Taken: 3.00

Workshop with Rashna, Vineshwar and Sanjay. 

Reviewed the current process and identified that the following changes need to be applied:?

  1. Item cost should not be affected by Inventory Receipts when quantity is zero
  2. Item LAST COST is only updated when Received Qty > 0
  3. Item is not sent for Valuation is when Received Qty = 0?

Note: FOC Items receipts will affect Average Cost only - which is the current behaviour



08 Jul 202105:13PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 08-07-2021 09:06 PM Time Taken: 11.00
PART A - Development work for this case has been completed.

1. The change will be available in version:12.43.0708

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

  1. Corrected PO Post-procedure to exclude Last Cost Update when Qty Received is zero
  2. Corrected Approval List acquisition when Deleted Approval Users exist
  3. Corrected Valuation initiation when quantity received is zero

3. Affected Areas:

  1. Inventory Valuation - Items should not be valued when Received Qty is Zero
  2. PO Approval failed to list items when deleted approvers exist
  3. PO Post updated the last-cost incorrectly

4. The issue was caused by:

  1. Programming fault

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


09 Jul 202108:12AM Comment 4 by Sanjay (Link Technologies) Case L12305 added to project 12.44
09 Jul 202110:56AM Comment 5 by Sanjay (Link Technologies) ETC was changed from 03/07/2021 to 03/07/2021
09 Jul 202110:59AM Comment 6 by Sanjay (Link Technologies) ETC was changed from 03/07/2021 to 16/07/2021
12 Jul 202110:45AM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 12-07-2021 03:39 PM Time Taken: 1.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 items as below

  1. Item A with cost method as the "Last Cost"
  2. Item B with cost method as the "Standard Cost"
  3. Item C  with cost method as the "Average Cost"

Post an adjust for the above items with:

  1. Quantity = 10
  2. Cost = 10

Run the valuation for these items. The valuation should be $100 for the 3 items

Pass
2

Create a "Purchase Order" approval workflow with the below users.

  1. E001 - Active approver
  2. E002 - User record in the workflow is deleted.
  3. E003 - The user record is active in the workflow but the user is deleted under "User Maintenance"
  4. E004 - The user record is active in the workflow but the user is not approved under "User Maintenance"
Log in as "John" and create the PO for the 3 items in 1 above with purchase quantity = 5
  1. Login as E001 to approve the PO.
  2. Validate that all items are listed in the approval screen
Pass
3Receive the PO in 2 above with the receiving quantity as 0 for all 3 items. Validate that the cost remains $10.00 for the items
Pass
4Validate that the valuation is not recomputed after receiving the PO in 3 above
Pass

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 12.44.0709GA
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-124

Next Step: 

  1. For Closure

    12 Jul 202111:19AM Comment 8 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 12-07-2021 05:19 PM
    Thanks Rashna

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

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