New Features in Acumatica 2019 R2

New Features in Acumatica 2019 R2

The release of Acumatica 2019 R2 means even more opportunities to increase productivity and accelerate growth. Improvements to the software (of which there are over 100), aim to make the cloud ERP system more user-friendly. Its latest upgrades are based on feedback from customers, developers and partners. There’s a cool roadshow for the new release hitting selected American cities in October. They cover the following aspects of Acumatica 2019 R2:


Worldwide SMS Support is now available, enabling users to be updated on business events via mobile text notifications. Conveniently, the recipient’s device doesn’t need the Acumatica mobile app installed. Other platform upgrades include enhancements to contract-based APIs, so developers can obtain multiple detail lines in a single request, while integration with HubSpot enables real-time syncing.

With the Pivot Table Widget, pivot tables can now be displayed on dashboards. Users can quickly summarize large quantities of data when creating reports. Also, lines, columns and dashboards can be highlighted for faster identification of relevant data. Users can highlight desired items via the customization feature on the Generic Inquiry screen.


Predefined roles are available to financial users, allowing them to quickly access system functions. Other enhancements to usability in Acumatica 2019 R2 include:

  • Autogenerating of expense report receipts directly from images
  • User-defined field enhancements for mobile devices
  • Conditional formatting to adapt the style of dashboard rows or columns (supports formulas)
  • Selection of a company/branch in a single click
  • Sorting and filtering of file attachments in a table/entity

Financial Management

Acumatica 2019 R2 now allows Application of Payments to Particular Lines of Accounts Payable Documents. Users can assign a partial payment to an entire AP document or individual lines within the document. Payment assignments can be performed in various proportions as well. The system also supports the ability to track retainage by document.

Users can now approve AR invoices, credit memos and debit memos within the software. The Accrual of the Costs of Non-Stock Items function enables revenue and expenses to be posted to non-stock items. Calculating the approximate net income of these items is therefore more straightforward. Acumatica’s new software applications also include corporate credit card support and reconciliation.

Project Accounting

Detail Level of the Project Budget options include task, task and item and task and cost code. Data here can now be updated at the summary and detailed levels. Users can also receive warnings when a saved document exceeds the budget, while the system can forecast project budgets by period, allowing the comparison of actual costs/incomes with budget amounts previously forecasted or revised. Two-Tier Change Management has also been added. Multiple change requests can now be grouped, with markups, into a single change order.

Inventory and Order Management

Buyers can now review item prices and select/change vendors from the purchase orders screen. Acumatica also allows direct sales order invoices to be linked with external point-of-sale systems while customer orders are automatically validated in the system. The prepayment system has been enhanced to allow one or more prepayment requests to be added to purchase orders (which can be added to prepayment documents). A Warehouse Management System and international shipping options have been integrated as well.

To learn more about Acumatica 2019 R2, register for a roadshow event near you or request a demo today!

Additional Acumatica Resources

Moving from QuickBooks to Acumatica

Better Financial Reporting with Acumatica

Understanding Acumatica Pricing

Acumatica Takes Home PCMag Award for Best ERP Software

Acumatica Takes Home PCMag Award for Best ERP Software

With 2018 an outstanding year for Acumatica, which celebrated its 10th year in existence, and a swath of awards from journalists and accolades from analysts, the company has continued its momentum into 2019 with its latest award: an “Excellent” rating of 4.5 and inclusion as one of three vendors receiving an Editors’ Choice designation.

What PCMag Celebrated

Acumatica was one of three vendors to receive a 4.5 out of 5 stars or higher, with PCMag author Ted Needleman celebrating the software for its easy navigation and browser-based design to make mobile access easy. Needleman added, “With its easy-to-follow navigation, robust reporting, and unusual pricing model, accounting software Acumatica is a good choice for growing small to midsize enterprises (SMEs).”

Dashboard-Based Navigation with Easy-to-Define Roles

