i got error like title above when generating balance sheet & P&L.
I tried run this query:
select account, sum(Debit), sum(Credit)
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?