Company: Link Technologies
Case No: L12876. Project: 14.80: LinkSOFT Version 14.80 - June 2023
Logged By: Vineshwar Prasad (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 19 Apr 2023 04:00PM
Priority: Medium
Product: Point of Sale
Group: Enhancement
Time Taken: 12.00 (Weight: 12.00)
Assigned To: Not Assigned
Circulation: Navneet Kumar, Sanjay, Vineshwar Prasad
Resolve By: Thursday, 25 May 2023 05:01 PM [365 days since logged date]
Status: Closed
Subject: Enhancement to Data View ''POS - Invoice Listing With Driver Details'' to allow for TIME filters
Summary:    Enhancement to Data View ''POS - Invoice Listing With Driver Details''. Add a Time From and Time To in the selection Parameters

Business Scenario

Company ABC uses LinkSOFT for its Fuel Management. They use the Data View ''POS - Invoice Listing With Driver Details'' to gather fueling details. They have a cutoff time every Monday at 4.00 PM when all Fueling operations are stopped and all Data collected for Payment Processing. They need a Time From and Time To in the selection Parameters to gather all this information.

Data View before 4.00 PM

Record Date

Transaction Number

Customer Code

Vehicle Registration Number

Gang Number

Quantity

Unit Price

Amount

Location

Weigh Slip No

Driver Name

Driver Licence No

14/04/2023 01.06 PM

RC000006

BSP01

HE551

4521-003

32.156

1.599

51.42

Retail Shop

564551

Vineshwar

95210

14/04/2023 01.10 PM

RC000007

BSP01

HE551

4521-003

42.123

1.599

67.35

Retail Shop

6545644

James

65210


Data View after 4.00 PM

Record Date

Transaction Number

Customer Code

Vehicle Registration Number

Gang Number

Quantity

Unit Price

Amount

Location

Weigh Slip No

Driver Name

Driver Licence No

14/04/2023 04.12 PM

RC000008

BSP01

HE551

4521-003

75.0321

1.599

119.98

Retail Shop

32145

Vineshwar Prasad

6622310

14/04/2023 04.13 PM

RC000009

BSP01

HE551

4521-003

99.1

1.599

158.46

Retail Shop

12301

Kunal

12340


Environment Details
  1. URL: http://LINKQA1-EBS/LinkSOFT
  2. Server Name: LINKQA1-EBS
  3. Database Name: LinkSOFT-DEMO
  4. Version: 14.60.0325.GA
Audit Notes:Edited by sanjay on 23/05/23 13:24. Edited by sanjay on 20/04/23 15:59. Edited by sanjay on 20/04/23 15:59. Edited by sanjay on 20/04/23 15:58. 
11 Apr 202302:24PM Comment 1 by Navneet Kumar Assigned To: Navneet Kumar Followup Date: 12-04-2023 02:18 PM Notes: ETC extended from: 12/04/2023 to 12/04/2023

Bula Team,

We have a discussion with Sanjay.

Next Step

  1. Add sample data with entries before and after 4.00PM.
  2. Add environment details.
  3. Arrange a meeting with Sanjay to go through.
Regards
Navneet

18 Apr 202308:02AM Comment 2 by Navneet Kumar Assigned To: Navneet Kumar Followup Date: 28-04-2023 07:32 AM Notes: ETC extended from: 12/04/2023 to 28/04/2023
Bula Team,

Case header has been updated with sample data as discussed in the last meeting.

Next Step:
  1. Arrange a meeting with Sanjay to go through.
Regards
Navneet

19 Apr 202304:02PM Comment 3 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 21-04-2023 04:01 PM Time Taken: 1.00 Notes: ETC extended from: 28/04/2023 to 21/04/2023
Case transferred to the development team

20 Apr 202308:54AM Comment 4 by Sanjay (Link Technologies) Case L12876 added to project 14.80
20 Apr 202303:59PM Comment 5 by Sanjay (Link Technologies) ETC was changed from 21/04/2023 to 31/05/2023
18 May 202312:26PM Comment 6 by Sanjay (Link Technologies) Followup Date: 25-05-2023 11:39 AM Time Taken: 6.00 Notes: ETC extended from: 31/05/2023 to 25/05/2023
PART A - Development work for this case has been completed.

1. The change will be available in version: 14.80

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

  1. Added Time From and Time To in the date range selection of all Data Views

3. Affected Areas:

  1. BI Data views

4. The issue was caused by:

  1. Enhancement

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


18 May 202305:02PM Comment 7 by Sanjay (Link Technologies) Followup Date: 25-05-2023 05:01 PM Time Taken: 5.00 Notes: ETC extended from: 25/05/2023 to 25/05/2023
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Using POS Invoices Data View, Filter records by Time ensuring that all records within a Date/Time combination is filtered correctly
Invoices should filter by time
Pass

Environment Details

  1. OS version: Win11
  2. Application version: 14.80
  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: L12876 in the subject line of all emails regarding this issue.

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