Skip to Content

How to pick last balance of bank reco in sap b1

Hello Expert,

How to pick last balance of bank reconciliation in query report ..

Regards

BHanu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 13, 2016 at 09:36 AM

    Hi,

    Check this:

    SELECT sum(T0.[DebAmount])- sum(T0.[CredAmnt]) FROM OBNK T0 WHERE T0.[AcctCode] = [%1] and T0.[DueDate] >= 'XXXXX'

    Regards,

    Jitin

    Add comment
    10|10000 characters needed characters exceeded