Discussions
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.