JetCube GL Detail API Query for Microsoft® Business Central
The JetCube GL Detail API Query is an AppSource add-on for Microsoft Business Central that adds a custom field named Posting Period to the General Ledger Entry table that is automatically updated with the year (4-digits) and month (2-digits) any time a general ledger entry is posted. There is also a menu action button added that can be run on the first install to populate the new Posting Period field for all existing general ledger entries. This new field along with 10 new Query APIs named GLImportsSimple01, GLImportsSimple02, GLImportsSimple03, GLImportsSimple03GDO, GLImportsSimple04, GLImportsRec, GLImportsRecGDO, GLImportsRecTrans, GLDetailsRec and GLDetailsFull allows pulling Business Central financial records with many additional important fields like Vendor Name, Customer Name and Shortcut Dimension Codes. These new API queries along with the JetCube Financial Reporting, Forecasting and Budgeting software allow the quick and easy creation of financial income statement and balance sheet reports with detail drill-down right from within Excel.
New General Ledger field ‘Posting Period’ allowing easier API Query filtering.
New General Ledger Action button to update the new ‘Posting Period’ field for all existing general ledger entry records. This action only needs to be run once when the add-on is first installed.
New API Query ‘GLImportsRec’ fields. This API query is usually used to import Business Central general ledger entries into the JetCube financial reporting, forecasting and budgeting software. It is a summarized query that uses an SQL “group by” statement and summing of the amount fields to condense the number of records returned by the query. There are 6 more simple versions of this query that return less fields, so the returned dataset is even more summarized and smaller. They are named ‘GLImportsSimple01’, ‘GLImportsSimple02’, ‘GLImportsSimple03’, ‘GLImportsSimple03GDO’, ‘GLImportsSimple04’, and ‘GLImportsRecGDO’.
There is also a non-summarized version of this query named ‘GLImportsRecTrans’ that returns all transactional rows with no grouping.
New API Query ‘GLDetailsRec’ fields. This API query is usually used to get the Business Central general ledger entry details when drilling down (T-Slicing) on JetCube financial reporting values.
New API Query ‘GLDetailsFull’ fields. This API query is usually used to get the complete Business Central general ledger entry details when drilling down (T-Slicing) on JetCube financial reporting values.
Microsoft and Microsoft Business Central are trademarks or registered trademarks of Microsoft® Corporation. This website is not affiliated with or endorsed by Microsoft Corporation.