cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

I've checked SAP notes you give. I've tried update to SAP 9 in QA system, and everything is works.

But if there's another solution, i prefer not to upgrade.

And also i want to know, is it caused by the average amount from OJDT as shown from 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

Or is there another cause?

So i can explain & suggest to my customer for the best solution.

Thanks,

Carlita

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Just explain to customer this is system limitation in 8.8, 8.81 & 8.82 version. Only possible way is upgrade to 9.0 version.

Thanks & Regards,

Nagarajan

former_member196081
Active Contributor
0 Kudos

Hi Nagarajan

My client is working with SAP 9.0 PL 06 and facing the same error.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

As per above note, this error should not be appeared in 9.0 version. but still this error message appearing in other scenarios.

1596678 - Error 'Money overflow, cannot display all digits.'

1552776 - Money Overflow; cannot display all digits

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hi,

any solution or advice regarding this?

Thanks,

Carlita

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Have you checked with SAP note?

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Dear Jitin,

Here is the result of query given:

Adjustment done:

- AP credit memo with same amount with the wrong AP inv, reconciled.

- Since that AP CM did not correct the amount of COGS, so i try create manual JE to correct both COGS & inventory acc.

Please advice.

Thanks,

Carlita

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

It is an application error. Please refer SAP note:

1026634  - Money overflow error message            

Thanks & Regards,

Nagarajan

jitin_chawla
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

Can you please elaborate a bit on what exactly the adjustments you have tried?

It would be better in understanding the current situation of the issue in the database. Also, can you plese tell what is the result from the following queries :

SELECT *

FROM JDT1

Order by Debit desc

SELECT *

FROM JDT1

Order by credit desc

Kind Regards,

Jitin

SAP Business One Forum Team