Company: Link Technologies
Case No: L10188. Project: 11.40: LinkSOFT Version 11.4
Logged By: Rashna (Edge Business Solutions) on 21 Feb 2019 11:18AM
Priority: Medium
Product: Point of Sale
Group: Enhancement
Time Taken: 23.50 (Weight: 23.50)
Version: 11.3.0902
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay
Resolve By: Friday, 22 February 2019 12:00 AM [1885 days since logged date]
Status: Closed
Subject: Review "Inventory List Audit Trail Report"
Summary:    

The "Inventory List Audit Trail Report" is redundant for the below reasons

  1. Inventory movement is available in the "Inventory Movement Report".
  2. The audit  feature has been added to "Link Web" where users can audit required fields and review results

Next Step

Sanjay and Alvis to analyse case 

Audit Notes:Edited by sanjay on 11/09/19 16:00. Edited by sanjay on 13/03/19 09:01. Edited by alvis on 06/03/19 13:57. 
21 Feb 201911:18AM Comment 1 by Rashna (Edge Business Solutions) Case 10188 added to project 10.2
28 Feb 201911:39AM Comment 2 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 28-02-2019 11:39 AM Time Taken: 1.50
Approved for Version 11

06 Mar 201902:02PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 06-03-2019 02:02 PM Time Taken: 3.50

Development work for this case has been completed.

The change will be available in version: 11.0.0306

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

  1. Renamed report to "Inventory Movement Audit Report"
  2. Refactored report to use the standard framework
  3. Reviewed process "POS001" and refactored procedure.

2. The issue was caused by:

  1. Improvement

3. Next Step:

  1. UAT

4. Notes:


11 Mar 201902:22PM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 12-03-2019 12:00 AM Time Taken: 3.50
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

Validate that the report name has been updated to "Inventory Movement Audit Report".

The report labels should be consistent with the report filters.

Pass
2

Enable POS001 and validate the below

  1. Process an "Adjustment IN" with quantity as 10 for item "PNT01". The report should be updated with the update and the "Reference" updated with the "Adjustment Number".
  2. Process an "Adjustment OUT" with quantity as 3 for item "PNT01". The report should be updated with the update and the "Reference" updated with the "Adjustment Number".
  3. Process a "Stock Take" with quantity as 8 for item "PNT01". The report should be updated with the update and the "Reference" updated with the "Stock Take Number".
  4. Process a "Purchase Order" with quantity 2 as for item "PNT01". The report should be updated with the update and the "Reference" updated with the "Purchase Number" 
  5. Create a "Transfer Out" with quantity 4 as for item "PNT01". The report should be updated with the update and the "Reference" updated with the "Transfer Number".
  6. Create a "Transfer IN" with quantity 4 as for item "PNT01". The report should be updated with the update and the "Reference" updated with the "Transfer Number" 
Pass
3Update the stock for PNT01 to 11 from SQL. This should be reflected in the reportPass
4Users should be able to generate the report for date and specific time

Failed.

Generating the report with a date filter does not print results/

5

Add a space between "Using Process" under "Report Notes".




Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 11.0.308
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT_REPORTNOTES

Steps to reproduce failed scenarios: N/A

Next Step: for correction


    14 Mar 201902:08PM Comment 5 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 14-03-2019 02:08 PM Time Taken: 2.50

    Development work for this case has been completed.

    The change will be available in version: 11.0.0314

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

    1. Corrected date filter
    2. There is a space between the words which is visible if you zoom 150%.

    2. The issue was caused by:

    1. Date and Time filter was not implemented/

    3. Next Step:

    1. UAT

    4. Notes:


    15 Mar 201902:46PM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 15-03-2019 02:46 PM Time Taken: 2.50
    Hi Sanjay
    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

    Users should be able to generate the report for a date.

    1. Item A003 has a sale transaction for date 21/09/2018.
    2. Process an "Adjustment In" for the date 15/03/2019.
    • Generate the report for the year 2019 - 01/01/2019 to 31/12/2019 this should print the adjustment in 2 above.
    • Generate the report for the year 2018 - 01/01/2018 to 31/12/2018 this should print the sale in 1 above.
    • Generate the report for 15/03/2019 this should print the adjustment in 2 above.
    • Generate the report for 21/09/2018  this should print the sale in 1 above.
    		Pass
    2

    Users should be able to generate the report for a time.

    Processed sale of item 0679920073 at below times

    1. 15/03/2019 11:23:09
    2. 15/03/2019 11:40:56
    3. 15/03/2019 11:41:51
    4. 15/03/2019 11:44:00
      • Generate the report from 00 to 10am. This should not print any data.
      • Generate the report from 11 to 13.00. This should print all sales in above
      • Generate the report from 11.40. This should print sales 2 to 4.
      • Generate the report from 14.00. This should not print any data. 
    		Pass

    Environment Details

    1. OS version: Windows Server 2012
    2. Application version: 11.0.0314
    3. Setup: Demo
    4. Server : 10.0.0.14
    5. Database: LINKSOFT_REPORTNOTES

    Next Step: for documentation


      15 Mar 201903:11PM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 15-03-2019 03:11 PM Time Taken: 2.00

      Hi Alvis, 

      In update 11.0.0314, the Transaction Source/Reference column is not updated.

      Steps

      1. Created new product Z001
      2. Enabled process POS001.
      3. Process an adjustment and purchase for the item and review the report

      Figure 1: Report Results

      Thanks


      15 Mar 201903:53PM Comment 8 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 15-03-2019 03:53 PM Time Taken: 2.50

      Development work for this case has been completed.

      The change will be available in version: 11.0.0315

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

      1. Corrected the issue with matching transaction source

      2. The issue was caused by:

      1. The matching function had an incorrect code.

      3. Next Step:

      1. UAT

      4. Notes:


      26 Mar 201904:08PM Comment 9 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 27-03-2019 12:00 AM Time Taken: 2.50
      PA Results
      Tests carried out according to requirements specified on the case header

      Test Results Summary

      Table 1 - Summarised list of issues
      NoTest DescriptionPass/Fail

      Process below transactions for item PNT01. Enable process POS001 and validate the "Source" is updated in the report.

      1. Adjustment IN of 10 at $10.00
      2. Stock Take with count as 20.
      3. Purchase of 5 at $2.50
      4. Transfer of 1 from RETAIL to MAIN
      5. Update the instock using SQL
      		Pass

      Environment Details

      1. OS version: Windows Server 2012
      2. Application version: 11.0.0314
      3. Setup: Demo
      4. Server : 10.0.0.14
      5. Database: LINKSOFT_REPORTNOTES

      Next Step: for documentation


        03 Apr 201910:32AM Comment 10 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 04-04-2019 12:00 AM Time Taken: 1.50

        Hi Sanjay, 

        Documentation updated for the case under BO Inventory -> Reports -> Analytical reports -> Inventory Movement Audit Report

        Thanks
        Rashna


        03 Apr 201904:22PM Comment 11 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 03-04-2019 04:22 PM Time Taken: 1.50
        Thanks Rashna

        09 Oct 201908:14AM Comment 12 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019
        If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L10188 in the subject line of all emails regarding this issue.

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