Gains Losses and Revaluations Detail Columns Tab

Use the Columns tab to select or clear columns, change column sequence, provide new column labels, set column widths, or select number and date formats.

Contents

Field	Description
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.
Project/Vendor	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 other report sections, this column is blank. In the Accounts Payable section, this column displays the vendor number for the accounts payable transaction that resulted in the gain or loss. In the Foreign Denominated Accounts section, this column is blank.
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.
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.
Account	This column displays the account to which the gain or loss was posted.
Post Period	This column displays the fiscal year and accounting period in which the gain or loss was posted.
Post Seq	This column displays the posting sequence number for the gain or loss transaction. DPS assigns the sequence numbers during the posting process. DPS assigns 1 to the first group of transactions posted during an accounting period, 2 to the second group, and so on. To see a numbered list of all of the postings for the current accounting period, click Transaction Center > Posting Review Report from the desktop application Navigation menu.
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.
Exchange Info	This column displays the exchange rate used to calculate the gain or loss and information about how DPS determined the exchange rate.
Calculated 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. DPS calculates this amount as follows: Transaction Amount X Exchange rate.
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.
Adjustment Amount	This column displays the gain or loss amount in the active company's functional currency. DPS calculates this amount as follows: Calculated Functional Amount - Prior Functional Amount.
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.
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.