Unbalanced transaction when reconciling

[Former Member]

Hi,

The error Unbalanced Transaction [message 131-91] is been appearing when trying to reconcile an account:

We have run the three differents following queries, looking for unbalanced transactions, but there is no results:

select sum(debit)-sum(credit) from jdt1

  select transid

  from jdt1

  group by transid

  having

  sum(debit)-sum(credit) <> 0

select transid, account, shortname, debit, credit, fcdebit, fccredit

  from jdt1

  where transid in

  (select transid

  from jdt1

  group by transid

  having

  sum(debit)-sum(credit) <> 0)

  order by transid

Our rounding method is By Currency.

SB1 8.82 PL:10.

Any Ideas?

Regards

[kothandaraman_nagarajan]

Hi Maria,

Please check SAP note:

1804413 - Down Payment Request cannot be linked to Invoice

Thanks & Regards,

Nagarajan

[agustin_marcoscividanes]

Hi

how many decimal digits are you using for prices?

how many decimal digits are you using for amounts?

Can you show the reconciliation amounts in foreign currency and system currency? Any difference?

Kind regards

Agustín Marcos Cividanes

[Former Member]

Hi Agustin,

Decimal Places for

Amounts: 2

Prices: 2

The foreign and system currency is exactly the same (USD).

Thanks in advance,

Regards

[agustin_marcoscividanes]

Hi Maria

do you have transactions in foreing currency?

I have a similar question and I have to increase the digits in amounts to reconcile. Rounding creates the problema.

Try in a test enviroment to increase the digits to 6, and try to reconcile.

Kind regards.

Agustín Marcos Cividanes

[agustin_marcoscividanes]

Hi Maria

do you have down payments in the list to reconcile?

In another hand, if you try to reconcile with local currency any error message?

Kind regards.

Agustín Marcos Cividanes