Skip to content
logo Knowledgebase

Create an Accounts Payable transaction report or find deleted invoices

Created on  | Last modified on  Highlight Matches

Summary

How do I create an Accounts Payable transaction report or find deleted invoices in Sage 300 CRE?

Resolution

To troubleshoot issues with Accounts Payable transactions, use a transaction inquiry, or create a transaction report.

  • If the invoice with the transactions that you want to review has not been deleted, use the AP Transactions inquiry
  • If the invoice that you want to review the transactions for has been deleted, add the AP Transaction List.rpt to your menu

Use an inquiry

Review the transaction history of an invoice using the AP Transactions inquiry in Accounts Payable

  1. In Accounts Payable, from the Inquiry menu, select Other, AP Transactions.
  2. Select Master and click OK.
  3. Select Current and click OK.
  4. Double-click the appropriate vendor.
  5. Double-click the appropriate invoice.
  6. Review the transactions for your invoice.
    Note: You can add or remove a column as follows:
    1. Click Select.
    2. Click Insert column before this column or click Add column after this column and click OK.
    3. Select the field that you want to add a column for and click OK.
      • Dist Seq
      • Check
      • Batch
      • Accounts Payable Account
      • Reference Date - include this field if you're troubleshooting the Accounts Payable Invoice Aging w/Cut-off Date report
    4. To remove a column, click the column header for the column that you want to remove, select Delete this column and click OK.
  7. Print your inquiry as follows:
    1. While the inquiry is open, from the File menu, select Print.
    2. In the Vertical option section, select Print all visible rows.
    3. In the Horizontal option section, select Print all columns.
    4. Click Start to print your inquiry to a file or printer.
      Note: If your inquiry has many transactions, you may not be able to print all of them. If you are unable to print all of your transactions, use the AP Transaction List report below instead.
  8. Click Close after you review the transactions for your invoice.

Use a report

Add the AP Transaction List report to your menu.

  1. In Accounts Payable, from the Reports menu, select Reports Manager.
  2. Click New.
  3. Type AP Transaction List in the Report name box.
  4. Click the Menu group box, click List and choose GL Reconciliation from the list.
  5. Click OK.
  6. Click the File name box and click List. Browse to your Report folder (x:\Timberline Office\9.5\Report) to select AP Transaction List Report.rpt.
  7. Select Open.
  8. Click OK and then click Close.