Skip to main content

Report: Invoice Not Realized Gain/Loss

[Created: 30/05/2005 - Updated: 19/12/2005 ]
Description: Invoice Not Realized Gain & Loss Report
Help: The Report lists not fully paid invoices with open amount, the GL amounts and the revalued amounts. If an invoice is partially paid, the percentage of the open amount is used to calculate the revaluation amount.If you select a currency, only invoices of that currency are included; if you select Include All Currencies, all invoices are included and you can use the report to reconcile your AP/AR accounts.If you select a GL Document Type, a GL Journal is created. Note that the report only includes posted invoices.

Table: Report Parameters

NameDescriptionHelpTechnical Info
Accounting SchemaRules for accountingAn Accounting Schema defines the rules used in accounting such as costing method, currency and calendarC_AcctSchema_ID
Table Direct
Revaluation Conversion TypeRevaluation Currency Conversion TypeC_ConversionTypeReval_ID
Table
Revaluation DateDate of RevaluationDateReval
Date
AP - ARInclude Receivables and/or Payables transactionsAPAR
List
Include All CurrenciesReport not just foreign currency InvoicesIsAllCurrencies
Yes-No
CurrencyThe Currency for this recordIndicates the Currency to be used when processing or reporting on this recordC_Currency_ID
Table Direct
Revaluation Document TypeDocument Type for Revaluation JournalC_DocTypeReval_ID
Table