Provide Transfer In/Out report in Pentaho for ICG as requested by Laudimer M. Luico. After they tried accessing and generated reports on the Transfer in, they asked if the transfer number has only 4 digits, since as per them in JDA it has only 4 numbers.  I ask Nina to shadow me on how to validate this in SQL. He assisted me to check this in transfer fact, to check the transfer id, and to compare it on JDA (on transfer header and transfer details). Arvin also advised to run me that after checking is tried to run the transfer refresh on the particular date that the ICG is trying to generate (January 01, 2019 -January 9, 2020) then after running the refresh we figure out that on the pentaho display the transfer id only and not the batch number. Also, they are requesting for Wee need a report both in Transfer In and Out with Transfer Number, From Location To location, Shipped Qty, Received Qty, Shipped Cost, Received Cost, Shipped date, Received Date, and Status. See below sample, generated in IAS: This was also raised to the Pentaho team and waiting for their feedback.