- Revised the script for correction of error encountering in Pentaho designer but not in MySQL
- Copy the old script, change the approach in some query and selection of data, add parameters for pos number, date, store, payment id in each selection per payment method
- test the revised script and check if the data is correct
- apply the script in Pentaho reports and testing  if no more error will return
- check the output of the report 