Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Discrepancy in the generated Total amount

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

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question