Upgrade Issues When Upgrading To Microsoft Dynamics GP 2018 R2

When I was upgrading to GP 2018 R2 I received an error.  The error was:

“The stored procedure SynchronizeTableData() of form duSQLAccountSynch : 27Pass Through SQL returned the following results: DBMS: 2601, Microsoft Dynamics GP: 0.”

I searched online and did not find anything about it for GP 2018.  I did find this article which helped me find the errors one at a time.


Thank you Sarah Purdy for the article!

By creating a dexsql.log, you can see what table is causing your problem.  Here is the link on how to start one.  Note that the log file will be in the same directory as the dex.ini file.


It turns out that there are some duplicate records found in the ASIEXP86 Table.  After removing all the duplicates the upgrade process continued successfully.


Hope this helps!



How to Use Microsoft Dynamics GP


How can you use Microsoft Dynamics GP in order to improve your business and help drive your company towards success? Well, it is fairly simple! This program is designed to be easy to use, so you can enhance your company without any hassles!

What Can It Do For You?

Microsoft Dynamics GP is a highly customizable program that is designed to grow alongside you and your company while providing you a number of different features to help you run your business! Some of the features it provides include sales, customer service, human resources, payroll, financial management, inventory management, business intelligence, accounting, operations, reporting, and much more! Basically, it is able to run the entire business for you while you control it at the tip of your fingers.

Dynamics GP can even automate many of the different processes of your business, so you will not have to worry about a thing! This will allow you to put your attention on more important aspects of the company.

Easy to Use

If you are familiar with other Microsoft programs such as excel, word, or outlook, then you will feel right at home with Dynamics GP! You can even use this nifty program on your smart phone and tablet as well, allowing you to easily manage and handle your company anywhere and everywhere!

When you first open up this program, you will notice a wide array of different things designed to help make it easier to run your business! As a matter of fact, the learning curve is pretty low because if you know how to use excel or word, then you will know how to use this program! Microsoft designed it to allow people to simply jump straight into it and start improving their businesses right away.

If you are interested in learning more about Microsoft Dynamic GP and how it can be used to improve your business and get you on the path to success today, simply give ERP Consulting LLC a call today at 614-342-0098. We are more than happy to answer any questions that you may have!

What is Microsoft Dynamics GP?

Microsoft dynamics GP is a program designed to assist small to medium sized companies with enterprise resource planning. This program allows you to have a greater amount of control over many different kinds of aspects of your company such as your operations, your inventory, and your finances. The best part is the fact that it is very easy to use!


When you are trying to run a successful company, it is very important to keep into mind a wide range of things regarding your operations. You need to keep into mind what your employees are doing, what you are producing, and how effectively your business is running. However, Microsoft Dynamics GP can help simplify the entire operations of your business and handle them all at the tips of your fingers! When your business becomes easier to run, you will be able to focus more on improving your company and earning success!


Managing your inventory can be tricky at times, especially when you have plenty of products and items to manage. However, when you use the Microsoft Dynamics GP program, it will make inventory management a walk in the park! You will no longer have to worry about the huge hassles of managing every item and keeping tracking of everything because this program will handle it for you, allowing you to streamline your inventory and improving your productivity. After all, organization is the key to success!


Obviously, if you are going to run a successful business, you are going to need to make sure your finances are all in order! So how can you organize your money and make sure that it is being spent in effective ways? Simply use Microsoft Dynamics GP! This program can help keep all of your finances organized so you know exactly where your money is going and how it is being spent, so you can better control your business!

If you are interested in learning more about Microsoft Dynamics GP in Pataskala Ohio, simply give ERP Consulting LLC a call today! Our number is 614-342-0098, so do not hesitate because we are here to help you improve your business!

Microsoft Dynamic GP Manufacturing Features That Your Company Needs Most

