Bug #40546

Sales report issue

Added by Albin Paul almost 7 years ago. Updated almost 7 years ago.

Status:ClosedStart date:06/02/2018
Priority:NormalDue date:06/04/2018
Assignee:-% Done:

100%

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

Description

Sales report not working.Only results are showing for hotel and transfers properties.If we select long date and all property type then some error is shown in result.Make sure reports are working correctly for all properties.

Screenshot from 2018-05-31 18-46-13.png (161 KB) Albin Paul, 05/31/2018 04:19 pm

Screenshot from 2018-05-31 18-46-10.png (222 KB) Albin Paul, 05/31/2018 04:19 pm

History

#1 Updated by Vipin das almost 7 years ago

  • Due date set to 06/02/2018
  • Status changed from New to Assigned
  • Assignee set to Jils Thomas
  • Start date changed from 05/31/2018 to 06/02/2018

#2 Updated by Jils Thomas almost 7 years ago

  • Status changed from Assigned to In Progress

#3 Updated by Jils Thomas almost 7 years ago

  • Status changed from In Progress to Need more info
  • Assignee changed from Jils Thomas to Albin Paul
  • % Done changed from 0 to 40
  • Error page issue solved for 'All' property; updated in stored procedure (SalesRegisterReportForPropertyTypeAll)
  • Please clearly mention issues of all other properties and statuses (with scenarios).

#4 Updated by Albin Paul almost 7 years ago

  • Status changed from Need more info to In Progress
  • Assignee changed from Albin Paul to Jils Thomas

Property Transaction Status

Flight -All
-Ticketed
-Refunded

Sports -All

These are the properties and Transaction Statuses need fix.

#5 Updated by Vipin das almost 7 years ago

  • Due date changed from 06/02/2018 to 06/04/2018

#6 Updated by Jils Thomas almost 7 years ago

  • Status changed from In Progress to Fixed not Tested
  • % Done changed from 40 to 100
  • End_Date set to 06/04/2018
  • Mentioned issues are solved

Please execute and verify that the transaction types are available in the "TransactionTypes" table with the help of support team

insert into TransactionTypes values(1,'Flight',0)

#7 Updated by Sreerag Prasannan almost 7 years ago

  • Status changed from Fixed not Tested to Closed
  • Assignee deleted (Jils Thomas)

issue fixed.

Also available in: Atom PDF