Difference between revisions of "ManPageR InvoiceNotRealizedGainLoss"

From ADempiere
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.
(Initial load of Online Help)
 
(Contributions)
 
(One intermediate revision by one other user not shown)
Line 6: Line 6:
 
under the [[#Contributions|Contributions]] Section
 
under the [[#Contributions|Contributions]] Section
 
   
 
   
<!-- Note to editors: NOT MODIFY THIS CODE -->
+
<!-- Note to editors: DON'T MODIFY THIS CODE -->
{{:ManPageR_InvoiceNotRealizedGainLoss_olh}}
+
{{:Adempiere{{CURRENTMANUALVERSION}}/en/ManPageR_InvoiceNotRealizedGainLoss_olh}}
<!-- END Note to editors: NOT MODIFY THIS CODE -->
+
<!-- END Note to editors: DON'T MODIFY THIS CODE -->
 
=Contributions=
 
=Contributions=
 +
 +
[[Category:Manual|R I]]
 +
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.

Latest revision as of 19:04, 28 June 2009

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


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.