Display AR Transactions

Use the AR Transaction Inquiry (RTI) program to display AR transactions. See Road Map for work flow.

  1. Click Prog opts to set your options.

    1. Click the Runtime tab to set runtime options. See Set Options for Reports and Inquiries for more information.

    2. Click the Sort tab to set sort order.

    3. Click the Selection tab to select specific records.

    4. Click the Program tab to set these program specific options:

Field Name

Type / Max Length

Action / Description

Exclude disputed invoices?

Optional
 

Select to omit invoices this customer disputes or leave blank to display them.

Exclude all invoices and debit memos?

Optional
 

Select to omit invoices and debit memos or leave blank to display them.

Exclude adjustments?

Optional

Select to omit adjustments or leave blank to display them.

Exclude payments?

Optional

Select to omit payments or leave blank to display them.

Exclude deposits?

Optional

Select to omit deposits or leave blank to display them.

Exclude credit memos?

Optional

Select to omit credit memos or leave blank to display them.

Exclude write-offs?

Optional

Select to omit write-offs or leave blank to display them.

Exclude finance charges?

Optional

Select to omit finance charges or leave blank to display them.

Convert to currency

Conditional/Optional
2 alphanumeric

If the multi-currency feature is active, select the currency code for which you want to display statistics or leave blank to display  the currency used for the transaction.

Curr exchange date

Conditional
10 date

If you selected the Convert to currency option, select the date to use for the currency exchange rate or enter a date shortcut. This inquiry uses the exchange rate in effect on this date.

    1. Click Save to save these options for future use.

    2. Click Refresh to redisplay current options.

    3. Click OK to apply these options or click Cancel to exit the program.

The program displays these fields for each transaction:

Field Name

Displays

Invoice no

The number for this invoice

Tr cd

The transaction type:

Code

Transaction type

CA

Credit Adjustment

CM

Credit Memo

DA

Debit Adjustment

DI

Debit Invoice

DM

Debit Memo

DP

Deposit

PY

Payment

WO

Write-off

AR customer

The customer for the transaction

Trans

The transaction date

Reference

Information about the transaction (e.g., the order and shipment number, payment type and number)

Discount given

The discount given for this transaction

Trans amount

The transaction amount

Cur

The currency for this transaction

Disp?

A check mark indicates that the invoice is being disputed

AR org

The organization code for this transaction

AR acct no

The account number for this transaction

Jrnl no

The general ledger journal that the transaction was recorded in

Cust PO number

The PO number the customer used

Due

The date the invoice is due; for progress payments, this is the date of the final payment

Discount

The date by which the invoice must be paid to be eligible for a discount

Order no

The sales order number

  1. Choose the appropriate options:

To

Do This

Review your options for this program

Click Prog opts. See step 1.

Print the transaction listing

Click Print. See Print an Inquiry.

Go to a related program

Click Jump. See Jump.

Display the total amount of all invoices and subtotal amounts if you selected Subtotal? for a sort option

Click Totals. Click Totals again to redisplay details.

Display an invoice

Highlight a line and click Invoice or double click the line. See Display AR Invoices. Click OK to return to this program.

Display the general ledger journal for an invoice

Highlight a line and click GL journal. See Display an Interface Journal. Click OK to return to this program.

Exit the program

Click Exit.