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.
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.
SAP Business One Support
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.