Inventory Valuation - Can separate out ALL lot codes?

Greetings NS UserGroup, this is my first post here. In the recent weeks I have been familiarizing myself with the reporting capabilities of NS and have one dying urge which I need help to actualize.

I have customized a version of Inventory Valuation to report the transaction history of each lot code(of its parent item/product code) and to summarize at the bottom the remaining qty on hand.This is great, I am really close to what I need... as long as each transaction only has one lot fulfilled for each line item. The problem is that if a transaction has been fulfilled with multiple lots under one line item it displays in the report as a whole new section and list all lot codes from that transaction rather then each lot code separating out and being