Query cannot be previewed due to the following problem – there are no columns defined
We recently came across a case where Integration Manager was not able to read any records despite the fact that the source file referenced in the integration was correct and contained valid data when the file was opened in Notepad. When we tried to preview the file contents, we received the following message: For whatever […]
How-to Reconcile Inventory
Inventory reconciliation is the process of comparing your company’s physical inventory to its recorded inventory in the accounting system. It helps your business to ensure the accuracy of your inventory data and identify discrepancies that may indicate theft, shrinkage, or other operational issues. The inventory reconciliation routine checks the tables and transactions to ensure that […]
How to Move from Microsoft Dynamics GP to Business Central: Migration Guide
Thinking of moving from Dynamics GP to Business Central? You’re not alone. Thousands on companies are exploring a modern, cloud-based ERP to replace Dynamics GP. In this guide, we’ll walk you through the process of migrating to Dynamics 365 Business Central – including what to expect, how it works, and key tips for a smooth […]
How-To Add the Date Posted Field into a SmartList
We have recently received several inquiries on obtaining information as to when specific accounting entries have actually been posted, as opposed to the GL transaction posting date. Getting this information from Dynamics GP is not that difficult, so follow these steps to solve the problem. In the example below, we will be using SmartLists to […]
Why Do PDF Jobs Freeze When Printing Documents
Just after completing an upgrade to Dynamics GP 18.4 recently, we ran across an issue where Adobe Acrobat seemed to be freezing up on the RDS server whenever users attempted to print Sales Order Processing documents. When we researched the recommended version of Adobe Acrobat, the system requirements document pointed us to an old version […]
How Do I Change the Value of a Fixed Asset
If you have the need to change the value of an asset that was already put into service, you can change the value of the asset by following the steps below: As usual, we suggest having a SQL Server database backup of the company database on which you will be working; have a DBA or […]
How-To Change the Default Printer in Dynamics GP
A common inquiry we receive from our clients is how to change the default printer in Dynamics Great Plains (GP). In order to change the default printer, you simply need to go to Dynamics GP, click on the main GP drop-down menu and select Print Setup. Within the Print Setup window, you may go ahead […]
How-To Close a Year in Dynamics GP
In order to ensure you have followed the correct closing procedures please read this article from Microsoft with the steps of each procedure, detailed information on each step, and also some frequently asked questions about Year End Closing Procedures. KB -Year-end closing procedures for General Ledger in Microsoft Dynamics GP At a glance, this checklist […]
How-To Process 1099s in Dynamics GP
During the tax season it is important to know how to look up 1099 amounts, correct them if needed, and generate the report. The IRS has changed the 1099s format this year so be sure to use the latest version. For further questions on this update, or to make sure you have updated correctly, contact […]
How-To Schedule the Automatic Email of a Dynamics GP Report
A key feature of the reporting tool within Microsoft Dynamics Great Plains (GP), is known as SSRS, SQL Server Reporting Services, it has the ability to send out important reports on a timely basis. This means that admin users can automate their SSRS to send reports directly to key personnel through subscriptions. By managing these […]
