Hello,
I use the general ledger directly from SAP B1 to know which transactions are outstandings.
I take the "Not fully reconciled" transactions, and then sort them on excel to know which ones to send reminders to.
The problem is that I have several databases, and it's very time-consuming to open each one, export each excel and then put them all together.
So I use SAP Hana to create a SQL query with a general ledger that brings all my databases together. The idea is to simulate the SAP Business One General Ledger, but with a "Union All" on each database. But I can't find the fields that give the "Not Fully Reconciled" and "Last Reconcilitation Number".
Could you please help me?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.