Knowing which invoices a payment was applied to is easy.  However, many times you need the opposite information.  Fortunately, finding out which payments were applied to a particular invoice is equally as easy, just not as obvious.  For this example, I will use a sales invoice.  But the same options are available for a purchase/accounts payable invoice.

When looking at an invoice in the Sales/Invoicing screen click the Reports button that in on the right end of the button bar at the top of the screen.  A list of reports will drop down.  Click on Customer Transaction History (for AP invoices it will be Vendor Transaction History).  You will get a report that shows each receipt and credit memo that has been applied to the invoice, and the remaining balance.  You can double click on a line in the report to open that transaction.  The same report is available from the Maintain Customer (or Vendors for AP) screen.  When you run it from there, the report will be automatically filtered to show the last 3 months of activity for that customer or vendor.  You can also print the Customer or Vendor transaction history reports from the Reports & Forms menu.

If you are using Peachtree version 2010, you have another option.  In the upper right section of the Sale/Invoicing window you will see the words, “View related transactions”.  They are underlined to show that they are a clickable link, just like on a web page.  When you click them, you will get a list window that shows all related transactions.  In this case, it could be more than just payments and credit memos.  Related sales orders and purchase orders can also show on the list.  Like other lists, you can double click on a transaction to open it.

Both are excellent tools to help you find the information you need.  The transaction history reports have adjustable options that let you show information for different customers/vendors, invoice numbers, or date ranges.  But they can’t show sales order or purchase order information.  On the other hand, the related transactions list can show those other types of transactions, but doesn’t let you adjust the filters yourself.

[Facebook] [LinkedIn] [StumbleUpon] [Twitter]