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 3 new Query APIs named GLImportsRec, GLDetailsRec and GLDetailsAll 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.
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.