Checked the inventory on SQL vs on JDA. Since the inventory is not tallied I run an inventory workback on putty to refresh. Nikki Descalzo also requested for a Inventory generated reports on pentaho as of March 15, 2020. So I run and generated the reports on pentaho. This is now okay as per advise via email by Nikki.