While PCMag offered a wide range of reasons for the high rating, the first thing mentioned was the use of dashboards, a core component of Acumatica and other highly-rated applications. With easy-to-define roles and dashboards customized for each role, users are shown the information they need to see when they log in.

“It’s easy to define roles and permissions since this is done by checking or unchecking the appropriate entries in configuration boxes. This simplifies navigation because only the areas in which a particular user is allowed are shown.”

Needleman adds that the dashboard-based design makes task assignment, KPI tracking and configuration easy, as a user can simply click the dashboard he or she is allowed into and complete a task such as approving a bill, purchasing equipment, or running depreciation. Added to this, Acumatica was celebrated for its search functionality, in which a user can simply type a task into the search box and be shown related tasks.

Customization and Freedom

As a born-in-the-cloud solution, Acumatica is known for its extensive customization abilities. While PCMag does note that it is best to work with a partner to “do the heavy lifting” for you, there are hundreds of reports available for users to search and filter.

Another key selling point is the amount of customization allowed, as your decision to purchase Acumatica gives you access to the source code, giving you or your partner more freedom to customize it for your unique needs. Added to this, the app is written in Microsoft .NET, a much more accessible and easy-to-learn platform than many ERP solutions are written on.

APIs and Integration

A major part of a postmodern ERP strategy is integration. Often is the case, while a solution may give you nearly all the functionality you need, it doesn’t get you 100% of the way there. To address this, companies leveraging a postmodern ERP strategy need to find ways to integrate an ERP application with others through APIs so that data can flow between this and other applications.

Acumatica makes import and export easy with Open Data Protocol (OData)-compliant functionality allowing for the use of representational state transfer (RESTful) APIs. This makes it easy to connect Acumatica to a wide range of applications, with PCMag noting its tight integration with Microsoft Power BI.

Ready for You Whenever and Where You Are

Due to its browser-based nature, Acumatica is easily accessible—whether in the office or on the go. Acumatica empowers users to make decisions wherever they are using either a web browser or Acumatica’s Android or iOS apps.

“The mobile apps for Android and iOS are identical, and have a different UI than when you access the app in a browser. The app has icons for specific tasks such as entering time cards, expense claims, expense reports, sales orders, or purchase orders (POs). I accessed the iOS app on an Apple iPad Mini and the Android app on a Lenovo Yoga convertible tablet, but they’re really structured for smartphone access.”

The Unique Pricing Model

While explained as “unusual,” Needleman does celebrate the Acumatica pricing model for its ability to help growing businesses pay only what they need. Unlike other leading cloud ERP providers, Acumatica’s unique pricing structure bases fees on resource consumption versus per-seat licensing. Users can choose SaaS Subscription, Private Cloud subscription, or Private Perpetual License—all of which disregards the number of users and focuses on the volume of key transactions for a user’s business.

Learn More: Acumatica and IBG

When it comes to ERP, you have many options available. This award, in addition to other awards and recognition in 2018 (including the SIIA CODiE Award for Best Cloud ERP Solution and Best Manufacturing Solution, highest customer satisfaction in Gartner’s latest Magic Quadrant, and highest in usability in Nucleus Research’s ERP Technology Value Matrix, to name just a few), exemplifies what sets Acumatica cloud ERP apart from other ERP solutions.

At IBG, we are skilled in the implementation, customization, and integration of Acumatica Cloud ERP, designed for users to do more with what they have. Learn more about why this solution stands alone, get to know more about your path to ERP purchase, and contact us for a free consultation.

Acumatica Vetted Reviews: Asking the Right Questions

Acumatica Vetted Reviews: Asking the Right Questions

G2 Crowd, a leader in the world of reviews maintains a running total of user experience and functionality reviews from real, vetted, verified users who have had hands-on experience with the software. While much of the hype is focused on market size and satisfaction, a less celebrated but possibly more important question that the report asks is “does the software work?”

While many platforms will tout high levels of user satisfaction, many of those platforms with the highest levels of customer satisfaction are also the ones that companies “outgrow” on their way to larger scale, fully functional accounting and financial management functionality. Today, we would like to look at the other side of these reports, the feature comparison.

