Support #5894
[TPMS_Prod021] - Post Event > JPPPA Programme - Sales Generated
Status: | Dropped-End of life cycle | Start date: | January 05, 2016 | |
---|---|---|---|---|
Priority: | Normal | Due date: | January 07, 2016 | |
Assignee: | Norhaidah Md Dasuki | % Done: | 100% | |
Category: | tpms_prod | Spent time: | - | |
Target version: | - |
Description
All sales generated is displayed as “0.00” at list, but have value when is in “Edit” details display.
History
#1 Updated by Najmi Pasarudin over 8 years ago
- Status changed from New - Begin Life Cycle to Internal Testing
- Assignee changed from Najmi Pasarudin to Norhaidah Md Dasuki
- % Done changed from 0 to 90
Finding:
No code changes required.
Things to take note, JPPPA list and JPPPA details get the generated sales from different table.
JPPPA list : Generated sales is from event_detail table, which is the sum of all generated sales from all location/event_city table.
JPPPA details : Generated sales is from event_city table, which shows the separated generated sales in different location.
Edit and save JPPPA details will update these table and show correct information.
Solution:
Database administrator should check actual sales, potential sales and generated sales in table event_detail and event_city.
Assuming there is only one location in event_city for an event, column actual sales, potential sales and generated sales in both table show be exactly the same.
#2 Updated by Norhaidah Md Dasuki over 8 years ago
- Status changed from Internal Testing to Dropped-End of life cycle
- % Done changed from 90 to 100
5/1/16 - Forward issue to Inteksoft for further action.