Report: Inventory Received Not Billed

Hi All,

Thanks in advance for your support.

I'm trying to find a report that will show me what is open in our Unvouchered Payables Account or "Inventory Received Not Billed." If the balance is say 100,000 I want to know what receipts are "open" on what POs. Example below:

Document Number	Date	PO	Item	Description	qty	price	amount
IR7569	12/1/2024	PO-123	753215	Dummy Item	2.00	12,500.00	25,000.00
IR7570	12/2/2024	PO-321	951753	Example Item	1.00	25,000.00	25,000.00
IR7571	12/3/2024	PO-456	852136	Example Item 2	1.00	12,500.00	12,500.00
IR7571	12/3/2024	PO-456	652138	Dummy Item 2	1.00	12,500.00	12,500.00

I have made some saved searches that I was able to tie to the GL balance, it just looks at the "created from" document and gives me a summary of all the receipts, bills, and JEs that have been created. However there is one flaw that I cannot figure out how to overcome.