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

Helpful Answer

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