Feature Comparison: Who Stacks Up to the Competition in the Latest G2 Crowd Grid®?

In the latest G2 Crowd Grid® for accounting software, the website analyzed a wide range of available options to present an honest look at customer experiences, comparing 21 vendors for their ability to deliver and provide innovative accounting software. As defined by G2 Crowd, accounting software helps businesses streamline and automate finance management processes.

Accounting software products, often considered part of a larger ERP suite (i.e. the financial management module in Acumatica), vary in complexity and the features offered; many products are optimized for use by companies of a certain size, such as enterprise-level businesses or SMBs (small to medium sized businesses).

In addition to the general overview of Satisfaction and Market Presence (see methodology here), the report allows users to provide granular detail on their experience with the unique functionality across the core finance features that exist. As we’ve been discussing the key functionality that exists in financial management software (Accounts Payable, Cash Management, Accounts Receivable with more to come), we would like to look at how Acumatica stacks up in the G2 Crowd Grid® Report.

How Acumatica Stacks Up: A Look at Various Features

The G2 Crowd Grid® for Accounting software digs into many different functions: General Ledger, Accounts Receivable, Accounts Payable, Inventory, Reporting and Analytics, Integration, and Platform, as well as an ROI analysis.

General Ledger

The center of any financial management application, an effective general ledger needs to track all financial transactions and is used to generate the company’s financial statements, including the Income Statement and Balance Sheet. G2 Crowd evaluates general ledger by a software’s ability to handle journal entries, easily tag transactions, and provide a measurable audit trail. So how did Acumatica do? Well above average, according to customers.

  • Second highest satisfaction for Journal Entries with 90%.
  • 86% of customers were content with the ability to tag transactions and add dimensions.
  • 87% believed that the ability to create an audit trail was ahead of its class.

Accounts Receivable

Doing Accounts Receivable right appears to be a challenge for many vendors. With some of the lowest average ratings among all features in the software, Acumatica stood out as a true leader in this respect. G2 Crowd respondents lauded Acumatica for its invoice capabilities (91%, tied for number one), AR automation (88%, tied for number one), and collections automation (86%, second overall).

Accounts Payable

We’ve discussed the importance of Accounts Payable functionality and its roles in capturing discounts, improving relationships, and saving time. With such high priority on this functionality placed among buyers, Acumatica once again stands out—well above average in all respects. From their AP automation capabilities receiving an above average 84% satisfaction to their top three positioning for Payment Processing and Purchase Orders at 87% and 88% satisfaction respectively, Acumatica provides high levels of customer satisfaction.

Inventory Management

Knowing when to order, what to order, and what you have on hand to satisfy customers is critical to any business. Inventory management isn’t easy, and the right solution is often hard to find. Luckily, Acumatica was built for distributors, manufacturers, ecommerce brands and other product-focused companies—dominating this field.

Acumatica was the clear satisfaction leader for all inventory functions in the report, receiving 90%, 93%, and 88% satisfaction for Inventory tracking/ordering, pricing/costing, and reporting respectively.

Additional Functionality: Reporting, Integration, and More

The report looks at many more features that accounting and financial management software should be able to provide, with Acumatica receiving high praise or top ratings for a variety of functionality:

  • Tied for number one in multi-entity/consolidation.
  • Leads customer ratings for its time and expense functionality—by a wide margin.
  • Received well-above average reviews for financial statement reporting and custom reporting.
  • Ranked highly across all facets of the “Platform” category, with notable leadership in ‘performance and reliability’ and ‘output document generation’ at 90% and 91% satisfaction, respectively.
  • Celebrated for integration capabilities, receiving praise for data import and export tools (87%), integration APIs (88%), and its innovative network of partners who received an 88% satisfaction rating.

Acumatica: A High Performer in the G2 Crowd Accounting Grid® for Fall 2018

