- check again one by one the computation if it had any in BIR report and the data that should be display
- Modify the report script and Pentaho formula for changing the approach in the report, instead of selecting the data and computation of data in the script, the formula is apply in the Pentaho formula functions, this returns a correct value
- modify the formula for VAT as the zero-rated and discount should be deducted in total net sales before dividing it into 1.12 and multiplied into 0.12
- change also the total sales, net sales, total net sales extraction of data, instead of selecting the equivalent fields in the database table (there is a total net and total sales fields in the database), apply the formula of additional/deduction in the Pentaho formula function
- apply the modified script in the report for checking of the output
- and per checking there is still one field that has a discrepancy versus in should be data
- check the formula function for checking if the formula is correct