Checked the issue raised by Laudimer regarding the "er location Inventory Valuation for BR, location 7301, already zero in JDA, but still have quantity in Pentaho.
Below is the sample SKU 11285358. As per checking on invbal in JDA the on-hand and in-transit quantity is already zero. Run the inventory workback as of Aug 20, 2021, but I encounter an error while running the inventory refresh communication link failure, asked Mark if he can try to run the refresh and as per advice he also encounter the error while running the refresh. After the refresh as per checking, there is still quantity on the sample SKU. Checked the TRFDTL and found out there is still in-transit qty for the year 2014 and 2015. Email the finding to Laudimer for his validation.