When integrating third-party programs into your accounting system, the tendency in implementation is to take the data that is the third party program and force it into the accounting system.

Each month as part of the month end reconciling process you will want to confirm that your GL Accounts Payable account ties to your payables sub-ledger.

First you will want to generate the Historical Aged Trial Balance Report in Purchasing. To do this go to: Purchasing > Reports > Trial Balance. Reports: Historical Aged Trial Balance. Options: Month End or default (this will depend on your report options settings). In the Report Options window you will want to select the date to Print/Age as of, select the last date of the month you are reconciling. I recommend generating this report In Detail (mark the In Detail box), but you could generate it as a summary report.

In my previous blog post Entering Invoices Paid by Credit Card - Non-inventory Transactions, I went through the process for entering non-inventory transactions that are paid by credit card. In this post I will provide the process for invoices related to inventory for Dynamics GP.

A new feature of Dynamics GP2013 SP2 allows users to users to hide the navigation tree in Smart Lists giving them a full screen of data. The first two users in our office that opened a Smart List were thrilled! However, their excitement abated when they realized that the tree view in the navigation pane seemed to be static and left/right scrolling was required to view longer Smart List titles in the navigation pane.

Inventory is simple. It involves the simple processes of receiving specific items, selling specific items and counting specific items. How is it that this simple process with specific items lends itself to so much inaccuracy and confusion? Many of our clients ask the same question, and after many years of dealing with incorrect inventory counts and multiple systems related inventory issues, I have determined a couple of reasons for the inventory dilemma.

Our clients frequently purchase by credit card. While credit card purchases are easy for the purchaser, the management of credit card purchases can be difficult for the accounting department. With the process outlined below, you can accurately track credit card purchases for each transaction, and track the purchases made with a specific vendor as well in Dynamics GP.

Reason codes are a new feature of Dynamics GP 2013. I have found a number of references and blogs about their use, however, none touch on why users have the following occur when they try to enter a reason code:

Occasionally you will have the need to print partial checks out of Dynamics GP. One reason is that you need to create a payment for a deposit, and you have not yet received an invoice. Another reason is that you wish to pay an invoice in multiple payments. In order to create these partial checks, you will need to create the check individually, rather than using Select Checks. Below I have the steps for this process.

If you are enter drop ship Sales Orders in Dynamics GP 2013, using Shipment Notification and are generating linked Purchase Orders from Sales Orders, you may receive the following notice after you transfer your sales order to an invoice and attempt to post the invoice:

Each month as part of the month end reconciling process you will want to confirm that your GL Accounts Receivable account ties to your receivables sub-ledger.

First you will want to generate the Historical Aged Trial Balance Report in Sales. To do this go to: Sales > Reports > Trial Balance. Reports: Historical Aged Trial Balance. Options: Month End or default (this will depend on your report options settings). In the Report Options window you will want to select the date to Print/Age as of, select the last date of the month you are reconciling. I recommend generating this report In Detail (mark the In Detail box), but you could generate it as a summary report.

When your Accounts Receivable GL account does not tie to your sub-ledger receivables, you will need to find the discrepancy. A great tool for this is the Reconcile to GL routine. Before you use this tool you will want to make sure all transactions have been posted through the GL. You can find this tool by going to Financial > Routines> Reconcile to GL.

If you are using, or intend to use the drop ship in Microsoft Dynamics GP, you need to be aware of the availability of the Shipment Notification tool which is included at no charge in the Professional Service Tools Library (PSTL). Shipment Notification is used in conjunction with Sales Order Processing and allows for drop ship sales orders to be transferred to an invoice before enter/match is complete on the purchase order for the drop ship sale.

Reconciling your accounts each month is an important process to complete so that you have accurate and timely financials. You will want to reconcile each of your balance sheet accounts. However, I recommend focusing on the four main account types, and then working on the rest of the account. The four main account types you will want to make sure to reconcile are Cash, Accounts Receivable, Accounts Payable, and Inventory.

Often, I am asked how the drop ship process in Dynamics GP really works. Most of our clients that use the process find it a little cumbersome, and sometimes confusing. In this blog, I will outline the process from Sales Order creation through vendor invoicing.

In order for the drop ship process to work correctly, and to be able to reconcile your Accrued Drop Ship account at month end, you will need:

We discovered an interesting problem following the migration of Management Reporter to a new server. We had exported all of the building block groups from the old system, installing Management Reporter on the new server, and then importing the building block group onto the new Management Reporter install on the new server.

Reconciling your Bank account to your checkbooks in GP is an important part of keeping your checkbooks up to date and accurate. I recommend using the following process once a week to reconcile each of your checkbooks.

If you are entering Payroll information into GP without using an integration, it doesn’t need to take a lot of time or effort to enter it. What you need to do is make sure all the correct distributions are entered for your salaries expenses, and to make sure your transactions appear in your checkbook correctly.

Recently, a client asked the following: “We recently disabled Multicurrency in Dynamics GP 2013. When opening a Sales Transaction Entry, we get the following error: "Your Multicurrency registration status has changed. Please check links on the Multicurrency Setup table." Most of the information I found regarding this error included partial fixes for that did not work. I was able to correct the error by using the following steps:

In GP 2013, they have added to the Reconcile to GL functionality. Previously this tool only worked for reconciling Payables and Receivables to the GL. Now they have added Bank Reconciliation. However, before you use this tool, you will first want to verify that everything has been posted through Series Post. You will also want to make sure that there are no outstanding deposits. These are two things you will want to check when your Cash Account and Checkbook do not tie, before you use the Reconcile to GL tool.