Invoice Payment Audit Trail Inquiry

If you edit this topic, review Invoice Payment Audit Trail Inquiry Database Information.

Menu Path: Credit and Collections Images\bluerarw.gif Inquiries Images\bluerarw.gif Invoice Payment Audit Trail Inquiry

Purpose

Review the transaction audit trail of a specific invoice or other reference number.

Overview

Use Invoice Payment Audit Trail Inquiry to display all transactions that affected a specific invoice or other reference number, thus providing an audit trail. For database information for this window, see Invoice Payment Audit Trail Inquiry Database Information.

Using the Inquiry

To use Invoice Payment Audit Trail Inquiry:

  1. Enter the customer code or name for which you want to display payment audit trail information in the Customer Code or Customer Name field.

  2. Enter the transaction number for which you want to display payment audit trail information in the Reference # field.

  3. Click the Show Data button in the ribbon. Transaction information is displayed in the grid.

  4. Double-click a row in the grid to display payment audit trail information.

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Invoice Payment Audit Trail Inquiry window.

Show Data

Click this button to display transaction audit trail information.

Inquiry Tab Fields and Buttons

Field or Button

Description

Customer Code

Enter a billing customer code, or click the Lookup button to select a billing customer code.

Customer Name

Enter a billing customer name, or click the Lookup button to select a billing customer name.

Reference #

Enter the reference number of an invoice or other transaction for which you want to display an audit trail, or click the Lookup button to select a reference number.

Currency

Enter a currency for displayed amounts, or click the Lookup button to select a currency. This defaults to the default general ledger currency.

Original Amt

This field displays the original amount of the transaction.

Ref Type

This field displays the two-letter reference type for the displayed transaction, such as IN for invoice.

Reference Date

This field displays the reference date for the selected transaction.

Absorption Amt

This field displays the absorption amount for the selected transaction.

Due Date

This field displays the due date for the selected transaction.

Audit Trail

This grid displays information for the selected transaction. The first row displays information about when the transaction was created. If payment was applied to the transaction, the application information appears in additional rows.

This grid includes the following columns:

  • Application Amt - This column displays the amount applied.

  • Batch ID - This column displays the batch ID used for general ledger posting.

  • Seq# - This column displays the sequence number within the transaction.

  • Trans# - This column displays the transaction number.

Note A transaction number groups together transactions that were done as part of a process in one specific session.

Example In Open Item Apply and Resolve, three invoices and two credit memos were applied against each other in one session. All five of the transactions created as a result of this process would share the same transaction number and each would have a unique sequence number.

  • Description - This column displays the description of the transaction type (Invoice, Apply, etc.).

  • User ID - This column displays the user ID of the person who created the transaction.

  • Transaction Date - This column displays the transaction date.

  • Update Date - This column displays the last date the transaction was updated.

  • Update Time - This column displays the last time the transaction was updated.

  • Balance - This column displays the cumulative open amount balance based on the cumulative transactions.

Double-click a row to display Reference# Audit Trail Detail Inquiry, which allows you to view transaction audit information.