Acumatica has been named a High Performer based on receiving a high customer Satisfaction score and having a small Market Presence. 87% of users rated it 4 or 5 stars, 93% of users believe it is headed in the right direction, and users said they would be likely to recommend Acumatica at a rate of 86%. Acumatica is also a leader in the ERP Systems and high performer in Project-Based ERP categories.

We invite you to learn more about the company’s success in delivering financial management functionality for customers, read the entire report here, get to know more about the importance of integration from our last blog, and contact us to learn more.

Seven New Features in Microsoft Dynamics GP 2018 R2 (Part 3)

Seven New Features in Microsoft Dynamics GP 2018 R2 (Part 3)

A Brief Look Back: Part 1 and 2

In part one of this series, we explored seven improvements made in GP 2018 R2, discussing the following:

  • Monthly Recurring Batches: Use Last Day of the Month
  • Sales Transaction Workflow
  • New Visual Added to Display Vendor Hold Status
  • Toggle Business Analyzer Display for All Users
  • Print and Email Sales Order Processing Documents
  • Print in Functional Currency
  • Post Through General Ledger Files

Part 2 looked at additional features, providing insights on the following features:

  • Vendor Document Number in Purchasing All-in-One View
  • SmartList for Deposits on Unposted Sales Transactions
  • Include/Exclude Zero Quantity/Value Items on Historical Inventory Trial Balance
  • Security Improvement: Increased Password Length
  • Password Expiration Warnings
  • Easily Email Customer Statements
  • Allow/Decline Duplicate Check Numbers

Improvements Added to GP 2018 R2: Seven More Features Added to GP 2018 R2

Today, we would like to look at seven more new features added to the new iteration of Dynamics GP 2018 R2.

Payroll: Start Date and End Date for Each Pay Code

The first of three Payroll-focused features added top GP 2018 R2, Start Date and End Date for each pay code changes the way that check runs are completed. Added to the Employee Pay Code Maintenance Window, the feature is used when building the check run as to whether to include the selected pay codes. So if the check run is before the start date or after the end date, that pay code will not be included.

GP 2018 R2 Payroll Start Date

Payroll:Shared Maximum Benefit and Deduction Code

Also added to the payroll functionality, GP 2018 R2 adds a shared maximum benefit and deduction code. This new window allows professionals to set up calendar year maximums for things like 401K, Insurance, and more. This new window, Ded/Ben Shared Limit Setup, looks at the year-to-date amount and compare it to the calendar year max in this new window.

GP 2018 R2 Shared Maximum Benefit and Deduction Code

Payroll: Payroll Check Register Report Prints FICA Medicare and FICA Social Security

A third Payroll feature makes it easier to view and print total employer and employee FICA totals owed. Added to the Payroll Check Register Report, a new Total FICA Owed, Total Employee FICA owed, and totals for both FICA Medicare and FICA Social Security all print on the payroll check register report.

GP 2018 R2 Payroll Check Register

Purchase Orders: Partial Purchase on a Purchase Order

There are many occasions in which you do not need to order the complete amount listed on a requisition. Responding to user requests, Microsoft has adapted the purchase order functionality to allow a partial purchase on a purchase order.

When creating a purchase order from a purchase requisition you now have the option to change the quantity on the PO. Therefore, if the purchase requisition has a quantity of 100, when the PO is created you can change that quantity to something less, like 90. The remaining quantity is then canceled on the purchase order.

GP 2018 R2 Cancel PO Qty

Purchase Orders: Email PO Other Form

When sending purchase orders in previous versions of GP, you had one email option—blank paper. In GP 2018 R2, the Purchase Order Entry window the Email button now has both the Blank Paper and Other Form so you have options when sending the purchase order to the vendor.

GP 2018 R2 Email PO Other Form

Checkbook Management: Default Checkbook ID Defaults in Payables Batch Entry

Microsoft added a variety of new features to make the checkbook management process easier. The first improvement is added for situations in which a user would create a computer check batch. In GP 2018 R2, the Default Checkbook ID from Payables Management Setup will now default in the Payables Batch Entry window for Computer Checks. Additionally, the Checkbook ID will also default to the default ID in the Select Payments and Edit Payment Batch windows.

