Critical Live Issue #44598

Invalid Customer Code | LIVE issue

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

Status:ClosedStart date:08/02/2018
Priority:NormalDue date:08/07/2018
Assignee:-% Done:

100%

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

Description

In Sales report Invalid customer Code is coming

Customer code is a field which is existing in "USER " form , edit a user and you will see the customer code section, the value entered here must come in sales report ( if that user has booked ).

Please resolve.

To get issues

1) Log in to Admin

2) proceed to sales report

3) Select hotel and click on All , refunded to customer or Reconfirmed. In all these few cases, the entry is wrong please fix.

Wrong customer code = 99740086 which is being saved and displayed.

Customer code.png (119 KB) Sreerag Prasannan, 08/02/2018 12:31 pm

History

#1 Updated by Vipin das almost 7 years ago

  • Due date set to 08/02/2018
  • Status changed from New to Assigned
  • Assignee set to Jomiya J

#2 Updated by Jomiya J almost 7 years ago

  • Status changed from Assigned to In Progress

#3 Updated by Jomiya J almost 7 years ago

requested live db copy

#4 Updated by Vipin das almost 7 years ago

  • Due date changed from 08/02/2018 to 08/03/2018

#5 Updated by Jomiya J almost 7 years ago

  • Status changed from In Progress to On hold

didn't get live DB Copy so changed to on hold

#6 Updated by Vipin das over 6 years ago

  • Due date changed from 08/03/2018 to 08/06/2018

#7 Updated by Jomiya J over 6 years ago

  • Status changed from On hold to In Progress

#8 Updated by Jomiya J over 6 years ago

  • Status changed from In Progress to On hold

Task hold for Critical Live Issue #44756

#9 Updated by Jomiya J over 6 years ago

  • % Done changed from 0 to 30

#10 Updated by Jubin J over 6 years ago

  • Due date changed from 08/06/2018 to 08/07/2018

#11 Updated by Jomiya J over 6 years ago

  • Status changed from On hold to Fixed not Tested
  • % Done changed from 30 to 100
  • End_Date set to 08/07/2018

UPDATE
ReportData_Hotel
SET
ReportData_Hotel.CustomerCode = userdetails.CorporateId
FROM
ReportData_Hotel
INNER JOIN
userdetails
ON
ReportData_Hotel.CreatedBy = userdetails.UserName
WHERE
ReportData_Hotel.IsOfflineEntry =0

UPDATE
ReportData_Hotel
SET
ReportData_Hotel.CustomerCode = TransactionDetailCustomerCodes.CutomerCode
FROM
ReportData_Hotel
INNER JOIN
TransactionDetailCustomerCodes
ON
ReportData_Hotel.TransactionId = TransactionDetailCustomerCodes.TransactionId
WHERE
ReportData_Hotel.IsOfflineEntry =0

SP
---
Usp_GetSalesReport_Hotel - Change done in

<add name="ConString" connectionString="Server=93.115.29.110;Database=tripnet_livcopy_binsu_30072018;Integrated Security=SSPI;User ID=testvipin;Password=test123;Trusted_Connection=False;" />

#12 Updated by Sreerag Prasannan over 6 years ago

  • Status changed from Fixed not Tested to Not Fixed

Not working in Live Environment

#13 Updated by Sreerag Prasannan over 6 years ago

  • Status changed from Not Fixed to Closed
  • Assignee deleted (Jomiya J)

issue fixed, so issue

Also available in: Atom PDF