Critical Live Issue #44173

Sales Report

Added by Sreerag Prasannan almost 7 years ago. Updated over 6 years ago.

Status:ClosedStart date:07/30/2018
Priority:NormalDue date:07/31/2018
Assignee:-% Done:

100%

Category:FunctionalitySpent time:24.50 hours
Target version:-
End_Date:07/27/2018 Areas Affected:
remarks: Files Changed:
DB Changes: Initial Planned Hours:
Keys & Permissions:

Description

In Sales report for Hotel, Make sure the Dates displayed are correct.

Example if an entry is RECONFIRMED on 10th July 2018

And it is REFUNDED TO CUSTOMER on 25th July 2018

and when sales report is taken on 25th JULY, we will not see 2 entries, Now Both entries are seen in same date. Above is an example, please fix for ALL ,REFUNDED to customer status in sales report for Hotel.

Make sure it is fixed in print and export to excel as well.

Date.png (106 KB) Sreerag Prasannan, 07/26/2018 08:28 am

Subtasks

History

#1 Updated by Sreerag Prasannan almost 7 years ago

#2 Updated by Jubin J almost 7 years ago

  • Due date set to 07/26/2018
  • Status changed from New to Assigned
  • Assignee set to Vinu Tomy

#3 Updated by Vinu Tomy almost 7 years ago

  • Status changed from Assigned to In Progress

#4 Updated by Ratheesh S almost 7 years ago

  • Due date changed from 07/26/2018 to 07/27/2018

#5 Updated by Vinu Tomy almost 7 years ago

  • % Done changed from 0 to 50

.Change procedure of hotel sales report in refund to customer case to show date of booking date as booked done date and refund to customer date as refund done date.Do it in refund to customer cases.
.In case of all status duplicate row is creating in code so we have to find another solution to show date of booked for booked status and refund to customer for customer status.

#6 Updated by Vinu Tomy almost 7 years ago

  • Status changed from In Progress to Fixed not Tested
  • % Done changed from 50 to 100
  • End_Date set to 07/27/2018
  1. Change procedure for all status for hotel to get booking date of the transaction in case of refund to customer.
  2. Added a procedure 'Usp_GetSalesReport_HotelAllStatus' to get details of transaction which refund to customer status is not in selected range but booked is with in the selected range
  3. Change in code side to add selected booked items from procedure to all status table.
  4. Checking the new publish release.

#7 Updated by Sreerag Prasannan almost 7 years ago

  • Status changed from Fixed not Tested to Not Fixed

Issue still exist , in Staging, Passed connection string to Mr Vipindas

#8 Updated by Vinu Tomy almost 7 years ago

  • Status changed from Not Fixed to In Progress

#9 Updated by Vinu Tomy almost 7 years ago

.Tested with live database date range showing is correct.Issue not showing refund to customer is conversion of provider price and date range filter.Date range issue fixed and need to fix the conversion and check the date is coming is correctly

#10 Updated by Vinu Tomy almost 7 years ago

  • Status changed from In Progress to Fixed not Tested

1.Updated the sp Usp_GetSalesReport_Hotel to change conversion of provider price to varchar
2.Check data in coming in given date rnage and reconfirmed and refund to customer date is showing correctly.

#11 Updated by Sreerag Prasannan over 6 years ago

  • Status changed from Fixed not Tested to Closed
  • Assignee deleted (Vinu Tomy)

delivered to Live

Also available in: Atom PDF