Check Out The Jet 20.3 Updates

jet 20.3

Performance Improvements in the Jet 20.3 Release

Written by | Jet Global 

We’re over halfway through the year and you know what that means? It’s time for a new Jet release. So, let’s get you up to speed on what you can expect to see when you update your Jet products to version 20.3

In an effort to continuously evolve our reporting, business intelligence, and budgeting solutions, we always have our ear to the ground listening to customer feedback. Earlier this year we rolled out Microsoft Word integration, a redesigned browser, and new data integrations, which was well-received. This release, however, focuses more on performance improvements, data sources, and expanded easier access to products.

Jet Budgets Available to the Masses

The Jet 20.3 release opens the door to controlled, expedited, and streamlines fiscal planning for organizations that are not running their businesses on Dynamics 365, Dynamics NAV, or Dynamics GP. That means anyone can use Jet Budgets. When creating a budget, you will be able to copy/paste in GL accounts and dimensions (if applicable) and build a budget based on those values.

Excel Add-In Performance Increases

By leveraging newer technologies in Excel, we are able to push performance increases in the Jet Excel Add-In. You will notice this, especially for longer running reports. This improvement will benefit all data sources but should see the most improvement for web service data sources, including Dynamics 365 Business Central (Public Cloud) and Dynamics Nav web services.

Better Access to Jet Hub

Previously, we required that customers to use AD/AAD to leverage Jet Hub. In Jet 20.3, we are adding support for “Basic Users” in Jet Hub, so you can bypass this step. This means you can now create simple users in Jet Hub (ie. username, full name, password) and they can log in without being an AD/AAD user.

If you remember from the last release, we added support for the most commonly used data sources to be added directly in Jet Hub – instead of requiring the Jet Administration Console. With Jet 20.3, we now support adding all data sources directly from Jet Hub.

Jet Scheduler Rebuild – Phase 1

There are some big things happening with the Jet Scheduler. In the Jet 20.3 release, we will be launching the first part of our Jet Scheduler rebuild. This rebuild includes a complete overhaul of the feature, where we will be updating the user interface, as well as making several user experience improvements. When you upgrade your Jet solution to version 20.3, you will see that the Jet Task List has been updated. This is the first step of many improvements to come.

How BI can help to better manage your cash flow


Blog Written by | Jet Global

Cash Flow Analysis with BI

Success is not ‘all about the money’ – but good financial decisions are the foundation for every business’s growth and prosperity. In a world where a number of businesses fail due to cash flow, it’s more important than ever to have a solid understanding of how cash flow contributes to your business and how technology, like business intelligence (BI), can help keep your cash under control.

What is a Cash Flow Analysis?

Cash flow analysis is used for financial reporting purposes. By examining your company’s cash inflows and outflows during a specific period, you can see where cash is being generated and spent so you can plan accordingly. Control over your cash not only protects your business during uncertain times but opens doors to new opportunities.

Are you making or losing money? Whether you are a new business starting out, or an established company, cash flow is crucial at every stage of a business’s lifecycle. Money is needed for purchasing inventory, to hiring a new employee. Stability and forecasting are essential in any business, that being said you need to have the right technology and intelligence in place to help you succeed.

Common approaches to Cash Flow Analysis

Most accounting and finance teams are accountable for performing cash flow analysis at the end of every quarter to ensure everything is in order and accounted for. Your business could be earning a profit, but if receivables become past due or uncollected it could leave you in a bit of a financial predicament.

One of the most useful measures in financial performance is Free Cash Flow (FCF). Analysts look at FCF, which is your operating cash flow minus your capital expenditures, to find out what money is left over to expand the business or return to shareholders. If your expenses exceed your cash, you have a problem.

A cash flow statement is an essential tool to manage your cash flow that includes information from operations, investing and financing. Traditionally, a cash flow statement is compiled using Excel-based manual data processing. When you are trying to aggregate data from your cash flow history, planned and actual operating expenses, capital expenditures, accounts receivables/payables balances, and general ledger data – it can get complicated.

We love Excel, but this approach is resource-heavy and time-consuming, to say the least. it can also lead to issues with data accuracy and report standardization, which is not something you want to worry about when managing your money.

Recognizing these implications, many companies have automated these manual accounting processes and embraced business management and intelligence technology for analyzing and forecasting cash flow more efficiently.

How BI can help to better manage your Cash Flow

Now that the software is more accessible and affordable, organizations are adopting business intelligence technology to improve the way they manage their cash flow. BI and analytics software is used to help companies automate cash flow analysis and provide the tools they need to consolidate their data, simplify cash flow planning and forecasting, and accelerate decision making.

The key selling point of BI software is that it’s designed to provide more accurate financial figures and ultimately, take the guesswork out of the cash flow analysis process. BI solutions equip managers with timely, accurate, and easy to use reports.

Below are some specific examples of how BI is helping businesses around the world better manage their cash inflows and outflows.

