Company: Link Technologies
Case No: L11730. Project: 10.10: LinkSOFT Version 10.1
Logged By: Alvis (Link Technologies) on 19 Sep 2019 02:11PM
Priority: Low
Product: Point of Sale
Group: Software Defect
Time Taken: 3.00 (Weight: 3.00)
Version: 10.155.0117
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Alvis, Development, Rashna, Ravneet Kumar, Sanjay
Resolve By: Tuesday, 17 September 2019 12:00 AM [1677 days since logged date]
Status: Closed
Subject: Inventory Sell Price Listing Report
Bula Team,

One of our clients was trying to generate Inventory Sell Price Listing Report with Hide Zero Stock set to "Y" so that they can only view the stock available in positive and negative stocks. However, when the Hide Zero Stock filter was used by setting it to "Y", all inventories with zero stock and as well as negative was hidden.

We did some testing internally and we came across the same scenario:

Steps to replicate:

  1. Opened the Inventory Sell Price Listing Report with the filters:
  2. Items from: PT1070
  3. Items to: PT1089
  4. Location: Retail
  5. Generate a report 

Now, generate the report with the Hide Zero Stock set to "Y" filter:
  1. Products: PT1070 & PT1080 should be hidden whereas PT1087 should be displayed
  2. However, the system hides all three of the products
  3. Refer Below:

This has been tested in the demo database of V10.150.

Kindly requesting if you can analyze this and provide a patch for V10.146 as client is on that version.


Audit Notes:Edited by alvis on 19/09/19 14:11. Edited by alvis on 17/09/19 11:08. Edited by alvis on 17/09/19 11:08. 
17 Sep 201911:00AM Comment 1 by Alvis (Link Technologies) Case 11730 added to project 10.151
17 Sep 201911:03AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 17-09-2019 11:03 AM Time Taken: 2.00

Development work for this case has been completed.

The change will be available in version:10.151

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

  1. Changed the report extraction procedure to correct the "Hide Zero Stock" filter to include negative stock when selected

2. Affected Areas:

  1. "Inventory Sell Price Report" - Hide zero stock filter

3. The issue was caused by:

  1. "Hide Zero Stock" was suppressing zero and negative stock.

4. Notes
5. Next Step

19 Sep 201902:11PM Comment 3 by Alvis (Link Technologies) Case 11730 removed from project 10.151
19 Sep 201902:11PM Comment 4 by Alvis (Link Technologies) Case 11730 added to project 10.151
20 Sep 201905:16AM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 20-09-2019 05:16 AM 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

Create two products as below

TR001 - Negative Stock with instock as -30.

TR002 - Zero Stock 

2Generate the "Inventory Sell Price Listing"report without selecting the "Hide Zero Stock"filter. Both items in 1 above should be printed. Pass
3Generate the "Inventory Sell Price Listing"report without selecting the "Hide Zero Stock"filter as "Yes". Items TR0002 above should be printed. 
4Generate the "Inventory Sell Price Listing"report without selecting the "Hide Zero Stock"filter as "No". Both items in 1 above should be printed. 

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 110.151
  3. Setup: Demo
  4. Server :
  5. Database: LINKSOFT-DEMO-10-RASHNA

Next Step

  1. Closure

    If you have any queries regarding this support incident, please email and include the Case No: L11730 in the subject line of all emails regarding this issue.

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