Skip to Content
0
Former Member
Nov 18, 2013 at 09:57 AM

Error while running report due to money overflow, one or more amounts generated are

237 Views

Dear experts,

i got error like title above when generating balance sheet & P&L.

I tried run this query:

select account, sum(Debit), sum(Credit)

from jdt1

where

jdt1.RefDate <= '2013-06-30'

group by account

having abs(sum(debit)) > 9223372036854

or abs(sum(credit)) > 9223372036854

result in Inventory account, amount greater than 12 trillion. Which caused by wrong curreny input from AP invoice transaction

Various adjustment has been done, and i've got the correct amount of inventory account per 2013-06-30.

SAP version 8.8 PL 15

Any solution to get the correct amount from SAP report?

Thanks,


Carlita