Hi All,

I was asked to build a report that will show the Trial Balance that is very similar to the original report that comes out from tfgld3403m000 session.

In this session you can choose the currency (USD/EUR) and the report will be in one of those only (+ the currency of the record itself).

What I need to do is that I need both Currencies on the report, USD & EUR. I have the Report script but not the session script, as I see all the calculation is in the session script (which I do not have).

Basically what I need is the ledger account code, and the colsing balance (in all three currencies). No need for the other columns.

Is there an easy way to do this?

If not can someone explain the logic, so I can write a new report from scratch?

Thanks,

- D7

Hi David

Closing balance is a calculated field. What you need to do is that get the total amount by currency and ledger a/c for the required period from table tfgld201 and opening balance data from tfgld203 and calculate the closing balance as a+b-c = Closing Balance. Here a= opening balance(tfgld203) b=Debit transaction total (tfgld201) and c=Credit Transaction total (tfgld201).

Hope this will help you.

Thank to you I have found the open balance amount.

I am still looking for the "b" & "c" in your equation and can not find those amounts in the tfgld201! I am looking in the same company, same ledger, all currencies.. What am I missing?

Any help is really appreciated

- D7

b and c u may need to write an SQL query on tfgld201 in report script for ledger.

Thank all you for you help.

I guess have managed to calculate this field.