Shipping options in Acumatica have been limited in the past, but now with Acumatica 2019 R2 and the integration with ShipEngine, you have your choice of over 20 different carriers. Think of ShipEngine as a carrier aggregator; whereas, in the past, you had your choice of FedEx, UPS (no ground options), and Stamps.com with limited … Read more
How to Resolve a Dynamics GP Microsoft Word Template Error
After modifying the SOP Blank Invoice format in Microsoft Dynamics GP, I received this error message: “We’re sorry. We can’t open SOP Blank Invoice Form because we found a problem with its contents.” Clicking “Details” provides additional errors: Microsoft Office cannot open this file because some parts are missing or invalid. Location: Part: /word/footer2.xml, Line: … Read more
From Collection to Application: Finalizing Your AR Payments
So many things go into the process of getting paid. Even if the quoting, the negotiations, and invoicing went smoothly, the process of getting paid, allocating a payment to an invoice, and accounting for a transaction presents its own challenge. Following last month’s blog discussing the challenges that go into getting the collections process, we … Read more
Acumatica Mobile Enhancements from 2018 R1 to 2019 R1
On the precipice of the next release (be sure to register for your local roadshow here), we’ve decided to take a look back at the mobile app enhancements that users have access to. Acumatica continues to get even better, and here are just a few reasons why. Acumatica Version 2018 R1 Enhanced Addition of Dashboards … Read more
How to setup EFT for payables and generate the ACH file using Dynamics 365 Business Central
Both payees and accounting professionals love electronic funds transfer (EFT), and for good reason. It drastically reduces the time required to process payments, eliminates paper, and helps avoid fraud. There are three windows that must first be set up properly to be able to use the EFT/ACH feature in Microsoft Dynamics 365 Business Central: Company … Read more
Sync Team files with OneDrive for Quicker Access
One of the many benefits of Teams is that you can sync a Teams Channel file space with your local OneDrive. This allows you to work with files locally without touching the Teams interface. This works great when you need to jump to and from several different files throughout your day, or if you need … Read more
How to Embrace the Digital Technology Revolution in the Fabrication Industry
Fabrication companies face an onslaught of challenges. Offshoring, recruitment, commodity fluctuation, and more—but one of the most pressing issues? Many are falling behind technologically. From marketing to management, the phrase “digital technology revolution” is a top priority for fabricators. Why Digital Technology is Right for Fabricators There is good reason for this: the increased presence … Read more
Are You Getting the Satisfaction You Deserve from Your ERP?
Analysts love to look at software. Whether it’s the ability to execute and market presence, functionality and usability, or any of the other criteria for ranking vendors and products, one of the most important albeit overlooked criteria is whether users like the software. Often, it’s hard to convince someone to review a product, and unless … Read more
Can the Risk of Ransomware be Eliminated with Cloud ERP?
There are many good reasons to switch your ERP (Enterprise Resource Planning) solutions to the cloud: cost, convenience, versatility, security, etc. But one especially good reason is the amount and types of risk that can be mitigated with Cloud ERP. What Risks are On-Premise Systems Vulnerable to? One of the major risks that organizations face … Read more
View Historical Transactions with Negative Amounts Based on Document Types (in SmartList Designer for Dynamics GP)
SmartList Designer Tips Next in our series of SmartList Designer blogs, we’ll look at optimizing a basic purchasing SmartList. (If you need a refresher on SmartList Designer, or missed the first blog, you can find it here.) Let’s say that a purchasing manager wants to view all the historical transactions for a vendor. However, the … Read more
How to Create a SmartList in Dynamics GP that Displays the Correct Email Address
SmartList Designer Tips for Dynamics GP As most Microsoft Dynamics GP users know, with every version of the system comes with the advanced reporting tool called SmartList. Out of the box, SmartList has several pre-made reports to choose from, all of which pull directly from your Dynamics GP tables, and are column-based (meaning Excel-friendly). In … Read more
Paper Pains and Spreadsheet Woes: Challenges for Growing Businesses
Take a look at your desk. What do you see? A stack of invoices, receipts, or other paper? Open your inbox. How many emails have an attached spreadsheet that needs to be edited? For growing businesses, the use of paper and spreadsheets is common, but as you grow, continued reliance on these is going to … Read more
The Last Mile of Quote-to-Cash: Getting Paid
When you think of the concept of quote-to-cash, there are many steps that go into the process and many areas for improvement. From the initial configuration and pricing to the contract creation and negotiation to sending the invoice, everything needs to move forward quickly and accurately. Following our last blog on the quote-to-cash process discussing … Read more
How to Set a Default Value to Auto-fill in Acumatica
Tips from Acumatica Development I recently had a request to set a default value on a grid with the value of the field from the line above it. Let’s suppose you want to default the quantity on the Bills and Adjustments screen, with the quantity from the prior line. Consider using the pattern below. … Read more
Get Paid Faster by Creating the Best Invoice Possible in Dynamics 365 Business Central
You probably already know that you can email invoices directly from Microsoft Dynamics 365 Business Central with its seamless integration with Outlook. But the integrations don’t stop there. Did you know that you can take it a step further by accepting electronic payments using Microsoft Pay or PayPal? Do you know how easy it is … Read more
Easy & Low-Cost Protection against Ransomware
Every day, we hear horror stories about businesses losing money to ransomware attackers. All it takes is one person to open the wrong email and instantly, all your data is held captive unless you pay up. Recently, Riviera Beach, Florida was a victim of this type of attack, crippling the entire city’s computer system. It … Read more
Inventory Valuation Methods in Dynamics GP
Valuation methods are what determines how the costs of inventory items are calculated. There are several different methods you can use in Microsoft Dynamics GP. I recently had a client question how the various Inventory Valuation Methods in Dynamics GP differ. In this client’s case, the valuation they were using did not make sense for … Read more
Dynamics GP Workflows Not Working with a Gmail Account
As I was working with a client, I experienced an issue getting Workflow Emails to send using a Google/Gmail account. Even though I entered all the necessary account and SMTP information, I couldn’t get the test email to go through the Workflow Setup window in Dynamics GP 2016. No Errors I attempted to send the … Read more
How ERP and CRM Integration Facilitates the Quote-to-Cash Process
Revenue is at the heart of your business. You can make the best product or provide the best service in the world, but if you’re not bringing in money, you won’t be in business for long. Few—if any—businesses can survive for long providing a poor buying experience for their customers, and as your business grows, … Read more
What do the Experts Think about Acumatica 2019 R1?
Recently, while attending our Acumatica team meeting, the conversation evolved into unfiltered comments from our consultants who are working with the new version, Acumatica 2019 R1. Here’s an overview – highlights, pros & cons, and some questions: Highlights First of all, everyone is excited about how many added features and changes were packed into Acumatica … Read more
Cool Animations in PowerPoint Using Motion Paths to Move Objects
It’s been a long time since I’ve found something this cool in Microsoft PowerPoint, so I had to share! Motion paths for animating objects in PowerPoint. Using power point animations to move objects is a great way to stand out in your presentations. PowerPoint Motion Path : My manager came to me one morning with … Read more
4 Dynamics GP Challenges and How to Address Them
Microsoft Dynamics GP has been a mainstay in the ERP community. Designed for small and mid-sized businesses who want a reliable and well-vetted solution, GP has evolved and grown to be one of the most trusted ERP vendors for this market. However, no matter how consistent this solution is, no matter how powerful, there are … Read more
Learn Power BI the Easy Way
Are you interested in Power BI? Maybe you’re wondering what it can do for your business and Dynamics GP data? We recommend starting with this Microsoft self-paced, hands-on learning tutorial, “Explore what Power BI can do for you.” You will learn: Understand Power BI service basic concepts and terminology. Find your content in dashboards, reports, … Read more
“Maximum Number of Users” Error in Dynamics GP
We ran into an issue recently where client would receive the following error when logging into Microsoft Dynamics GP even though licenses are available: “The maximum number of users are logged into the system.” Clicking OK closes Dynamics GP. What is also strange is that the “Users Allowed” and “Current Users” fields both show 0. When logging in with SA, there are … Read more