Company: Link Technologies
Case No: L12922. Project: 15.10: LinkSOFT Version 15.10
Logged By: Vineshwar Prasad (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 06 Jul 2023 03:24PM
Priority: Medium
Product: Point of Sale
Group: Enhancement
Time Taken: 14.00 (Weight: 24.00)
Assigned To: Sanjay (Link Technologies)
Circulation: Sanjay, Vineshwar Prasad
Resolve By: Friday, 17 November 2023 11:31 AM [300 days since logged date]
Status: Closed
Subject: Users can Post a Purchase Order for an Obsolete Inventory Item
Summary:    
1. Problem Details

Users can Post a Purchase Order for an Obsolete Inventory Item. This updates the Product Master "In-Stock" which then disables the Status field

2. Environment Details

Version - 14.90.230621.GA

Client - The Daily Stop & Shop

Audit Notes:Edited by sanjay on 29/11/23 16:09. Edited by sanjay on 29/11/23 16:09. Edited by sanjay on 12/10/23 10:16. Edited by sanjay on 30/08/23 15:01. Edited by vineshwar on 14/08/23 14:07. Edited by sanjay on 01/08/23 10:40. Edited by sanjay on 13/07/23 17:29. 
28 Jun 202303:17PM Comment 1 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 29-06-2023 03:04 PM Time Taken: 1.00 Notes: ETC extended from: 28/06/2023 to 29/06/2023
Steps to Replicate the issue;
  1. Create an Inventory Item [T001 - Test Obsolete]
  2. Create a Purchase Order for Item 1 above [PUR00032]
    1. Note
      1. At this stage, we can create an Inventory Adjustment because the Status of the Inventory Item is "Purchase"
      2. At this stage, we can create a Purchase Order because the Status of the Inventory Item is "Purchase"
  3. Submit the Purchase Order
  4. Approve the Purchase Order
  5. Make the Status of the Inventory Item to "Obsolete"
    1. Note
      1. At this stage, we cannot create an Inventory Adjustment because the Status of the Inventory Item is "Obsolete"
      2. At this stage, we cannot create a Purchase Order because the Status of the Inventory Item is "Obsolete"
      3. But we can still change the Status of the Inventory item because the ''In Stock'' is zero
  6. Post the Purchase Order which updated the "In Stock" on Product Master
    1. Note
      1. At this stage, we cannot create an Inventory Adjustment because the Status of the Inventory Item is "Obsolete"
      2. At this stage, we cannot create a Purchase Order because the Status of the Inventory Item is "Obsolete"
      3. At this stage, we cannot change the Status of the Inventory item because the ''In Stock'' is updated
To prevent this issue, we need to check the Status of the Inventory Item on the Purchase Posting stage (Purchase Receive)

Below are the details of the Environment;
  1. URL - https://linktechnologies.com.au/DEMO-LinkSOFT-EDGE
  2. Company - 1001
  3. Inventory Item - T001
  4. Purchase Order - PUR00032

06 Jul 202303:23PM Comment 2 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 07-07-2023 02:01 PM Time Taken: 2.00 Notes: ETC extended from: 29/06/2023 to 07/07/2023
Discussion with Sanjay

To resolve the issue we have to do the following:
  1. Remove the option of ''Obsolete'' from the Status
  2. Add an "Obsolete" flag on the Product Master page
  3. Update related objects to handle the new Obsolete flag

06 Jul 202303:25PM Comment 3 by Sanjay (Link Technologies) Case L12922 added to project 15.00
01 Aug 202310:40AM Comment 4 by Sanjay (Link Technologies) Case L12922 added to project 15.00
12 Oct 202310:16AM Comment 5 by Sanjay (Link Technologies) ETC was changed from 06/07/2023 to 31/10/2023
14 Nov 202312:34PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 17-11-2023 11:31 AM Time Taken: 6.00 Notes: ETC extended from: 31/10/2023 to 17/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):

  1. Added validation during the POSTING stage to raise a flag when items being received have a status of "Obsolete"

3. Affected Areas:

  1. Purchase Receive POST

4. The issue was caused by:

  1. Enhancement

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


17 Nov 202301:57PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 23-11-2023 01:40 PM Time Taken: 5.00
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Create PO for 3 items. Approve. Make 2 items obsolete. Post PO
PO Post should FAIL with message showing the Item Numbers that are obsolete
Pass

2Change the items in 1. above from OBSOLETE to PURCHASE. Post the PO
PO should post and status change to CLOSED
Pass

Environment Details

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

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