Support #7412

[TPMS_GL084] - ARAB HEALTH 2017 (REPORT SALES)

Added by Siti Norahayu Mohd Desa over 7 years ago. Updated about 7 years ago.

Status:Work Completed-End life cycleStart date:May 02, 2017
Priority:NormalDue date:May 04, 2017
Assignee:Siti Norahayu Mohd Desa % Done:

100%

Category:GO_LiveSpent time:-
Target version:-

Description

Case ID : TPMS/17-0014

The sales for the above event in TPMS is not same with the manual report. To check the currency. It supposed used currency rate February 2017 based on event date.

Please refer the attachment below.

GL084 - ARAB HEALTH 2017 (REPORT SALES).pdf (1.06 MB) Siti Norahayu Mohd Desa , May 02, 2017 10:49

History

#1 Updated by Najmi Pasarudin over 7 years ago

  • Status changed from New - Begin Life Cycle to Development / Work In Progress

#2 Updated by Najmi Pasarudin over 7 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Najmi Pasarudin to Siti Norahayu Mohd Desa
  • % Done changed from 0 to 90

Issue:
Sales not correct for event ARAB HEALTH 2017.

Cause:
Sales currency not correct. Should use currency from February 2017.

Solution:
Run the following script.

-------------------------------------------------------------------------------------------------
/* ARAB HEALTH 2017 */
update fbk_form_tf
set potential_sales_rates = (
select rate from currency_rates where currency = 'USD'
and currdate < (select em_start_date from event_main where em_id = 9188)
and month(currdate) = (select month(em_start_date) from event_main where em_id = 9188)
and year(currdate) = (select year(em_start_date) from event_main where em_id = 9188)
)
where potential_sales_currency = 'USD' and em_id = 9188;

update fbk_form_tf
set actual_sales_rates = (
select rate from currency_rates where currency = 'USD'
and currdate < (select em_start_date from event_main where em_id = 9188)
and month(currdate) = (select month(em_start_date) from event_main where em_id = 9188)
and year(currdate) = (select year(em_start_date) from event_main where em_id = 9188)
)
where actual_sales1_currency = 'USD' and em_id = 9188;
-------------------------------------------------------------------------------------------------

Test scenario:
  1. Access Post-event > Report > Programme
  2. Download Trade Fair report, Event by Sales for ARAB HEALTH 2017.
  3. Expected result, the total sales in Malaysian ringgit should follow currency from February 2017.

#3 Updated by Siti Norahayu Mohd Desa over 7 years ago

  • Status changed from Internal Testing to User Acceptance Test

Send for user testing

#4 Updated by Siti Norahayu Mohd Desa over 7 years ago

  • Status changed from User Acceptance Test to Pending Prod Deployment
  • % Done changed from 90 to 100

Dear Ayu,

Since at testing environment sales not in the USD for ARAB HEALTH 2017, we will test in the production after deployment new war file.

Regards,

Azliza Husain
Application Unit
Information Technology Division,
MATRADE,

Tel (DL) : +603-62077315
Tel(GL) : +603-62077077
Email:

Salam Najmi,

Please prepare migration document and war file for production deployment.

Migration Plan ID: TPMS_ID0024
War File: TPMS_v053

#5 Updated by Najmi Pasarudin about 7 years ago

  • Status changed from Pending Prod Deployment to Work Completed-End life cycle

Also available in: Atom PDF