ManPageR InvoiceNotRealizedGainLoss

From ADempiere
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section

Report: Invoice Not Realized Gain/Loss

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.

Class Name: org.compiere.process.InvoiceNGL ReportView Name: T_InvoiceGL

ManPageR InvoiceNotRealizedGainLoss.png


Name Description Help Technical Data
Accounting Schema Rules for accounting An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar C_AcctSchema_ID


Revaluation Conversion Type Revaluation Currency Conversion Type C_ConversionTypeReval_ID


Revaluation Date Date of Revaluation DateReval


AP - AR Include Receivables and/or Payables transactions APAR


Include All Currencies Report not just foreign currency Invoices IsAllCurrencies


Currency The Currency for this record Indicates the Currency to be used when processing or reporting on this record C_Currency_ID


Revaluation Document Type Document Type for Revaluation Journal C_DocTypeReval_ID



The purpose of this report is mainly to allow the revaluation of foreign currency items in a companies AR and AP ledgers at the end of a financial period. If transactions of all currencies are included then logically all invoices and allocated payments are included therefore the total should equal the balance in the GL account. The report should produce two columns " this is value presently in the accounts" and "this is value that should be in the accounts if all the open trx in foreign currency were revalued to the exchange in the system on the date selected in the report parameters".

Another use of this report can be that if you have (say) multiple accounts receivable general ledger accounts then the open items report will not break up the the transactions by GL account code. This report does so it should provide a means to demonstrate that the open items agree with multiple AR control account balances.