Share
ReportHi All,
I'm Having a problem in this scenario :
I'm supposed to get the Total sum of the Invoice in which in payment journal I applied the same invoice but with different lines.
my report should display the Converted amount since my Amount LCY is in PHP
but this it shows the amount converted to PHP
in my case, i'm using the currencies table to get the currency exchange rate and convert it back to USD as a work around.
my Exchange Rate for USD is 1 USD = 53.34 PHP.
however. when i try to get the Sum which of Debit amount which is supposed to be 293,370 it only gets the last Amount 26,670, in the G/L Entries Preview but not in the whole debit and credit line that should be
Debit Amount : 266,700 + 26,670 = 293,370
Credit Amount : -266,700 + -26,670 = -293,370
as i said earlier it only displays the last line in the G/L Entries Preview 26,670
which is supposed to be 293,370 For the Debit Amount and -293,370 for the Credit Amount.
My G/L Entry DataItem in the Report DataSet Designer is a Temp. table linked through Gen. Journal Line. with the line reference of the External Document No.
I tried using CALCSUMS and Incrementing G/L Enty Debit Amount just to get the Sum of the Debit Amount in the G/L Entries Preview Amount,
which i commented this time because the Report only returns the last number in the G/L Entries Preview in which my report is getting the data.
I hope you do understand what i really mean.
and thanks in advance for the help.
*This post is locked for comments
All responses (
Answers (
18,696
