Z-Archive » MATRADE - TPMS UAT Conditional Sign-off

hi najimi,

kindly please help

Jeng Wei,
Please check this task with your current task. I noticed there are duplicate issues.

Hi ayu,

4)ast Fact - No. of Programme By Status

#fix display reports in descending order

5)Reports - Programme by Region and Country

#to enhance proper color design (design provided by MATRADE)
#to check data, the correct Country in the Region
#to display currency (RM) --> this report didn't no have any currency (RM)

6) Reports - Programme by Multiple Location
#fix display data that have multiple location only, activity with 1 location no need to be shown

1. fix display reports in descending order

1. fix enhance proper color design (design provided by MATRADE)
   #fix check data, the correct Country in the Region
   #to display currency (RM) ---> no related in this report...

1. fix not display data that doesn't have value (RM0.00)

Please test it after deployed...Thanks you

Hi Leo,
Kindly assist to test.

4. Fast Fact - No. of Programme By Status
a) shall display reports in descending order
b) shall display programme based on status : for MATRADE (CONFIRMED, TENTATIVE, CANCELLED, COMPLETED, POSTPONE), for NON-MATRADE (CONFIRMED, CANCELLED, COMPLETED, POSTPONE)

8. Reports - Sales Generated by Region and Country
a) to display currency (RM)

Hi leo,

1. this is the report need to add field to filter matrade or non matrade for generate reports ?

8. Reports - Sales Generated by Region and Country
a) to display currency (RM) ---> fixed.

Please retest after deployed....Thanks a lot ....

4. Fast Fact - No. of Programme By Status
b) shall display programme based on status : for MATRADE (CONFIRMED, TENTATIVE, CANCELLED, COMPLETED, POSTPONE), for NON-MATRADE (CONFIRMED, CANCELLED, COMPLETED, POSTPONE) --> not yet fixed

hi ayu ,

4. Fast Fact - No. of Programme By Status
b) shall display programme based on status : for MATRADE (CONFIRMED, TENTATIVE, CANCELLED, COMPLETED, POSTPONE), for NON-MATRADE (CONFIRMED, CANCELLED, COMPLETED, POSTPONE) ----> Fixed.

As what we discussed before, The meaning for matrade n non-matrade are pointing Internal or external User. Please use different user for login.
Enhancement task not deployed To current tpms system. Thanks you.

Hi leo,
Kindly assist to test using http://172.25.96.136/matrade-tpms. tq

attached is the test result
thank you

5/4/2016 - Send for SIT/UAT via email dated Wed, Feb 15, 2016. Resend for retest.

Hi Jeng Wei,
Kindly fix on issue below. Thank you

12/4/2016 [Helmi]:-

• Shall display reports in descending order

- all fast fact report for year 2015, displayed 113 as no. of event, but at this report its 209. Please recheck
- change "Programme Status - (2015)" to "No. of Programme by Status - (2015)"

• to enhance proper color design - in excel report its not in color format
• to display currency (RM) - not applicable as this report only display no of programme

• Shall display reports in descending order

- in excel report. To recheck cell merge as country with long name will affect table merge setting. E.g. report 2015. country name IRAN, ISLAMIC REPUBLIC OF,
- to recheck cell merge setting, when auto arrange cell margin, its not in table format

• to enhance proper color design ->in excel report its not in color format
• to check data, the correct Country in the Region -> country name is not displayed in full (pdf) e.g. "Taiwan,"
• to display currency (RM) -> total value for ASIA, SOUTH-EAST and EUROPE, WESTERN is not displayed

Refer attachment for further references.

Hi Ayu

1. Try to ask user which user they use for login the tpms system. Because this report will be filter based on user type when user login
   INTERNAL user --> report will filter based on (3,50,52,10,51) COMPLETED,CONFIRMED,TENTATIVE,CANCELLED,POSTPONED
   EXTERNAL User ---> report will filter based on (3,50,10,51) COMPLETED,CONFIRMED,CANCELLED,POSTPONED

1. Already enhance proper color design - in excel report
2. kindly confirm with user again regarding the to display currency (RM).

