Service Layer API Query for Unreconciled Transactions

[rahuljain257]

Hello Everyone,

I hope you are all doing well. I have a question regarding the Service Layer API for SAP Business One.

Is there any API end point that can list down the outgoing and incoming transactions that are not reconciled yet? 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

[ANKIT_CHAUHAN]

Hi rahuljain257,

I doubt that it will be available via API.

However, since you have the queries to fetch the data, I would suggest you to use SQLQueries in Service Layer to get the data.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[rahuljain257]

Hello Everyone,

I am writing to share with you the SQL query that I have created to fetch the unreconciled transactions 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.