One of the biggest issues in Manufacturing businesses is the lack of agility and efficiency. Like every other line of business, manufacturing greatly needs optimization in all the aspects of business, such as supply chains, financial management, materials management, among others. As an experienced business consulting firm, at ERP Consulting LLC, we have helped companies overcome these issues by implementing Microsoft Dynamics GP as an ERP Solution. The best thing about Microsoft Dynamics GP is that it comes in modules that are specially designed for every aspect and type of businesses. For example, in the manufacturing department, it offers comprehensive and powerful major features and add-ons that address and eliminates issues and inefficiencies and provides automation in transactions, including:

  • Manufacturing Order ProcessingIt’s one of the core features of the manufacturing module and streamlines the entire process of manufacturing. This function determines the many alternate assembly routes that are available for every manufactured item. To make the process accurate, it also enables easier tracking of production, machinery, and detailed labor information, such as skills, work hours, schedule, and shifts.
  • Sales Forecasting and ConfigurationWith this feature, you will be able to look back on the sales from the previous years for reference as well as a request for a sales forecast for a certain period of time in the future. This helps you understand whether or not there is a need for some changes in a certain department for the company’s continuous growth. The sales configuration function also provides amazing features, such as simplifying order process, enhance quoting and shipping of products, calculating total costs of every sold product, and estimating the completion date of every order.
  • Financial ManagementOne of the biggest issues that businesses face is inefficiency in financial management. Microsoft Dynamics GP overcomes this by automating processes. It automates every transaction process as well as payment adjustments for increased productivity. You can create budget templates as many times as you need and improve your financial and audit control.
  • BOMEvery finished product requires an active Manufacturing, Engineering, and Archived Bill of Materials. This feature lets you easily make changes and updates on the BOMs, as well as make alter revision levels and record their history for future reference. On top of all that, the software will also make a comprehensive analysis of finance, sales, and purchases, make complete and real-time reports, and simplify the management of payables and receivables.
  • InventoryThe latest version of Microsoft Dynamics GP also provides an inventory all-in-one viewer where you can access and view all the inventory information you need, such as quantity in, quantity moved, and quantity out. You will be able to see where a certain quantity is sent to or received from, along with extensive details about the transactions.
  • Job CostingThis helps make finance management efficient by spotting unreasonable cost contributors and variances and eliminate duplicate entries in the system that could possibly lead to errors in the future. Other than that, it also makes capturing job costs automated for enhanced efficiency.

Manufacturing can be really challenging and complex but with the speed and efficiency that Microsoft Dynamics GP provide, all tasks can be simplified and streamlined. You will have the ability to automate the major processes and transactions and retrieve all the information you need to make business decisions in complete detail. If you want outstanding business solutions to overcome inefficiency in your company and grow your business, ERP Consulting LLC has a team of professional consultants that are experienced in implementing Microsoft Dynamics GP in Pataskala Ohio to help you. Let’s begin the process of achieving your massive business success by calling us at 614-342-0098.

All about Landed Cost Formula

Just how much are you spending on importation? Is it worth it?

Starting a manufacturing or retail business can be tricky. You need to consider where you source your raw material supplies (manufacturing) and ready-for-sale products (retail). Clients who source materials from a different part of the globe are called Importers. They may experience miscalculation of pricing of goods the first time around because of improper cost accounting. As an importer, you should know that the cost of materials you buy is not the only amount you pay. There are other charges you may not know of yet. This is where the Landed Cost Formula comes in.

What is Landed Cost Formula?

In a nutshell, Landed Cost Formula is the full amount you spend per imported good or material. This takes into account the following: Price of Imported Good, Freight Costs, Insurance, Storage Costs, Customs Duty, Tax, Customs Clearance, and more.

Clothing Manufacturing Business

Let’s say you are a clothing manufacturing business and you need to source out raw materials from China. You will definitely need cloth, sewing materials, and the like. If you check out your supplier’s prices, they seem reasonable. However, because that is not the only money you cash out upon delivery, it is important for you to understand other expenses you will be paying. Your Chinese supplier may not know the Customs Duties and Taxes in your state, so you may talk to your customs department for more information.

How Do I Calculate my True Landed Cost?

There are some clients who complain that they only get to know how much they really spent long after their shipments have arrived. Factors like foreign exchange rates, additional customs payments, and FOB can destroy your initial costing. This is why you need to have a clear idea of all costs you may be incurring and use estimates in your computations. To make smarter decisions, Enterprise Resource Planning (ERP) Software is readily available to help you do just that and focus on running your business instead of worrying about cost accounting.

