Skip to Content
0

How to pick last balance of bank reco in sap b1

Dec 13, 2016 at 08:07 AM

54

avatar image

Hello Expert,

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

Regards

BHanu

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jitin Chawla
Dec 13, 2016 at 09:36 AM
0

Hi,

Check this:

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

Regards,

Jitin

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thank you for your reply

But i want to pick last balance of bank date wise....

Regards

BHanu

bank-recon.jpg (31.4 kB)
0