Major Live Issue #116157
Error in sales report
| Status: | Fixed not Tested | Start date: | 08/02/2021 | |
|---|---|---|---|---|
| Priority: | High | Due date: | 08/02/2021 | |
| Assignee: | Nithin George | % Done: | 100% | |
| Category: | Functionality | Spent time: | 3.00 hours | |
| Target version: | - | |||
| DB Changes: | Usp_GetSalesReport_HotelAllStatus | Files Changed: | CommonProjects\DataProvider\Reports\ReportsDA.cs
CommonProjects\Common\Settings.cs |
|
| Keys & Permissions: | <add key="ShowHotelRefundOutdated" value="true" /> | Initial Planned Hours: | 0 | |
| Areas Affected: | Hotel Sales report |
Description
Facing error in sales report as upon selecting individual agencies the sales report displays results for all agencies instead of selected agency .
Please find the screenshot for reference. also attaching error logs
History
#1 Updated by Prasob KP about 4 years ago
- Tracker changed from Bug to Major Live Issue
#2 Updated by Nithin George about 4 years ago
- Due date set to 08/02/2021
- Status changed from New to Fixed not Tested
- % Done changed from 0 to 100
- DB Changes set to Usp_GetSalesReport_HotelAllStatus
- Keys & Permissions set to <add key="ShowHotelRefundOutdated" value="true" />
- Areas Affected set to Hotel Sales report
- Files Changed set to CommonProjects\DataProvider\Reports\ReportsDA.cs CommonProjects\Common\Settings.cs
issue due to select the outdated refund to customer data from DB, in this case, no agency filter applied. Added a config key and update the function with agency check.
Get sales report details for Hotel booked details for all status in which refund to customer date is outside the selected date range. Need to set the key as true to show the data.
<add key="ShowHotelRefundOutdated" value="true" />
SPo : Usp_GetSalesReport_HotelAllStatus