Jet Basics is a Microsoft Excel add-in (for use with Microsoft Dynamics NAV and Dynamics GP) which gives users a simple way to create basic financial reports inside Excel.
Instead of printing a report and re-entering data into worksheets, you can enter formulas that read directly from your database and refresh the General Ledger data right in Excel.
Jet Basics gives you access to the GL function, which facilitates creating reports using data from the general ledger. This function can return budget, balance, net change, debits, and credits data from the general ledger accounts for a given company, based on filters.
To use Jet Basics, you should have experience with Microsoft Excel, including cell referencing and worksheet functions. You should also have a basic understanding of your database structure.
Trial with Extended Capabilities
Starting with release 20.6 (May 2020), Jet Basics offers you the opportunity to try for 60 days additional reporting tools that are available only to users of Jet Reports. These tools include the Browser, the Report Wizard, the Table Builder and the NL function.
To activate the trial, there is a button in the Jet ribbon, in the Excel add-in, which appears to the right of the Help icon. The trial can be activated any time after installing Jet Basics and filling up the registration form.
A menu screen will pop up after you click the Trial Button. To start the trial, click the “Start Trial” button in the menu screen. After you click the “Start Trial” button, you will return to the Jet Ribbon and the Trial button will change color to yellow, indicating the 60-day trial is active.
At this time, you will notice that additional report creation tools become available in the Jet ribbon. This includes the Browser, the Report Wizard and the Table Builder. Also, the NL function will become available in the function menu.
After 60 calendar days, the trial ends and the Trial Button becomes red.
At this time the reporting tools that became available at the start time of the trial will disable again. The user can continue using the GL function to create reports.
Once the trial ends it cannot be restarted.