How ERP Consulting LLC Can Help

ERP Consulting LLC has a dynamic knowledge on different businesses that plan to operate with global connections. We help to install Microsoft Dynamics GP in Pataskala Ohio so you can better choose which materials to source for your products. Our firm also offers support and after-sale services so you need not worry about improper guidance. Check out our Web site for more information at erpconsultingllc.com or give us a call at 614-342-0098.

Microsoft Dynamics GP will help you gain better control on all aspects of your business. This includes management of costs, inventory, accounting, human resources, customer relationship management, and more. Call us today and take the next step to your business’ growth!

Businesses and ERP

Businesses like ERP Consulting LLC, an expert on Dynamics GP in Pataskala Ohio, have become a great help for organizations wishing to adopt an ERP system. What is ERP and why are organizations very eager about it?

The Typical Process
In a typical business operation, when a customer calls for an order, it first goes thru the sales department, which then checks the inventory for product availability.  If no product is available, it will contact the production department, which would check the inventory for the materials and buy the unavailable materials from a third party vendor. When the product is finished, the sales department will then deliver the product to the customer. After the transaction is done, all the financial reports of the sales department and production department will then be submitted to the finance department for records of sales and expenses. It is a long and complicated process, which is also prone to errors and miscommunication between departments.

What is ERP?
ERP helps eliminated all these problems and gives your business an easy and smooth flow of operation.

ERP or Enterprise Resource Planning is a system, which manages the information of your business in a centralized manner. It integrates units of your business needed in the operation, which are product planning, manufacturing, marketing, inventory management, and shipping and payment.  Also, all the information goes through the system in a (or nearly) real-time basis thus avoiding data duplication and provides accurate information to all departments.

How does ERP work?
So, how would a business using an ERP system work?

When a customer calls for an order, sales department will just check the real-time information stored in the centralized system and can inform the customer whether the product is available or not.  And since all the departments have access to the centralized system, unavailable products can be manufactured faster which can lead to increase in sales and improved customer relations.

Here at ERP Consulting LLC, we can assist you on how to implement Dynamics GP into your business. We are an expert on Dynamics GP in Pataskala Ohio. For ore information about ERP and Dynamics GP in Pataskala Ohio, please contact of visit us at ERP Consulting LLC. Let us help you find the best

4 Benefits of Microsoft Dynamic GP’s Collection Management

Collections can be a really tedious process and, when mishandled, can cause a major financial trouble. Good thing, Microsoft Dynamics GP, a solution that we, at ERP Consulting LLC, a company that implements Dynamics GP in Pataskala Ohio, has a feature called Collections Management, a tool that will streamline collection process and reports.
Here are some of the ways your company can benefit from the Collection Management system:

1. Decrease DSO
Days Sales Outstanding (DSO) is a necessary statistic in determining your Accounts Receivable, the money debtors owe you. DSO determines your sales and how fast you get paid for it, therefore it’s a way to know how efficient your collection process is. Microsoft Dynamic GP’s collection management feature will help you keep track of it in order to easily realize your Return of Investment.

2. Keep Payments History and Notes Centralized
Collections Management has a centralized area for tracking notes, arranging follow-ups, and setting actions on invoices. With Microsoft Dynamics GP, everything is there, from creating actions to keeping histories and notes on customer invoices. Having a centralized area for contact and collections information will boost your company’s efficiency.

3. Automate Follow-Ups and CollectionsA feature called “Collections Plans” will suggest all the customers you need to contact, as well as, automate all the steps in the collection process. It helps reduce your time searching for customers, creating e-mails, and manually attaching invoices. This system has a sequence of actions that are automatically suggested according a particular invoice’s due date. With this, you will significantly reduce the time to be allocated in organizing data and communicating with your clients, and be able to concentrate on other aspects of your business.

4. Simplify Reports GenerationIt provides a summary of Account Receivables and enables you to view information by collector, by national account, or by a group of customers. It also includes “SmartList”, a tool to dissect data, and a performance report for every collector. All these things will deal with the problems that customers have and the inefficiencies of the collectors.

