Skip to Content

Sap B1 Unreconciled Business Partners in a query

Hello,

We use Sap B1 9.3 PL12

Is there any way to find out if there are any business partners that we may have been forget to make internal reconciliation.

As you can see in the attachment. There are two pair of JE and PS records has to be reconciled. But has not been done yet.

i know it is visible in aging reports but We would like to to create a query to check quickly.

i have checked a couple of suggestions on forums but they show unreconcilated record even if there is nothing to reconciliate against it.

internal-reconcilation.jpg

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on May 07 at 12:49 PM

    Hey i think i ve found it. for people's benefit Here is the query.

    SELECT T1.CARDCODE, T1.CARDNAME,T1.BALANCE,SUM(T0.BALSCCRED) FROM JDT1 T0 INNER JOIN OCRD T1 ON T1.CARDCODE=T0.SHORTNAME GROUP BY T1.BALANCE,T1.CARDNAME,T1.CARDCODE HAVING SUM(T0.BALSCCRED)>0 AND SUM(BALSCDEB)>0

    Add a comment
    10|10000 characters needed characters exceeded