1.  Intelligent Forecasting

Financial forecasts create a clear path to achieving your business goals and help you plan for resource allocation and budgeting. With BI software, cash forecasts can be generated automatically. With this capability, financial managers can stay informed at all times, with advanced warning of cash shortage or surplus. This allows an organization to react quickly to growth opportunities or to scale back when needed.

2.  Data Management

The most time-consuming part about cash flow analysis by spreadsheet is compiling data from multiple sources. Using BI software that integrates with your ERP and CRM solution, you can get the numbers you need in real-time. Your cash flow analysis will provide more meaningful insights and up to date reports for quick, informed decision making based on data.

3.  Project Management

Big projects can have a huge influence on cash flow. Financial managers need to have more control over what comes in and what goes out, so the ability to analyze a project’s duration, costs, resources required, and terms of payment are important for cash flow planning and strategic growth.

4.  Inventory Planning

Inventory has some hidden costs associated with it. It not only ties up cash in goods, but there comes a certain point when too much inventory works against your cash flow. With BI software, you can find a good balance between demand and supply and be more deliberate with inventory spending. With sales forecasting and smarter reporting, BI can save you a ton of time and money in the long-term.

5.  Risk Management

Should you invest in a new opportunity? Should you scale back your expenses temporarily? BI software is a reliable tool to manage risks. If your cash flow forecast is showing that you don’t have enough cash, a BI solution will allow you to make a quick projection and liquidity analysis to help make the right decision.

What to look out for in a BI solution

BI solutions are built to support data-driven analysis and decision making, which is exactly what you need to get a strict handle on your cash flow. As a leader in reporting and analytics solutions for over fifteen years, Jet Global has seen the impact that data and business intelligence can have on an organization’s staff, processes, relationships, and bottom line.

While there are a lot of BI solutions out there on the market today, especially Microsoft Dynamics users, there are no ‘one size fits all’ solution. Do your diligence and find a solution that will bring all of your data sources into one platform that provides the reports and dashboards in a format your users need.

If you are ready to improve your financial reporting and cash flow analysis, Jet Global and allonline365 are here to help. Contact us on or  +27 (21) 205 3650 to speak to a consultant about digitally transforming your business.

What does the future of AI look like in the Enterprise?


Blog by | George Brown, Jet Global

The Future of AI in the Enterprise

The business world is at an inflection point when it comes to the application of Artificial Intelligence (AI). While the technology behind enabling computers to simulate human thought has been developing, at times slowly, over the past half-century, the cost of implementation, readily available access to cloud computing, an practical business use cases are primed to help AI make a dramatic impact on the enterprise over the next few years.

With the potential use cases on the horizon for AI in business, as well as the investment dollars and rate of change currently propelling AI, one thing is clear: you’ll need to get your foundation in place sooner, rather than later, to take advantage of the benefits coming to the business world.

Enter business intelligence (BI) software. By building the foundation now with this readily available, accessible, and affordable software, businesses can prepare themselves for the future while also reaping the benefits of today. After a couple of years with inflated expectations for AI that have yet to materialize, businesses are beginning to ask themselves whether it makes sense to push through a costly implementation that won’t yield tangible results for 2-3 years – when really, they should be focused on implementing BI today, yield results immediately, and layer AI on top of your established  BI data to derive new insights and drive greater benefit once the technology matures/.

So how will BI software help set the stage for AI in your enterprise, and what possible use cases can be gleaned from the intersection of AI and BI?

How Can BI Software Help?

Regardless of where you’re landing in regards to Artifical Intelligence and Business Intelligence, one thing is true: you’ll need to have data to feed to both. Without data to act upon, there’s no ‘intelligence’ in AI or BI. There’s nothing to analyze, or apply a learning algorithm to – when it comes to any intelligence solution, data is the foundation upon which it must be built.

Thankfully, with the widespread of cloud computing and the Internet of Things (IoT), data has never been more readily available in today’s business world. But the vast reams of data generated on a daily basis are presenting a new problem for businesses – what does it mean and which data matters? How should data be tagged, sorted, grouped and analyzed? Which problems do disparate data points speak to? And how can the data be collected across multiple touchpoints, from all retail locations to the supply chain to the factory be easily integrated?

Enter data warehousing. Data warehouses are a means of taking data points from disparate touchpoints (such as point of sale, CRM, inventory, and warehouse management systems), standardizing the data collected, structuring it to extract necessary insights, and running analysis. Enterprise businesses cannot survive without robust data warehousing – data silos can rapidly devour money and resources, and any business still trying to make sense and cobble together ‘business intelligence’ from multiple reports and inconsistent data is rapidly going to lose ground to those businesses with integrated data and reporting.