The points above explain how the Collections Management feature of Dynamic GP, a business solution that we offer here, at ERP Consulting LLC, the leading source for Dynamics GP in Pataskala Ohio, enables you to enhance your cash flow and prevent financial mismanagement resulting to bad debts. Timely collection of receivables is very important in business as it promotes better cash flow. With Dynamics GP, you can be sure to have a more efficient and productive collections process. To get Dynamics GP in Pataskala Ohio, schedule an appointment with us, at ERP Consulting LLC, anytime. Call us at 614-207-1782.

How to enter a wire transfer in Dynamics GP

Go ahead and perform the wire transfer thru your bank.  Then in GP use the manual check entry.  After entering the date and vendor id select payment method of Cash.  Enter the checkbook .  After entering the amount you can click on the apply button and apply this payment against the invoice it is paying that is already in the system.

How to correct costs on Key2Act jobs

To correct postings to jobs in Key2Act job cost you will use the GL General Journal entry. You can use this to add costs to jobs, transfer from one to another or to remove the cost from the job.

1) To add a cost to a job – When you get to the product indicator select job cost then the job and cost code. A debit will increase the cost to the job. You will then select unbilled for the second line and select the GL account that the transaction had been posted. Probably would be a cost of goods sold or subcontractor.

2) To transfer a cost from one job to another – When you get to the product indicator select job cost then the job and cost code. Enter a credit transaction to reduce from a job. Then on the second line on the product indicator select job cost then job and cost code. Then enter a debit balance. This will add the cost to this job.

3) To reduce a cost to a job – When you get to the product indicator select job cost then the job and cost code. A credit will decrease the cost to the job. You will then select unbilled for the second line and select the GL account that the transaction had been posted. Probably would be a cost of goods sold or subcontractor.

Highlights of Microsoft Dynamics GP

Microsoft Dynamics GP, the solution we promote here, at ERP Consulting LLC, a trusted consultancy firm that implements Microsoft Dynamics GP in Pataskala Ohio, is an accounting software and ERP solution that is designed to meet the needs of companies, especially the small and medium scales, to make their systems more efficient and help their business grow successfully. Microsoft Dynamics GP helps improve every aspect of your business, including financial management, supply chain management, reports, smart decision-making processes, and more.

Microsoft Dynamics GP is packed with features, familiar and new, that meets all the needs of your business to grow and improve and that is why we, at ERP Consulting LLC, choose to promote Microsoft Dynamics GP in Pataskala Ohio for our clients to have the best ERP solution for their businesses. The following are some of its key features:

Familiar and Easily Adaptable

Microsoft Dynamics GP provides you with robust out-of-the-box functionalities that are very easy to learn and use as they are designed similarly and works with other Microsoft applications that people, and your employees, use every day, such as Outlook, Word, and Excel.

Boosts Productivity

Microsoft Dynamics GP allows you to integrate and automate all your financial and operational processes quickly and smoothly. As a result, the ability of your employees and customers to exchange and share data will be greatly enhanced. This boost in productive is mostly because of the following reasons:

  • It is highly scalable, with a proven scalability to at least 1,000 users and provides you with robust functionality across financials, manufacturing, service, distribution, and integrated Customer Relationship Management.
  • Recent Studies conducted by Nucleus Research show that 87% of the clients implementing Microsoft Dynamics GP achieved a positive Return of Investment from their deployment.
  • The software provides users with an individualized and role-based experience so they don’t have to worry about learning more things other than the navigations and functions relevant to their tasks which would otherwise be a waste of training time and costs.
  • It provides the users with detailed and up-to-date reports, as well as notifications on what specific actions they have to perform, in order for them to make smart decisions quickly and effectively.
  • Every single record and information can be sharable to avoid miscommunications and conflicts.

Enables Better Decision-Making

Because it provides the administration and decision-makers great visibility of the business and all the processes involved, it will enable them to make smarter decisions towards improvement and efficiency of the business.

Managing and growing a company can be simpler, having an ERP solution that provides you will all the major assistance you need. To get Microsoft Dynamics GP in Pataskala Ohio, you can set an appointment with us, at ERP Consulting LLC, by calling 614-342-0098.