F AND B ASSIST REPORT GENERATING ISSUE - DUPLICATE VALUES/ENTRIES IN REPORT.

While generating report the following issues are noted by the Property :

  • Discrepancy in Package Consumption:

    • The report shows that 1048 total packages were consumed, but only 1002 packages were eligible. This means there’s a difference between what was used and what should have been available, which is a problem.

  • Excess Consumption in OPERA:

    • Some rooms are showing more consumption than they were allocated or assigned in the OPERA system, which tracks room and guest data. This might indicate that the system isn't accurately reflecting the number of packages used by those rooms.

  • Duplicate Room Entries:

    • There are duplicate entries for some rooms, such as Room 0925. This could mean the same room is listed more than once, causing potential confusion in the report.


For a specific room number 0928 which is a sharing room (0925,0926,0927,0928) and the primary room is 0928.
The roomno 0928 totally has 8 adults, but when we used fetch reservation using postman the adult counts were16 and and getbreakfast info was 8, which is not matching.


This all must be because of duplicate values.

So the fix was to delete the entries of reservation number , reservationnameid and room no one prior to the day after checkout.

after that the duplicates were no more found and was able to fetch breakfast info and reservation using postman which both values were same. This verifies the duplicate values no more reflecting and deleted and showing the exact values.


So we scheduled a Job which runs this.

ALTER PROCEDURE [dbo].[Usp_DeleteReservationDetails]
@CheckOutDate DATETIME =null
AS
BEGIN

 

 

  update  tbReservationDetails   set ReservationNameID='',RoomNo='',ReservationNo=''  where (CONVERT(DATE,CheckOutDate) < CONVERT(DATE, DATEADD(DAY, -1, NULLIF(@CheckOutDate,getdate())))) and ReservationNameID!=''

 

  if(@@ROWCOUNT>0)

  SELECT [ResponseCode],ResponseMessage FROM [tbResponseMessageMaster] WHERE [ResponseCode] = '1007'

 

  else
  SELECT [ResponseCode],ResponseMessage FROM [tbResponseMessageMaster] WHERE [ResponseCode] = '1006'

 

END