Has anyone successfully recreated the Inventory Transaction by Account as a GI?

We want to get a Generic Inquiry where the Inventory Balance of the Balance sheet equals to the Inquiry Balance. The main issue in here is that we wanted to depict the transactions in the Generic Inquiry and at last, the balance should be equal to the inventory balance of the Balance sheet.  I’ve been trying to recreate Inventory Transaction by Account as a GI, but so far have remained unsuccessful.