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:
|
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:
|
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. |