Company: Link Technologies
Case No: L08903. Project: 09.40: LinkSOFT Version 9.4
Logged By: Rashna (Edge Business Solutions) on 09 Nov 2017 11:00AM
Priority: High
Product: Point of Sale
Group: Enhancement
Time Taken: 10.00 (Weight: 10.00)
Version: 9.496.1128
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, AwaitingApproval, Development, Rashna, Sanjay
Resolve By: Friday, 10 November 2017 12:00 AM [2372 days since logged date]
Status: Closed
Subject: Improvement to Inventory Promotional Price Setup Report
Summary:    

Hi Team, 

Below are the Improvements that we need on the Inventory Promotional Price Setup Report for clear reporting.

NumberDescriptionJustification Comments for development
1The location filter should not be required for header priceLocation filter should only be mandatory for products with location price. If header price is set, the user does not need to enter in location. Currently, the report is not generated without a location.

Change the title 

Promotional Price Setup for POS Location

2Include Promo Time From and Promo Time To on the reportThe price setup screen has the ability to save the promo times,  however, this is not reflected in the report.Add Feature 
3Include Date Filters on the report

The date filters will allow users to see what products were on promo for a  particular date or period.

For example, PNT01 had promotional price as

1st Promo Price in Jan - 01/12/2016 to 12/12/2016 - New Product

2nd  Promo Price in Dec - 01/12/2017 to 12/12/2017 - Product about to expire.

When we generate the report in Dec 2017, we only see the promo price for dates 01/12/2017 to 12/12/2017.

Users do not know the prior promotional prices. The Date filters will allow users to review all promo prices and update prices with near expiring products accordingly.

Add Feature 


Test plan

TestDescriptionStatus
1Verify report title change. Location is still a required field.

2Promo date and Time on the report


Audit Notes:
10 Jan 201811:12AM Comment 1 by Alvis (Link Technologies) Case 8903 added to project 900
19 Apr 201808:50AM Comment 2 by Sanjay (Link Technologies) Case 8903 removed from project 999
19 Apr 201808:50AM Comment 3 by Sanjay (Link Technologies) Case 8903 added to project 09.4
23 Apr 201803:45PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-04-2018 03:45 PM Time Taken: 2.00
Development work for this case has been completed.
The change will be available in version: 9.4

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

  1. Changed promotional price report to use standard report framework layout
  2. Added Date From and Date To parameters with Time selection

2. The issue was caused by:

  1. NA

    3. Next Step

    1. UAT

    01 May 201802:53PM Comment 5 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 01-05-2018 02:53 PM Time Taken: 1.00

    System test completed.

    Verified the following:

    1. Setup an item with a promotional price.
    2. Ran the report using date filters and verified data. - Failed report did not display the item. Corrected issue in beta2.

    regards
    Alvis


    09 May 201811:25AM Comment 6 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 09-05-2018 11:25 AM Time Taken: 1.00

    System test completed.

    Verified the following:

    1. Setup an item with a promotional price.
    2. Ran the report using date filters and verified data. - Pass

    regards
    Alvis


    11 May 201809:43AM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 14-05-2018 12:00 AM Time Taken: 2.00

    Hi Alvis, 

    I have tested the case. Below is the test results.

    Test Environment

    • Version 9400 Beta 2
    • Database - LINKSOFT on QA1
    • Application on QA1.
    • OS - Windows 7.

    Test Plan

    Test NoDescriptionStatus
    1The Report name should be changed to "Promotional Price Setup for POS Location" Pass
    2Date and Time filter  should be added to the reportPass
    3Set the price for PNT01 on promotion from 02/05/2015 to 23/05/2018. Generate Report for 01/05/2018 to 31/05/2018. The Record should output in the report.Pass
    4Set the price for PNT01 on promotion from 02/05/2015 to 23/05/2018. Generate Report for 02/05/2018 to 23/05/The recordRecord should output in the report.
    		Pass
    5Set the price for PNT01 on promotion from 02/05/2015 to 23/05/2018. Generate Report for  01/06/2018 to 30/06/2018. The record should not output in the report.
    		Failed. The record is in the Report 
    6 Set the price for PNT03 on promotion from 01/04/2018 to 31/05/2018. Promotion Time is 9.30am to 10.30am. Generate the report for dates 01/04/2018 to 31/05/2018 with Time From as 9.00am to 9.30am. The Record should output in the report.Pass
    7Set the price for PNT03 on promotion from 01/04/2018 to 31/05/2018. Promotion Time is 9.30am to 10.30am. Generate the report for dates 01/04/2018 to 31/05/2018 with Time From as 8.00am to 9.00am. The Record should not output in the report.
    		Failed. The record is in the Report
    8Promotion Time should output on the report.Failed. Promo Time is not on the report
    9Records on the report should be clearly laid out and easy to understand.Failed. The "Amount" and "Date" fields in the report are not clear. Refer to Figure 1.

    Figure 1: Report Layout



    15 May 201801:27PM Comment 8 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 15-05-2018 01:27 PM Time Taken: 2.00
    Development work for this case has been completed.
    The change will be available in version: 9.4 Beta3

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

    1. Corrected record selection by date and time format.
    2. Changed report layout to be more readable.
    3. Added time to date from/to columns.

    2. The issue was caused by:

    1. N/A

      3. Next Step

      1. UAT

      24 May 201801:23PM Comment 9 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 24-05-2018 01:23 PM Time Taken: 1.00

      System test completed.

      Verified the layout of the report has been changed.


      25 May 201801:15PM Comment 10 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 28-05-2018 12:00 AM Time Taken: 1.00

      :

      Hi Sanjay 


      This case has been successfully tested.


      Documentation on the case has been completed. Documentation updated under Inventory -- Listing Reports - Inventory Promotional Price Setup.


      Test Environment

      • Version 9400 Beta 3
      • Database - LINKSOFT on QA1. Demo database.
      • Application on QA1.
      • OS - Windows 7.

      Test Plan

      Test No

      Description

      Status

      1

      The Report name should be changed to "Promotional Price Setup for POS Location" 

      Pass

      2

      Date and Time filter  should be added to the report

      Pass

      3

      Set the price for PNT01 on promotion from 02/05/2015 to 23/05/2018. Generate Report for 01/05/2018 to 31/05/2018. The Record should output in the report.

      Pass

      4

      Set the price for PNT01 on promotion from 02/05/2015 to 23/05/2018. Generate Report for 02/05/2018 to 23/05/The recordRecord should output in the report.

      Pass

      5

      Set the price for PNT01 on promotion from 02/05/2015 to 23/05/2018. Generate Report for  01/06/2018 to 30/06/2018. The record should not output in the report.

      		Pass 

      6

      Set the price for PNT03 on promotion from 01/04/2018 to 31/05/2018. Promotion Time is 9.30am to 10.30am. Generate the report for dates 01/04/2018 to 31/05/2018 with Time From as 9.00am to 9.30am. The Record should output in the report.

      Pass

      7

      Set the price for PNT03 on promotion from 01/04/2018 to 31/05/2018. Promotion Time is 9.30am to 10.30am. Generate the report for dates 01/04/2018 to 31/05/2018 with Time From as 8.00am to 9.00am. The Record should not output in the report.

      		Pass 

      8

      Promotion Time should output on the report.

      		Pass 

      9

      Records on the report should be clearly laid out and easy to understand.

      		Pass 

       

      Thanks

      Rashna


      25 May 201802:51PM Comment 11 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 25-05-2018 02:51 PM
      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: L08903 in the subject line of all emails regarding this issue.

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