ManPageR InvoiceNotRealizedGainLoss

From ADempiere ERP Wiki

Jump to: navigation, search

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


Parameters

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

TableDir

Revaluation Conversion Type Revaluation Currency Conversion Type C_ConversionTypeReval_ID

Table

Revaluation Date Date of Revaluation DateReval

Date

AP - AR Include Receivables and/or Payables transactions APAR

List

Include All Currencies Report not just foreign currency Invoices IsAllCurrencies

YesNo

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

TableDir

Revaluation Document Type Document Type for Revaluation Journal C_DocTypeReval_ID

Table

Contributions

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.

Personal tools