Discrepancy in the generated Total amount

[Former Member]

Hello..

I am working on the cash position summary report. We have a customized report for that one since we use three currencies: PESO, USD, YEN. Subtotals are correct but the grand totals are wrong. For example:

Subtotal-PHP account converted to PHP = 60,138,309.95

Subtotal-USD account converted to PHP = 28,901,029.65

Subtotal-JPY account converted to PHP = 2,664,205.76

GRAND TOTAL = 115,681,397.21

Also, the decimal adjust for YEN currency. Example:

BOT - YEN = 6,128,840

MIZUHO -YEN = 0

SUB-TOTAL = 6,128,840

GRAND TOTAL = 61,288,398

I simply use the command 'SUM'. Either AT NEW or AT LAST.

Thanks,

April

[Former Member · Accepted solution]

You would get a better response if you also post this in the ABAP forum

[Former Member · Accepted solution]

Hi Nitin,

Thank you

I really appreciate it.

Thanks for answering many of my posts.

Sincerely,

April

[Former Member · Accepted solution]

April,

Thats precisely what this community is for. And I am sure pretty soon you would be answering many posts too.

Nitin