There is currently no way to see the unpaid balance of invoice line items with a query. You can only run a query for the unpaid balance of the full invoice.

You must go into Receivables, open an invoice, and fully open each line item individually to check for unpaid balances. There is also no way on the line item view screen to click on to the next line item in sequence (like there was in the database). You must go back out to the list of line items to move to the next one, and on an invoice with 50+ lines it's very easy to lose your place and miss something. This results in an information gathering task that should take two minutes taking hours to investigate manually.

The remaining balance for specific line items is a critical piece of accounting information that requires frequent and timely follow up. It is definitely something that merits being able to be pulled up quickly with a Query.

I have also attached a sample jpg showing related visibility suggested additions for Receivables > Invoices.

lineitemunpaidb...

Attachments Open full size