7. Reports - All Generated Sales By Country
#report display reports in descending order based on total sales.
#in excel report. To recheck cell merge as country with long name will affect table merge setting. E.g. report 2015. country name IRAN, ISLAMIC REPUBLIC OF, --> database issues.

8. Reports - Sales Generated by Region and Country
#Already enhance proper color design ->in excel report its not in color format
#Was fix the data issues.

kindly please retest after deployed. Thanks a lot

HI Jeng Wei,

Feedback from Helmi as below:-

4. Fast Fact - No. of Programme By Status

EXTERNAL User ---> report will filter based on (3,50,52,10,51) COMPLETED,CONFIRMED,CANCELLED,POSTPONED,TENTATIVE.

Hi Ayu ,

4. Fast Fact - No. of Programme By Status
      I was changing the external user (3,50,52,10,51) COMPLETED,CONFIRMED,CANCELLED,POSTPONED,TENTATIVE. Please retest after deployed(Enhancement).

4. Fast Fact - No. of Programme By Status
External user (3,50,52,10,51) COMPLETED,CONFIRMED,CANCELLED,POSTPONED,TENTATIVE.

Tested & Passed. Fast Fact Report No. of Programme By Status display COMPLETED,CONFIRMED,CANCELLED,POSTPONED,TENTATIVE status.

7. Reports - All Generated Sales By Country
In excel report - to recheck cell merge setting, when auto arrange cell margin, its not in table format.* As discussed, kindly fix.*

Hi Haidah,

Was fixed the column merge cell. please check with this . Thanks

12/5/2016 - number of event is stilll not tally between those mention report (`- all fast fact report for year 2015, displayed 113 as no. of event, but at this report its 209.)

- Please add all MATRADE event to the report as below:-

1. NO. OF PROGRAMME BY MINISTRY
2. NO. OF PROGRAMME BY SECTOR
3. NO. OF PROGRAMME BY TYPE OF PROGRAMME
4. NO. OF PROGRAMME BY MONTH

Hi ayu,

*requested the include MATRADE event to the report as below
Fast Fact:

NO. OF PROGRAMME BY MINISTRY
NO. OF PROGRAMME BY SECTOR
NO. OF PROGRAMME BY TYPE OF PROGRAMME
NO. OF PROGRAMME BY MONTH

root/cause: query filtering JPPPA Data only(*previous)
solution : remove the em_approve for include the matrade data.
Please check data with system PlanningJPPPA. I Will deployed around 2pm. Thanks a lot.

Hi Jeng Wei,

Kindly fix below issue also.

1. Fast Fact - No. of Programme By Status
- change "Programme Status - (2015) " to "No. of Programme by Status - (2015)" (refer attachment)

2. Reports - All Generated Sales By Country
- Shall display reports in descending order -> in excel report. To recheck cell merge as country only uses one cell row but sales generated use 2 cell row. This will be problematic when we auto-resize cell height in excel (refer attachment)

Hi Ayu,

1. Fast Fact - No. of Programme By Status
- Was change "Programme Status - (2015) " to "No. of Programme by Status - (2015)"

2. Reports - All Generated Sales By Country
- Shall display reports in descending order > in excel report. To recheck cell merge as country only uses one cell row but sales generated use 2 cell row. -->Fixed

Please check with this. i will deployed around 4pm. Thanks a lot

25/5/2016 - Reported issue fixed as below. Send to user for retest.
1) all fast fact report for year 2015, displayed 114 as no. of event, but at this report its 209. please recheck
FIXED. All report shall display same value except for "No. of Programme By Sector" due to some of activity does not have the information of Sector.
2) change "Programme Status - (2015) " to "No. of Programme by Status - (2015)"
FIXED.
3) Shall display reports in descending order -> in excel report. To recheck cell merge as country only uses one cell row but sales generated use 2 cell row. This will be problematic when we auto-resize cell height in excel
FIXED.

27/5/2016 [Helmi] - All issue had been successfully retest and closed. Pending for Production Deployment

31/5/16 - Deployed to production - War. File TPMS_v031