Crestwood Associates has been using Microsoft Teams for a while now, but I still get calls and questions every day about where something is located. Teams is great for collaborating, meetings, etc., but even I forget where something is at times. This article is going to show you tips and tricks for searching in Teams. … Read more
How Do You Sign a Document Working Remotely or Without a Printer?
There’s no doubt that working from home can be challenging, especially if you don’t have an office full of equipment. If you don’t possess a printer, how do you execute documents that need a signature? If you are running Acumatica, you can integrate the signed documents directly into your system where they belong. There are … Read more
How to Share Teams Recordings with People Outside Your Network
When your business relies on technology, it is good to know what you’re doing or at least have someone handy in IT that can help. I recently conducted an online Teams training, to which the client requested that the meeting be recorded so that it can be shared with other team members who were unable … Read more
New Financial Features in Acumatica 2019 R2
Acumatica 2019 R2 was released in September, 2019 and included more than 100 improvements, enhancements, and new features. The release notes are extensive covering additions in the platform, usability, financial management, project accounting, inventory and order management, construction, field service, and manufacturing. Many of these new features were developed by user requests, to make Acumatica … Read more
Automatic Alt Text for Images in Microsoft Word
Did you know that every time you add an image to your Word document, it automatically generates “Alt Text?” Do you know what Alt Text refers to? Alternative Text or Alternative Descriptions are written copy that describes the image. This text also helps screen-reading tools describe images to visually impaired readers. It will appear in … Read more
4 Tips for Mastering Your Microsoft Outlook Calendar
With so many of us working from home, what would have been a conversation over a cubicle, now requires a scheduled meeting. Here are some tips for getting more out of your Microsoft Outlook Calendar and how to get a meeting on the right calendars, fast! 1. Quickly View Calendar without Switching Screens Tired of … Read more
Dynamics GP and SQL 2019 – Internal error: “An expression services limit has been reached”
With a recent Dynamics GP upgrade, we ran into a unique error message that we had not seen before: This error was appearing in various Navigation Lists in GP 2018 R2 on the latest version. Examples of Navigation Lists impacted included the following: All Purchasing Transactions Purchase Orders Not Submitted Purchase Requisitions Pending Approval Other … Read more
Exporting Dynamics 365 Dashboards using Power BI
Quite often, we find clients that want to export or share dashboard information from Microsoft Dynamics 365 for meetings and updates. Maybe you want to export a dashboard view into a PowerPoint slide or create a PDF to share. One way to do this is to take a screen shot, but often the quality is … Read more
Acumatica 2020 R1: New Financial Features
I know you probably love reading all the release notes for the new versions of Acumatica, but I’ll save you some time and give you the cliff notes. Here is a list and screen shot of the new financial features in Acumatica 2020 R1. Banking Payables Receivables Fixed Assets Taxes Banking Validate External Transactions Form … Read more
Using Item Extended Text in Dynamics 365 Business Central
Microsoft Dynamics 365 Business Central allows users to add a field to any document called “Item Extended Text.” Item Extended Text is a great way to display any additional information about an item on various document forms. The user can choose which documents to display the additional text on along with a date range if … Read more
AP Bills and Adjustments: Using Pre-Release vs. Release in Acumatica
Now that we are all working remotely, we need new ways to get our job done and collaborate with our teams. This often means using our ERP solution more effectively. Today we will review the Pre-Release functionality in Acumatica Accounts Payable and how it’s used for quick AP Bill Payment. The Acumatica Accounts Payables module … Read more
Copying Reports and Word Templates to Create History Versions in Dynamics GP
Here’s a time saving way to duplicate format changes to your other reports, historical versions of reports, and documents in Dynamics GP. There are a couple variations on how to do this, depending if you are using the Dynamics Report Writer or Word Template. Once you have modified the SOP invoice form that is in … Read more
Upgrading Protects Your Business
During these unique and challenging times, I’ve been talking with clients on how planning is more important today than ever before, so you can be prepared. One of the topics of questions is upgrading. I had a client ask me “Why is it important to upgrade?” My first response was, “Don’t you want to protect … Read more
Month-End Procedures for Acumatica
While all companies have their own internal accounting month-end procedures to follow (and still should), here are some month-end processes that are important to complete each month in Acumatica. Batches from all modules should be reviewed and released/posted that are still unreleased. Recurring entries for that period should be generated and released/posted. All journal entries … Read more
Importing Journal Data with Multi-Currency ID in Dynamics GP
If your business works with foreign vendors or customers, you might want to set up foreign currencies in Microsoft Dynamics GP. To use more than one currency, one must set up Multi-currency Management. I have had many clients ask me about copying and pasting in data from Excel, but unfortunately, you cannot use the ‘Paste … Read more
Helpful Hints When Implementing Avalara AVATAX in Dynamics GP
Avalara AvaTax connects easily with Microsoft Dynamics GP to deliver a robust sales tax automation tool. If you are a business running Microsoft Dynamics GP, it’s easy to automate your sales tax compliance process using AvaTax. Here’s a quick demo from Avalara if you want to see AvaTax in action. It’s fast and easy it … Read more
How to Remove Top Results From Outlook – 3 Easy Steps
Just when I started to get along with my Outlook search, Microsoft went and changed it. “Top Results” arrived in my searches and didn’t work well for me. The messages at the top were NOT the most recent, even though I had my inbox sorted by date range. The most recent email in a thread … Read more
How to Cancel a Drop-Ship PO for Stock Items in Acumatica
Do you have inventory items you do not stock? Using a drop-ship PO to have the vendor fulfill the sales order is a common and seamless process with Acumatica. In most cases, the drop-ship sales process is completed when the customer receives the items from the vendor and the corresponding AP and AR documents are … Read more
Assign Default Expense Accounts for Vendors Using Purchasing Codes in Dynamics 365 Business Central
There is a feature in other accounting systems such as Microsoft Dynamics GP to assign a default expense/purchasing account to a vendor. This account then defaults as the debit when invoices are entered for that vendor. Good news! The same solution exists in Dynamics 365 Business Central using Recurring Purchase Lines to speed up data … Read more
Copy Purchase Invoices to Speed Up Data Entry in Dynamics 365 Business Central
In Microsoft Dynamics 365 Business Central, when creating a new Purchase invoice, you can easily copy a previous posted or unposted invoice from any vendor. This is especially helpful if the same G/L accounts or amounts will be re-used. To create a New Purchase Invoice, enter the Vendor Name then go to the Actions>Functions and … Read more
Beyond Borders: Why Currency Management Matters
Whether directly or indirectly, every business is a global business. Somewhere in the supply chain—from your suppliers’ suppliers to the customers of your customers—you’re part of the global business environment. Though this means increased risk, it also means increased opportunity. New customers, better prices, and lower shipping costs, the global marketplace has opened you up … Read more
How to Define a Default Expense Account for Vendors in Dynamics 365 Business Central
In Microsoft Dynamics 365 Business Central, in order to define a default G/L expense account for different vendors, the vendor will need to have a specific General Business Posting Group assigned to it. [This is the next blog in a series of tips for using Dynamics 365 Business Central. For the previous Business Central tip … Read more
Working From Home (WFH)… The New Normal
Crestwood employees have been working from home for quite some time now, but it’s an adjustment for us too. For me, I’m not used to having kids around 24 x 7. Therefore, that adds an interesting challenge to the day. No matter your situation, we want to help make things easier for you. We have … Read more
OFFICE 365 UPDATE: No Better Way to Collaborate Other than Chat
Update from January 2020 Post: No Better Way to Collaborate Other than Chat Microsoft is eliminating the ability to initiate a chat directly with a co-author of Word, Excel, and PowerPoint document. This change will take affect mid-April (across the web, Windows, and Mac versions of Microsoft Office). Moving forward, users can communicate with others … Read more