GP 2018 R2 Default Checkbook ID

Checkbooks: Option to Exclude Inactive Checkbooks

When searching for Checkbooks in GP 2018 R2, you now have the option to exclude inactive checkbooks by default. This feature cleans up the results and gives you more visibility into only the active checkbooks within the list.

GP 2018 R2 Exclude Inactive Checkbooks

Dynamics GP 2018 R2 Out Now: Will You Make the Move?

Microsoft Dynamics GP 2018 R2 offers a wide variety of new features for the users and administrators, and marks another chapter in Microsoft Dynamics GP’s long and vibrant history. Are you looking for a GP Partner? Integrated Business Group has helped clients to leverage GP for decades and whether you’re in need of a new implementation, upgrade, or just a partner who can help you with ongoing use, we’re there for you. We invite you to learn more about our services and contact us for more information.

Looking for FRx Replacements? New Webinar Explores Powerful Budgeting and Reporting Alternatives

Looking for FRx Replacements? New Webinar Explores Powerful Budgeting and Reporting Alternatives

FRx had a good run. Released as an MS-DOS application in 1991 and a Windows product in 1993, the product changed the way that companies completed reporting, offering powerful functionality at the time and much-needed intelligence. Acquired by Great Plains Software, who was in turn acquired by Microsoft, this reporting tool spent decades in the spotlight as the go-to application for reporting.

However, time passed and the competitive market evolved; by the end of the 2000s, FRx was no longer atop the reporting world and Microsoft announced that it would no longer offer new licenses for the product. Dynamics GP 2010 saw Management Reporter introduced as a replacement for FRx, a powerful alternative to an aging product. The beginning of the end for FRx was announced in 2010 and by December 2012, FRx sold its last license.

15 Minutes of Fame for Management Reporter

On December 31, 2012, Microsoft terminated support for FRx, marking the official transition to Management Reporter. The switch from the familiar FRx to the new MR platform was cause for concern at some organizations—long-time users of FRx lost the familiar Excel interface for a proprietary one and lost some small-but-unique features. In GP 2013, 2015, and 2016, MR was the stock application for reporting, but this all changed in 2016. Announced privately at Amplify 2016 and publicly a week later, Microsoft informed the world that there would be “no major enhancements” to Management Reporter.

While still supported until 2026 and available to integrate with Dynamics GP 2013, 2015, 2016, and 2018 (along with other Dynamics products), eight years is a long time to go without an improvement.

What’s Next? Modern Planning and Budgeting with Jet Global: October 30, 2018

With six years having passed since the last FRx license was sold and two since the last major Management Reporter update, many users are wondering what’s next for their budgeting and planning.

If you’re asking this exact question as you enter planning season, join Integrated Business Group and Jet Global Data Technologies for a brief one-hour webinar on Tuesday, October 30, 2018 at 11:00 AM EST. Click here to register or read more below.

In this webinar, technology experts will discuss the challenges of working with the no-longer supported Microsoft FRx reporting tool and no-longer updated Management Reporter, introducing two powerful budgeting and reporting solutions— Jet Reports and Jet Budgets.

Jet Reports

Imagine a familiar Excel-based interface, but smarter. If you miss the “good old days” of FRx (or are still using it) but are looking for a reporting platform that’s not only more powerful but provides continued support and updates, Jet Reports Professional provides both. With Jet Reports Professional, you receive fast, flexible financial and business reporting within Excel, giving team members access to advanced, accurate, and automated reporting data in a familiar interface.

The October 30 webinar will discuss Jet Reports functionality as the ideal replacement for FRx—providing a Dynamics-friendly reporting tool used by more than 14,000 companies.

Jet Budgets

