Z-Archive » MATRADE - Trade Promotion Management System (M3-M8) » Module 3 - 9: Internal Testing & System Review » Module 6: Post-event

hi leo;

- Total sales by Product/Service (Data needed)
- By country (Data needed)
- summary of event (Data needed)
- feedback by participant (Data needed)

what meaning by data needed ?

Hi Jeng Wei

based on the discussion,
the reports should have shown some data,
because it also retrieved from previous module,
which already have some data,
For more details, please ask for Najmi assistance

Please kindly assist

hi leo,
TF / SMM / TIM
- Total Sales by event - fixed
- Total Sales by sector - fixed
- List of participating company by event --> stephaince doing , please assign this to stephanice.

1. After dicuss with cheeping and ayu , final conclusion is you have to create data by your own, please discuss with ayu again.
   - Total sales by Product/Service (Data needed)
   - By country (Data needed)
   - summary of event (Data needed)
   - feedback by participant (Data needed)

1. Please specific report type , report , programme type, and which event you are testing, else we are not able to figure the problems.
   - Evaluation by event - fixed
   - Matrade officers Remarks fixed
   SMM outcome - fixed

Search filter
- to disable the date range field

TF / SMM / TIM REPORTS
1. Total Sales by event (Report not generated)
2. Total Sales by sector
- not the correct sector (displayed were product/service)
- the total amount is not correct
- put commas for the amount, monetary format
- SMM report are not generated
- TIM report are not generated
Please refer to the attachment
3. Total sales by Product/Service
- not all product/service is shown
- Product/service code are needed
- put commas for the amount, monetary format
- SMM report are not generated
- TIM report are not generated
Please refer to the attachment
4. By country
- no data shown
- TIM report are not generated
5. List of participating company by event
- Missing report
Stephanie already finish with the JRXML,
6. summary of event
- there are 12 data, but only 3 shown
- not correct company name (not company's full name)
- inappropriate layout
- put commas for the amount, monetary format
- SMM report are not generated
- TIM report are not generated
please refer to the attachment
7. Evaluation by event
- SMM report are not generated
- TIM report are not generated
- did not display all the company
- not correct company name (not company's full name)
8. feedback by participant
- SMM report are not generated
- TIM report are not generated
- did not display all the company
9. Matrade officers Remarks
- SMM report are not generated
- TIM report are not generated
- did not display all the company
- 'FEEDBACK RESPONSE', 'ISSUES', 'COMPLAINTS', 'SUGGESTION' were not shown (for TF)
10. SMM outcome
- please disable the date range field
- report not generated

- to hide 'GENERATE WORD REPORT' for now
Please kindly assist

Added report below. Please retest after deploy.

5. List of participating company by event
- Missing report
Stephanie already finish with the JRXML,

Hi leo,
1. Total Sales by event (Report not generated)
Trade fair report was fixed... event title -> Manufacturing Indonesia ayu 2015
SMM report was fixed -> event title --> SMM on chemical
TIM report was fixed ->event title --> trade n Investment
2.Total Sales by sector
- correct sector
fixed total amount
monetary format display format
-SMM report was fixed
_TIM report was fixed.

3. Total sales by Product/Service
- fix Product/service
- fixedProduct/service code
- display in monetary format
- SMM report was fixed, event title --> SMM on chemical
- TIM report was fixed, event title --> trade n Investment
5. List of participating company by event
TF report was fixed --> event title --> Manufacturing Indonesia ayu 2015
SMM report was fixed -> event title --> SMM on chemical
TIM report was fixed ->event title --> trade n Investment
6. summary of event
- there are 12 data, but only 3 shown --> was fixed is because evaluation feedback response is null (efr_id is null);
- fixed company's full name
- adjust the layout display.
- display in monetary format
- SMM report are was fixed, event title --> SMM on chemical
- TIM report are was fixed, event title --> trade n Investment

7. Evaluation by event
- SMM report was fixed , event title --> SMM on chemical
- TIM report are not generated , event title --> trade n Investment
- fix company display (because efr_id is null)
- fixed display company

8. feedback by participant
- SMM report was fixed , event title --> SMM on chemical
- TIM report was fixed , event title --> trade n Investment
- display company name

9. Matrade officers Remarks
- SMM report was fixed , event title --> SMM on chemical
- TIM report was fixed , event title --> trade n Investment
- display company name
- 'FEEDBACK RESPONSE', 'ISSUES', 'COMPLAINTS', 'SUGGESTION' were not shown (for TF) --> because no have any data in database also, anywhere i was fill in the data, please check it and re-test again.

Awaiting user feedback pending
4. By country
10. SMM outcome

as discussed:
1. to fix search by date range from the filter search
2. to combine all repeating data and sum the value into one
3. to convert the value into MYR

Suspected:
1. showed multiple data, because of multiple day/ daily feedback form
2. the value is not correct, because of the system did not clear previous data and add on with the recent data.

Added according to the log:
6.4.1 Event Reports
Trade Fair Reports
1. to put 'RM' currency for the moneytary value
2. to put the 'months' ini sequences (3 months, 6 months, 9 months, 12 month, etc)
3. missinf the selection of programme typr for the Total Sales By Country Reports, (not standardize with others)
4. the list of country have to be sort alphabetically
5. there is no representative information in Summary Of Event Report
6. evaluation by Event have to display the description instead of the number indicator

Hi leo ,

- total sales by event
- total sales by sector

1. if two report is correct d ,then i will continue to the rest.

Hi leo ,

i already fix the issues because they are changing database issues...please test it after deployed...

Thanks...

the issue that Jeng Wei have fixed previously are still not correct
which are : total sales by event, and total sales by sector,
the amount of the company that listed in the feedback form is not the same as the company that shown in the reports
there are 3 companies in the feedback form list, but in the reports it shown 4 companies.

there are no total amount for the 'ACTUAL VALUE' and 'TOTAL SALES' in TOTAL SALES BY SECTOR report

please kindly fix this

Hi leo
the way i test program
tf --> CPHI , 2015,
SMM--> SMM ON CHEMICALS TO ISTANBUL, TURKEY AYU NYE , 2015
TIM --> TRADE AND INVESTMENT MISSION (TIM) TO MANILA, PHILIPPINES (24 û 26 MAY 2015) , 2015

1. fix status approve for print out report.
2. to combine all repeating data and sum the value into one

1. fix status approve for print out report.
2. to combine all repeating data and sum the value into one
3. fix status approve for print out report.
4. to combine all repeating data and sum the value into one

by country

List of participating company by event
#fix status approve for print out report.

summary of event 
#fix status approve for print out report.

1. fix TF only

1. fix feedback comment.

MATRADE officers remarks
#fix status approve for print out report.
#add on office response.

awaiting user confirmation.
Total Sales by sector --> because sector have to follow event sector or company sector.
Evaluation by event --> because inside SMM and TIM no have Facilities , No. of Visitors, Quality of Visitors , Pavilion Construction, Publicity. awaiting feedback from En rizal.
SMM outcome --> is already drop out by user.

TOTAL SALES BY SECTOR
- to confirm the sector field
- there is missing total sum for TF
TOTAL SALES BY PRODUCT/SERVICE
- incorrect product/service lists
BY COUNTRY
- fix the search filter
- there is no data shown in the report
SUMMARY OF EVENT
- to combine the data which have the same company name
EVALUATION BY EVENT
- SMM and TIM still not fixed
FEEDBACK BY PARTICIPANT
- need to filter malaysian company only
MATRADE OFFICER REMARKS
- to include officer remarks from follow up form

hi leo,

TOTAL SALES BY PRODUCT/SERVICE
- fix product/service lists
BY COUNTRY
- fix the search filter
- fix the data.
SUMMARY OF EVENT
- to combine the data which have the same company name --> fix

FEEDBACK BY PARTICIPANT
- need to filter malaysian company only --> fix
MATRADE OFFICER REMARKS
- to include officer remarks from follow up form --> fix

Still awaiting user confirm event sector.
TOTAL SALES BY SECTOR
- to confirm the sector field
- there is missing total sum for TF..

TOTAL SALES BY SECTOR
- to confirm the sector field
- there is missing total sum for TF
TOTAL SALES BY PRODUCT/SERVICE
incorrect product/service lists
- please check on the value of each cell, found some incorrect amount displayed
EVALUATION BY EVENT
- for SMM and TIM there is Layout problem, please refer to the attachment

Hi leo ,

2)TOTAL SALES BY SECTOR
##there is missing total sum for TF --> this is not missing total issues, is because of total sum up for actual values and potential values is not correct.

1. Fix the each cell for actual Sales and potential Sales.

4)EVALUATION BY EVENT
- Fix the SMM and TIm layout Problems.

Please retest after deployed....Thanks