If I go to an inventory item and click on “Qty on Hand” it lists all the invoices.
Is there a way to sort or filter them so that I can differentiate which ones have been paid and which ones are awaiting payment?
If not, is there another way that I can get a list of all unpaid invoices that contain a specific inventory item?
No, there is not. Invoice status is related to customers and suppliers, not line items on the invoices. (You did not mention whether you were speaking of sales or purchase invoices.) The quantities in various columns of the Inventory Items tab listing are related only to movement of items.
For example, once an item has been recorded as being purchased (and received if you are using goods receipts), it is available for sale, regardless of whether the purchase invoice has been paid. Your obligations to suppliers are reviewed by drilling down on the Accounts payable account and, from an accounting perspective, have nothing to do with individual inventory items.
Similar reasoning applies to sales invoices, customers, and Accounts receivable.
Sorry, it’s for sales invoices.
Many of my items are ordered by customers before they are made. Each order is invoiced to the customer so that they can pay a deposit and then pay off their purchase whilst waiting for the stock to become available, if they wish to do so. It also allows me to quickly see how many customer orders I have for each item as it will have a negative stock level corresponding to the number of orders I have.
Sometimes these orders are placed up to two years before the items are manufactured, received and ready for sale/despatch
When I get the items, some people have fully paid for their order and others haven’t.
There are a few things I need to do.
Send out all orders that have been paid for
Chase up all orders that haven’t been paid for.
Continue to monitor which invoices for the items remain unpaid so I can contact the customers for payment
Sometimes there will be over 50 invoices for the one inventory item and it is very time consuming trying to find all the ones that remain unpaid.
Thanks for your help 
you can use a custom field and set it to show as a column which will help you set the status of the invoice as Pending or Completed. this will help you to search and sort by paid in full/unpaid status.
again the above suggestion would help in this case.
along with the above suggestion, entering the item name in the Description of your invoice or as a separate custom field will help you with the search.
I still don’t think you need any linkage between sales invoices and inventory items.
My first recommendation is that you should be using delivery orders. That way, the sales invoice will obligate the inventory items. The Qty to deliver column in the Inventory Items tab will allow you to drill down and see which customers an item has yet to be delivered to. From there, it is quick to drill one click further and see which sales invoices are involved. You could also drill down from the Customers tab on Qty to deliver to get similar information. Which is easiest will depend on how many orders a typical customer has pending. That takes care of #1 on your wish list.
Chasing unpaid invoices is best done with the Aged Receivables and Customer Statement reports. That is #2.
#3 is the same as #2.
sharpdrivetek
February 11
CoastalHobbies:
Send out all orders that have been paid for
you can use a custom field and set it to show as a column which will help you set the status of the invoice as Pending or Completed. this will help you to search and sort by paid in full/unpaid status.
Chase up all orders that haven’t been paid for.
again the above suggestion would help in this case.
Continue to monitor which invoices for the items remain unpaid so I can contact the customers for payment
along with the above suggestion, entering the item name in the Description of your invoice or as a separate custom field will help you with the search.
I will look into how the delivery orders work
Cheers,
Greg