Company: Link Technologies
Case No: L12569. Project: 13.03: LinkSOFT version 13.03
Logged By: Vineshwar Prasad (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 09 Sep 2021 01:23PM
Priority: Medium
Product: Point of Sale
Group: Software Defect
Time Taken: 8.50 (Weight: 12.00)
Version: 13.03.0917
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay, Vineshwar Prasad
Resolve By: Friday, 10 September 2021 11:59 PM [959 days since logged date]
Status: Closed
Subject: Query on Inventory Movement Report
Summary:    
1. Problem Details

Shalvin advised that they are having internal Audits and need to generate the Inventory Movement Report for a Date Range for all the Inventory Items

Example: From 01/01/2020 - To 01/01/2020
Audit Notes:Edited by sanjay on 13/10/21 10:53. Edited by sanjay on 10/09/21 14:17. Edited by sanjay on 10/09/21 11:27. 
06 Sep 202103:28PM Comment 1 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 09-09-2021 03:21 PM Time Taken: 1.00 Notes: ETC extended from: 07/09/2021 to 09/09/2021
Bula Team,

We had a discussion over the phone and we have advised that the Report is used for a specific Product. Generating the report without any Product Code will not run.

However, they need to generate the report for Audit purposes. We have set up an environment internally;
  1. Server - LINKQA4
  2. Database - CLIENT-TAPPOOCHEMIST-LINKSOFT
  3. Version - 13.02.0903.GA

We will discuss this internally and advise.

Regards
Vineshwar Prasad


09 Sep 202101:26PM Comment 2 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 10-09-2021 03:24 PM Time Taken: 0.50 Notes: ETC extended from: 09/09/2021 to 10/09/2021
Development Meeting: Alvin, Sitla, Rashna & Vineshwar

Case assigned to the development team to check for perfomance improvement.

10 Sep 202111:27AM Comment 3 by Sanjay (Link Technologies) Case L12569 added to project 13.0X
10 Sep 202102:15PM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 14-09-2021 04:14 PM Time Taken: 6.00
PART A - Development work for this case has been completed.

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. Refactored procedure and finetuned indices to allow the report to run efficiently

3. Affected Areas:

  1. Inventory Movement Report

4. The issue was caused by:

  1. Large Volume data performance tuning was not done

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


10 Sep 202102:17PM Comment 5 by Sanjay (Link Technologies) ETC was changed from 10/09/2021 to 10/09/2021
13 Sep 202110:49AM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 14-09-2021 12:18 PM Time Taken: 1.00
The following tests were performed:

Table 1 - Test Results
#Test Case DetailsPass/FailComments
 1
  1. Generate the "Inventory Movement Report" for date 01/01/2020 and Location "PH1".
 Pass
  1. Report Time - 4 mins and 17 seconds
  2. Pages - 335

Environment Details

  1. OS version:
  2. Application version:13.03.0910 RC1
  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


13 Sep 202102:14PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 14-09-2021 04:14 PM
Thanks Rashna

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

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