Share this
Data in Acumatica: How Built-In Tools Allow for Greater Visibility
by Darren Talley on 9/9/22 7:35 AM
Your data is only as good as the tools you use to analyze it. What is the point of investing in a modern cloud-based ERP system if you can’t make heads or tails of the data you’re collecting? If you can’t even FIND what you’re looking for within the software? The benefit of an end-to-end solution is that you don’t need to compile the pertinent information from disparate sources and translate them into the same language. Acumatica has plenty of native tools to provide exactly the insight you need from your system to make smart business decisions.
[Though, if you’re still having trouble, you can always contact a Milestone specialist and ask all your burning questions!]
This blog will look at the basic functions that Acumatica uses to provide a clear vision of what is happening across all of your business processes, interactive and in real time.
Dashboards
Dashboards are the first method that Acumatica uses to display any essential data you (or your team) need to know – you’ll notice the dashboard immediately upon opening the system.
Dashboards can be customized by individual, role, or department, and designed to display any number of relevant financial, operational, and organizational indicators. Role-based security can be established to ensure that nobody in the company sees what they aren’t supposed to.
These views are built using SQL-driven queries, and can be presented in a graphical inquiry form. You can also utilize videos, wiki articles, and even PowerBI tables to display as widgets on your dashboard. Each of these widgets will allow you to drill down into the data that it represents, using the Acumatica Generic Inquiry tool.
Generic Inquires (GIs)
Generic Inquiries (“GIs” for short) allow users to pull data from various tables and present that data in a meaningful way. This can take countless forms: on reports, in dashboards, usable for BI tools, filters, and more. Generic Inquiries are the basic building blocks of data analysis in Acumatica and require no coding knowledge: just select the data you need using Acumatica’s wizards and follow the steps.
This example takes a quick look at opportunities.
In this screen, you can use GIs to highlight any of the fields you’d like based upon various conditions – in this example, Estimated Closed Date. You also can highlight fields that need to be populated with data.
That is a simple example but the possibilities truly are endless.
Filters
Acumatica allows users to utilize filters within the system. Once created, you have the option to share the filter view with other users, or just have specific filters for yourself. They are easy to work with – simply click on your filter settings to create a new filter. Select a property, give it a condition, and then save that filter. After you save, you will see that an additional tab has been added and the filter is ready to use.
Watch this video to see how to create a new filter using “Nurture No Activity” as an example.
Side Panels
The side panels in Acumatica are yet another way to get a deeper look into your processes. Side panels present additional detail about your data without having to open up multiple screens or tabs. They can be set up almost anywhere to quickly access related tasks.
Reporting and Data Tools in Acumatica
This list only scratches the surface of the tools and tricks that Acumatica has created to aid users in their day-to-day tasks. In upcoming blogs, we’ll look at these in more detail, along with pivot tables, the report writers, add-on tools, and more. Another neat thing about Acumatica? They update their product twice per year, so they’re always adding something new. Contact Milestone today to chat more about the latest features and how they can speed up workflows from the front office to the shop floor.Share this
- Cloud (50)
- Acumatica (42)
- ERP Software (42)
- CFO Knowledge (16)
- Tools for COOs (15)
- Cosmetics (13)
- Accounting System (10)
- Tools for CTOs (8)
- Distribution (7)
- Implementation (6)
- Tools for CEOs (6)
- Manufacturing (5)
- Dashboards (3)
- Field Service (3)
- Tribal Gaming and Management (3)
- Professional Services (2)
- eCommerce (2)
- Reporting (1)
- Retail (1)
- inventory (1)
- September 2023 (2)
- August 2023 (5)
- July 2023 (2)
- June 2023 (4)
- May 2023 (2)
- April 2023 (3)
- November 2022 (1)
- October 2022 (2)
- September 2022 (2)
- August 2022 (5)
- July 2022 (3)
- May 2020 (1)
- April 2020 (12)
- March 2020 (3)
- July 2019 (1)
- June 2019 (3)
- May 2019 (5)
- April 2019 (4)
- March 2019 (3)
- February 2019 (3)
- January 2019 (4)
- June 2018 (1)
- April 2018 (1)
- January 2018 (1)
- September 2017 (1)
- August 2017 (2)
- July 2017 (1)
- April 2017 (1)
- March 2017 (1)
- February 2017 (2)
- October 2016 (1)
- September 2016 (1)
- August 2016 (1)
- May 2016 (1)
- March 2016 (1)
- January 2016 (1)
- August 2015 (1)
- July 2015 (2)