Accounts payable> Common Forms> Advance holders> Transactions

–or–

Accounts payable> Inquiries> Advance holders> Transactions

–or–

Accounts payable> Periodic> Advance holders> Exchange adjustment> Transactions

Use this form to set the parameters for generating the advance holder transactions report. The report displays the date, the general ledger transaction number, the transaction amount in the standard currency and secondary currency, the date and amount of closing, and the type of the source transaction.

Task that uses this form

Navigating the form

The following tables provide descriptions for the controls in this form.

Tabs

Tab

Description

Overview

View information about transactions for an advance holder.

General

View the posting profile, general ledger account, data for rate exchange difference, and source type.

Amount

View information about the amount of an entry in the standard currency and secondary currency of the transaction, the amount of the settlement in the standard currency and secondary currency of the transaction, and the amounts for unrealized and realized exchange rate adjustments.

Source

View information about the source of the entry for an advance holder that includes the order, the invoice line, and vendor transaction.

Dimensions

View the dimensions for the transactions.

Buttons

Button

Description

Voucher

Open the Voucher transactionsform to list the vouchers for an advance holder.

Settlements

Open the Transaction settlementsform to view the transactions for settlement of an advance holder.

Functions

Select from the following options:

  • Show

  • Print

Fields

Field

Description

Show open only

Select this check box to show only open transactions.

Voucher

The general ledger document number for the transaction.

Date

The date for the transaction.

Adv. holder

The code of the employee for whom the transaction was posted.

Currency

Select the currency code.

Amount currency

The transaction amount in the secondary currency of the transaction.

Amount

The transaction amount in the default currency.

Balance currency

The unsettled amount per voucher in the secondary currency of the transaction.

Source type

The source document type from one of the following options:

  • Accounts payable– If the source of the entry is a vendor transaction.

  • Facture– If the source is a facture.

  • Exchange rate adjustment– If the source is an entry for an exchange rate adjustment.

  • Advance report line– If the source is an advance report line.

  • Cash receipt– If the source is a cash receipt.

  • Bank– If the source is a bank transaction.

Advance report

Enter the advance report number.

Transaction text

The transaction text that has been created for the transaction.

Balance

The unsettled amount in the default currency.

(Source)

Reference

The source reference in a different table.

(Source)

Reference table ID

The source table that the transaction is attached to.

(Reference)

Reference

The reference field in a different table.

(Reference)

Reference table ID

The table that the transaction is attached to.

Posting profile

The posting profile used when creating the transaction.

Ledger account

The general ledger account per voucher for the advance holder.

Correction

Specifies if the current transaction is a reversing entry or a correction.

Last exchange adjustment

The voucher date of the last calculation of the exchange rate adjustment, determined by the value of the Considered datefield in the Exchange adjustmentform.

Last exchange adjustment rate

The value of the currency exchange rate of the last calculation of the exchange rate adjustment forecast, determined by the value of the Date of ratefield in the Exchange adjustmentform.

Settled currency

The settled amount in the secondary currency of the transaction.

(Settlement)

Amount

The amount to be settled in the default currency.

Closed date

The date of total settlement of the transaction.

Reversed

Specifies if the settlement has been canceled.

Unrealized exchange adjustment

The amount for transactions with an unrealized exchange rate adjustment.

Realized exchange adjustment

The amount for transactions with a realized exchange rate adjustment.

Exchange adjustment amount

The total amount per realized and unrealized exchange adjustment voucher.

Name

The name of the source.

Description

A brief description of the operation.

Department

Select the value for the transaction for this dimension.

Cost center

Select the value for the transaction for this dimension.

Purpose

Select the value for the transaction for this dimension.

Sales tax amount

The calculated sales tax amount.

Sales tax amount in currency

The calculated sales tax amount in the sales tax settlement currency.

See Also