Columns for Gains Losses and Revaluations Detail Report

You can select the columns to display on your report.

Contents

Field	Description
Account	This column displays the account to which the gain or loss was posted.
Adjustment Amount	This column displays the gain or loss amount in the active company's functional currency. Vantagepoint calculates this amount as follows: Calculated Functional Amount - Prior Functional Amount.
Balance	In the Foreign Denominated Accounts section, this column displays the account balance of the foreign-denominated account, in the account currency, at the time the Gains/Losses and Revaluations process was run. In the Accounts Receivable and Accounts Payable sections, this column displays the transaction amount in the transaction currency.
Bank/Invoice/Voucher Number	In the Foreign Denominated Accounts section, this column displays the bank code for a foreign-denominated account that is linked to a bank. For other foreign-denominated accounts, this column is blank. In the Accounts Receivable section, this column displays the invoice number for the accounts receivable transaction that resulted in the gain or loss. In the Accounts Payable section, this column displays the voucher number for the accounts payable transaction that resulted in the gain or loss.
Calc. Functional Amount	In the Foreign Denominated Accounts section, this column displays the account balance in the active company's functional currency. In the Accounts Receivable and Accounts Payable sections, this column displays the transaction amount in the active company's functional currency. Vantagepoint calculates this amount as follows: Transaction Amount X Exchange rate.
Exchange Info	This column displays the exchange rate used to calculate the gain or loss and information about how Vantagepoint determined the exchange rate.
Phase	In the Accounts Receivable section, this column displays the number of the phase for the accounts receivable transaction that resulted in the gain or loss. In the other report sections, this column is blank.
Prior Functional Amount	In the Foreign Denominated Accounts section, this column displays the previous stored account balance in the active company's functional currency. In the Accounts Receivable and Accounts Payable sections, this column displays the previous stored transaction amount in the active company's functional currency. This amount includes the original transaction amount and any previously calculated gains or losses.
Project/Vendor Number	In the Accounts Receivable section, this column displays the number of the project for the accounts receivable transaction that resulted in the gain or loss. In the Accounts Payable section, this column displays the number of the vendor for the accounts payable transaction that resulted in the gain or loss. In the Foreign Denominated Accounts section, this column is blank. Note that for the Accounts Receivable section, this column shows the same data as the Project column. If you include both the Accounts Receivable section and the Accounts Payable section in the report, select this column. If you do not include the Accounts Payable column, you can use either this column or the Project column to display project numbers.
Row Count	This column displays the row number of a line item.
Task	In the Accounts Receivable section, this column displays the number of the task for the accounts receivable transaction that resulted in the gain or loss. In the other report sections, this column is blank.
Trans.Type	This column displays the two-letter abbreviation for the type of transaction (such as CD for cash disbursements, IN for invoices, AP for accounts payable vouchers, and EX for employee expense reports).
Transaction Currency	In the Foreign Denominated Accounts section, this column displays the currency code for the account currency. In the Accounts Receivable and Accounts Payable sections, this column displays the currency code for the transaction currency.