Microsoft is set to update Tasks in Outlook on the web at the end of October, with the full rollout be completed by December 2019. What does this mean to you? Nothing really, just a new name, from “Tasks” to “To Do.” Personally, I’ve never used the Tasks feature to its fullest potential. I’ve added … Read more
Add Signature to Check within Acumatica
If you work in accounts payable, you know that check runs can be a pain, and would welcome any ways to expedite the process of printing checks. Crestwood to the rescue! Did you know that in Acumatica, you can add a digital signature to checks before they print? Here’s how: Adding the Signature to the … Read more
Three Different Methods to Post a Purchase Invoice to a Vendor Account in Dynamics 365 Business Central
Microsoft Dynamics 365 Business Central is still the new kid on the block, but is rapidly making waves. As more and more of our clients make the leap to this versatile and robust system, we have decided to publish a series of blogs on how to use Dynamics 365 Business Central. This post will detail … Read more
Display Unit Price and Gross Profit along with Item Master Data (in Dynamics GP)
SmartList Designer Tips The next SmartList Designer tip is for the inventory module in Microsoft Dynamics GP. When you view the item master data view that comes out of the box, some fields like unit price and gross margin aren’t available to display as a column. This is because that data is stored in a … Read more
The October 2019 Release of Dynamics GP: The Era of the Modern Lifecycle Policy
Microsoft just made an exciting announcement: the next release for Dynamics GP is dropping on October first of 2019, and will be called simply “Microsoft Dynamics GP.” You read that right! No year or version marker at the end. Dynamics GP has made the move to a “Modern Lifecycle Policy.” What is a Modern Lifecycle … Read more
Shipping Made Better with ShipEngine and Acumatica 2019 R2
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