The optimized data warehouse isn’t simply a number of relational databases cobbled together, however – it’s built on modern data storage structures as the Online Analytical Processing (OLAP) cubes. Cubes are multi-dimensional datasets that are optimized for analytical processing applications such as AI or BI solutions. Cubes are superior to tables in that they can link and sort data by multiple dimensions, allowing for non-technical users to choose from any number of role-specific and highly contextual data points to uncover new insights and adjust tactics and decisions on the fly. Chances are good that your average non-technical sales agent or purchasing representative will have difficulty joining multiple tables together with a standard report, but with Business Intelligence cubes, all that is required is to drag and drop the metrics and dimensions that matter to them into their own personalized dashboards.

So how is the data extracted? By using Structured Query Language (SQL), the language used to manipulate and extract data stored in cubes. SQL was developed as a standard language to communicate databases, regardless of exactly which type of database was being used, and is ultimately the means by which data in a table is extracted, deleted, updated and managed.

Beyond data warehousing and OLAP cubes, which provide the technical foundation, there are a number of additional components that can help enterprise businesses address their data requirements”

Data modeling: Data modeling is a method of mapping out individual data sources across an enterprise and determining how they need to interact with one another to extract the most valuable business insights. Data modeling can be performed at the conceptual (high-level, related to business objectives), logical (mapping to each business function), and physical (how the actual dimensions, measures, and hierarchies are related within a data cube).

Analytics and reporting: Capturing, structuring, and storing data is good – but being able to analyze and report on it is the ultimate end goal. Business intelligence solutions are capable of providing simple, accessible analytics and reporting functions for end-users, empowering them to find actionable insights they need with little technical expertise (or formal data science training). This also helps business functions avoid unnecessary data logjams and giving them instant access they need to the data they so desperately require.

Data visualization and dashboards: Analytics and reports are a crucial component of business intelligence, but if you’ve ever spent hours poring over a table of values trying to decipher exactly what the data is saying, you’re not alone. With data visualization tools, critical insights are displayed in rich graphical representations that are vastly easier for the human brain to interpret. According to a study by Aberdeen Group, organizations using visualization tools are 28 percent more likely to find timely information than those who rely solely on managed reporting; the same study also found that 48 percent of business intelligence users at companies with visual data discovery are able to find the information they need without the help of IT staff. Dashboards can easily assemble visualizations and reports into customizable displays by end-user or business units, giving individuals instant insight into KPIs that help drive better business performance from the bottom up.

Security, simplicity, speed – these are the three major benefits business intelligence solutions help to drive, and three critical measures of success in enterprise business. While artificial intelligence remains focused on helping computers glean insight entirely on their own, business intelligence is enabling entire organizations to gain access to the data they need to make rapid, informed decisions, and the importance of that in today’s quickly shifting business landscape simply can’t be overstated. In a survey of 2,600 business intelligence end-users, 91% responded that BI gave them faster reporting, analysis or planning, 84% said it enabled them to make better business decisions, and 79% said it improved employee satisfaction.

The Future is (Almost) Here

In the near future, AI algorithms will be able to be seamlessly applied to your existing data stores, unlocking further insight for your enterprise. As highlighted in this 2018 Harvard Business Review article, AI applications in response to business needs fall into one of three categories:

  • Process automation: The most common current application for AI in business is by automating systems and business processes. While previous incarnations of automation focused on exchanging information between systems, AI can level up this ability by actually interacting with the data like a human – either inputting or consuming as necessary. Today, AI ‘robots’ are able to analyze legal contracts and extract relevant provisions, update customer records across a number of disparate systems, and automate customer outreach in response to situational conditions. As these algorithms grow ‘smarter’, businesses will be able to automate even broader swaths of processes.
  • Cognitive insight: Cognitive insight is the ability to apply AI algorithms to vast existing stores of data to extract meaning and identify patterns. While BI software and data stores will undoubtedly provide the ‘diet’ for cognitive insight algorithms, as the algorithms learn, they’ll be able to apply those learnings to broader data sets, react to new data in real-time, identify potential data matches across multiple databases, or manage programmatic ad buying.
  • Cognitive engagement: Cognitive engagement refers to the human-interfacing element of AI – think automated chatbots, knowledge bases, product recommendation engines, and more. Cognitive engagement applications can be used to automate interactions between people and systems, either externally (for customers), or internally (for employers). Most current applications focus on internal engagement as businesses are still apprehensive about the relatively new applications – but, again, as AI development and implementations continue to mature, expect objections to fall by the wayside as businesses will find new ways of using existing data to drive meaningful automated interactions with human beings around the world.

Over the next few years, you’ll see artificial intelligence finally begin to live up to the hype we’ve been hearing about in the business world, and computers will help usher in a new era of productivity and profitability for enterprises on the cutting edge – but only if you have the foundation in place today, and that starts with business intelligence.

Don’t hesitate – ensure you’re setting up your business tomorrow for success today with Jet Global and allonline365. Contact us on or  +27 (21) 205 3650.

Allonline365 Newsletter

* indicates required
Business Software News
Call Now Button