Fetch Last Balance from External Bank Reconciliation via SAP B1 Service Layer API

[rahuljain257]

Hello Team,

I hope you are all doing well. I have a question regarding the SAP B1 Service Layer.

Is there any end point in the Service Layer that can fetch the last balance in SAP B1? I need this information for a project I am working on.

If you have any knowledge or experience on this topic, please share it with me. I would appreciate your help.

Thank you for your time and cooperation.

Best Regards,

Rahul Jain

[rahuljain257]

Hello Everyone,

I am writing to share with you the SQL query that I have created to fetch the Last Balance from the database. You can find the query in the attached file named sql-query.txt & hana-query.txt

However, I am still working on finding out whether the same data is exposed by the Service Layer API. I will update you as soon as I have more information on this.