I am trying to create a report that will summarize my accounts payable by Item. We use QB Desktop Enterprise 2021.
We order a number of similar items from different vendors, with varied payment terms. I am trying to show the total item quantity we have received but have not yet paid for (regardless of vendor we received the items from). I reconcile in terms of vendor balances - that is not a concern.
I can print our my listing of unpaid bills and do some data entry into excel to summarize manually, but I would much prefer an automated approach.
I assume I am going to have to export into excel and use a pivot table or something similar???
Any help would be greatly appreciated.