Budgeting has always been a blind spot in ERP software. This isn’t a Dynamics-exclusive issue; few ERP platforms have the budgeting functionality needed by today’s business. Between design, collaboration, approvals and execution – there are numerous moving parts to the budgeting process that are often impossible to control. Unfortunately, this results in a chaotic, time consuming, and inaccurate approach to budgeting filled with email chains, inconsistencies, and animosity across the company.

Jet Budgets was designed specifically for Microsoft Dynamics and gives companies the power to control and streamline the budgeting process with a simple, adaptable, and easy-to-use fiscal planning solution. With automated workflows and an intuitive design, Jet Budgets allows organizations to cut their budgeting time in half, ensure consistency in the planning process, and fit an organization’s unique processes.

Take Control of Reporting and Budgeting: Join Us on October 30, 2018

From Excel-based reporting to GP-friendly budgeting, companies like yours are considering their next steps as they look to take control of their financial planning and analysis in 2019 and beyond. Join Integrated Business Group and Jet Global Data Technologies on Tuesday, October 30, 2018 at 11:00 AM EST to learn how Jet Reports Professional and Jet Budgets can be the perfect tool for your reporting and budgeting needs. Click here to Register.

IBG Presents: Benefits of Archiving Your GP Data (9/20)

IBG Presents: Benefits of Archiving Your GP Data (9/20)

When companies implement Dynamics GP, they immediately see the benefits it can provide for them. Fast, smart, and able to grow with them , this solution has been used for decades by mid-sized companies in need of a powerful and familiar solution. However, time passes, companies grow, and the amount of data your organization increases, resulting in a headache-inducing slowdown within the GP platform.

This is common—no matter how powerful a solution is, the more data it has to process, the longer it will take to process. Luckily, there is one way to clean up historical data in order to free up space. Company Data Archive has become a go-to solution for many organizations using GP, as it can increase performance and bring your GP solution back to its ‘glory days.’ This blog will discuss with you how it works and give you an opportunity to learn more in an upcoming webinar scheduled for September 20.

Why Should You Archive Your Dynamics GP Data?

Microsoft Dynamics GP is a powerful tool for organizations in need of familiar business management from a proven leader. As a whole, GP has been helping mid-sized businesses for decades, and is known for being a long-term business management solution—many companies will use GP through mainstream support and into or beyond the extended support phase.

Throughout the product’s use, however, the data begins to build up, putting increased pressure on processing power as the database for the live company continues to increase. As this happens, performance suffers, processing power decreases, and your productivity declines.

However, companies have found an easy way to overcome this challenge: Company Data Archive.

What is Company Data Archive and How Does It Help Improve GP Performance?

Company Data Archive provides organizations an easy way to improve Dynamics GP system performance. By moving historical information from your Microsoft Dynamics GP ‘live’ company to an ’archive’ company, organizations using GP can revitalize their system while keeping archived data available for reporting and decision support.

When you leverage the power of Company Data Archive to free up space, you can reduce hardware costs, increase performance, make upgrades and backups easier than ever, clean up clutter and more. This cost-effective solution can archive data from the following modules and more:

  • General Ledger
  • Bank Reconciliation
  • S. Payroll
  • Inventory
  • Sales Order Processing
  • Payables Management
  • Purchase Order Processing
  • Receivables Management

To help companies understand how the solution works and why it can help them, Integrated Business Group will discuss the power of CDA with attendees, introducing them to the process and answering questions at an upcoming September 20 webinar.

Join IBG on September 20 to Learn More

Would you like to maximize your Microsoft Dynamics® GP performance and minimize your time searching and waiting? Company Data Archive (CDA) provides an easy way to move historical information from your live company to an archive company. Archiving your data will reduce the size of your live company and improve performance while posting, running reports/inquiries/SmartLists, performing file maintenance, and much more.

During this session you will learn:

  • The benefits of archiving your GP data
  • How to optimize SQL Indexes & run GP diagnostics
  • How to analyze data distribution
  • How to perform an archive
  • What to expect after archiving

This one-hour webcast will take place on Thursday, September 20 from 11:00 AM EDT-12:00 PM EDT.

Click here to Register