Assist on generating the ff:

We will be having our Business Review soon and we need the following files to be able to accomplish our reports:
1.       Per Location Inventory Valuation by UPC (July 31, 2016)
2.       Per Location Consolidated Sales Report by UPC (July 1-31, 2016)
3.       Per Location Consolidated Sales Report by UPC (January 1- July 31, 2016)
Hope you could send these files to us before Friday. We couldn’t generate the right files in Pentaho.
-Ms. Lea Erika M. Villena