Skip to content
logo Knowledgebase

How do I create an AP transaction report or find deleted AP invoices?

Created on  | Last modified on  Highlight Matches

Description

Cause

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, choose Option A and use the transaction inquiry.
  • If the invoice that you want to review the transactions for has been deleted:
    • Use Option B if you use version 9.8 and later to add the AP Transaction List.rpt to your menu.
    • Use Option C if you use version prior to 9.8. Use Report Designer to create a transaction report. If your invoice was deleted and you do not have Report Designer, contact your business partner for assistance.

Option A
Review the transaction history of an invoice using the AP Transactions inquiry in Accounts Payable as follows:

  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].
    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. 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, see Options B and C below for more options. If you use versions prior to 9.8 and do not have Report Designer, contact your business partner for assistance.

  8. Click [Close] after you review the transactions for your invoice.

Option B
In version 9.8 or later, 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. Click [OK].
  5. 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.
  6. Select [Open].
  7. Click [OK] and then click [Close].

Option C
Create a transaction report in Report Designer as follows:

  1. In Report Designer, from the File menu, select New Design.
  2. Select AP - Transaction and click [OK].
  3. From the field list on the right side of your screen, double-click the following fields:
    • Vendor
    • Invoice
    • Dist Seq
    • Amount
    • Retainage
    • Accounting Date
    • Check
    • Batch
    • Expense Account
    • Accounts Payable Account
    • Workflow Program
    • Transaction Type

    Tip: If you add a lot of fields to the report, you may prefer to print the report in landscape format (File , Page Setup , Print Options).

  4. From the File menu, select Print.
  5. Select AP Transaction (current) and click [OK].
  6. Specify a range or condition for a specific vendor and invoice to avoid printing the report for all vendors and invoices.
  7. Click [Start] to print your report to a file or printer.

Note: If you are troubleshooting the Accounts Payable Invoice Aging w/Cut-off Date report, include the Reference Date field in your transaction report.

Defect ID

69203