I need to create a report showing open purchase order for a vendor that are open for a period of time showing the various accounts. I have tried 'Transaction Detail by Account' but have not been able to filter out the paid PO's. Report shows all PO's for a period of time not just unpaid. Thanks.
Thank you so much for your quick response. I only volunteer to do this work a couple of days a week, therefore the delay in getting back you to, But yes! That worked great to collect all unpaid purchase orders. However, may I ask is there a way to have the customer name show on this report? I searched in the column for customer and did not see it to check.
Or is there another report that would show customer?
Before you kindly assist me further, let me give you a brief overview as to what I am volunteering to do.
I am working with a branch of a large non-profit. The headquarters handles the accounting. We simply need to enter what we buy and get it into various accounts to send in a report. Quickbooks has been used for years by this location but they have only been entering the checks they desire to pay by entering in the check register and creating the needed reports by hand.
I am attempting to assist them in using Quicksbooks to a more fuller measure, but yet not as it is truly intended.
Since they now are requesting more information to be stored in Quickbooks, I have suggested entering all receipts for things already purchased in 'Purchase Orders' so the vendor, item, cost, dept requested, etc can be stored. This will enable them to pull up particular items purchased more easily if there is a possible return or desire to purchase that item again.
Much of the items purchased are by credit cards. Rather than use the credit card function as intended, they are making the credit card company the vendor in the purchase order and where the item was actually purchased (store name) as the customer. Then in the memo column we are listing the name of the credit card holder.
Also for ease in locating a purchase later, we are adding the department that requested the item in the 'Class' section of the purchase order.
So far so good. Yes, I know very well that Quickbooks is not being used as intended nor are they experiencing its full potential. But it seems that this will work.
1) Report showing open purchases orders for the credit cards, per account assigned.
(Your suggestion works great if we can add customer)
2) Report showing amount paid for selected accounts for a specific time period.
(I have been using a Trial Balance report, selecting the specific accounts requested by a particular date span) This seems to be working.
3) I need to be able to create a report that will show all items purchased for a particular department (entered as a class) for any date range that will include vendor or customer so item and be returned or repurchased.
(I tried a Custom Transaction Detail Report adding Date, Name, Source Name, Item, Class and Amount Paid. But nothing showed up!
Thank you so much for allowing me to share in more detail my current project. Any suggestions you may desire to share would be greatly appreciated.