Minor Live Issue #54023
Sales report | supplier reference updation issue| API shorcuts
| Status: | Closed | Start date: | 12/18/2018 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | 12/18/2018 | |
| Assignee: | Vinu Tomy | % Done: | 100% | |
| Category: | Functionality | Estimated time: | 2.00 hours | |
| Target version: | - | Spent time: | 7.25 hours | |
| DB Changes: | nill | Files Changed: | nill | |
| Keys & Permissions: | Sp change : Usp_GetSalesReport_Hotel | Initial Planned Hours: | 0 | |
| Areas Affected: | nill |
Description
In sales report | Hotel,
1) supplier reference number is not updating.
2) Also in API session need to use shorcuts for APIs
Please find the attachment for reference.
History
#1 Updated by Nithin George over 6 years ago
- Due date set to 12/19/2018
- Status changed from New to Assigned
- Assignee changed from Ratheesh S to Vinu Tomy
- Start date changed from 12/18/2018 to 12/19/2018
- Estimated time set to 2.00
#2 Updated by Ratheesh S over 6 years ago
- Assignee changed from Vinu Tomy to Roshin w
#3 Updated by Ratheesh S over 6 years ago
- Due date changed from 12/19/2018 to 12/18/2018
- Start date changed from 12/19/2018 to 12/18/2018
#4 Updated by Roshin w over 6 years ago
- Status changed from Assigned to In Progress
#5 Updated by Roshin w over 6 years ago
- Keys & Permissions set to Sp change : Usp_GetSalesReport_Hotel
Completed point(2) - Displayed shortcut names instead of api name based on the apiid.
sp change : Usp_GetSalesReport_Hotel
Added shortcuts based on apiid:
6 ='HSD'
12 ='HSH'
13 ='HSM'
19 ='HSR'
22 ='CaxHotel'
23 ='OfflineHotel'
27 ='HSG'
33 ='HSP'
37 ='HST'
46 ='HolidayCheck'
53 ='HSA'
64 ='TravelFusionHotel'
68 ='HSW'
if apid is empty or null then " "
#6 Updated by Ratheesh S over 6 years ago
- Status changed from In Progress to Assigned
- Assignee changed from Roshin w to Vinu Tomy
#7 Updated by Vinu Tomy over 6 years ago
- Status changed from Assigned to In Progress
#8 Updated by Roshin w over 6 years ago
- File Minor Live Issue #54023_sp update.sql added
#9 Updated by Vinu Tomy over 6 years ago
- Status changed from In Progress to Fixed not Tested
- % Done changed from 0 to 100
- DB Changes set to nill
- Areas Affected set to nill
- Files Changed set to nill
In some time supplier reference is null in 3otolat we show supplier pnr if supplier reference is null so change in sp to show supplier pnr if supplier reference is null
update procedure Usp_GetSalesReport_Hotel
#10 Updated by Nithin George over 6 years ago
- File deleted (
Minor Live Issue #54023_sp update.sql)
#11 Updated by Nithin George over 6 years ago
- Status changed from Fixed not Tested to QA Released
#12 Updated by Hariprasad s over 6 years ago
Still some of the API reference for offline booking it is empty.
#13 Updated by Hariprasad s over 6 years ago
- File SaleReport.png added
- Status changed from QA Released to Not Fixed
for some of the API reference for offline booking it is empty.
Screenshot attached for reference
#14 Updated by Vinu Tomy over 6 years ago
- Status changed from Not Fixed to In Progress
#15 Updated by Vinu Tomy over 6 years ago
- Status changed from In Progress to Fixed not Tested
Issue was in sales report api for offline hotel is 1000 which is not specified in procedure. Change procedure to reflect it add for api id 100 to show OTH as api since in api details table its code corresponding to 1000 is OTH
#16 Updated by Hariprasad s over 6 years ago
- Status changed from Fixed not Tested to Fixed in Live
#17 Updated by Albin Paul about 6 years ago
- Status changed from Fixed in Live to Closed
- Initial Planned Hours set to 0
Updated in live.