Blog
Resources from our industry-expert staff
Microsoft ends support for Internet Explorer 8, 9, and 10
Last month Microsoft ended support for Internet Explorer 8, 9, and 10. This means those versions of IE will no longer get security patches and technical support. It is critical that you get security updates to ensure your system doesn't get compromised by malware, spyware, adware, or any other malicious code. In addition, you'll want to be on an updated version of IE to ensure any web pages you visit will work properly.
Customize your app launcher in Office 365
Microsoft has quietly rolled out a cool new feature for Office 365 Business that gives you the power to move and re size your apps within the Office 365 app launcher. This is an exciting feature for people that use the app launcher to switch between Office 365 apps and for those who don’t use the app launcher, this will be a fun way to get into a habit of using it more.
Year-End Closing Procedures for Microsoft Dynamics GP
It's that time of the year again! It's time to close the books for 2015. We're here to answer common questions related to year-end closing procedures in Microsoft Dynamics GP.
Microsoft announces two Azure data centers in UK
Microsoft CEO, Satya Nadella took to the stage at the Future Decoded conference today to announce two new Azure data centers opening in the UK in 2016. Microsoft recently completed Azure datacenters in Ireland and the Netherlands, but this will be the first datacenter in the UK. The expansion will allow UK businesses and government organizations using Azure to store and backup data within the UK region for the first time.
Using the PA Reconcile Utility to Close your Dynamics GP Projects
You have just completed a project in GP and you are ready to close it - or so you think! You go through the "Project Closing" window and it indicates that the project is not ready to be closed. "What do I do now," you may ask.
If you think you have everything completed for a project and you are not sure why it will not close, you may want to run the PA Reconcile utility.
How to use Excel Copy/Paste in the Dynamics GP General Ledger
One of the new features of Microsoft Dynamics GP 2013 R2 is the ability to copy information from an Excel Spreadsheet and paste it into a General Ledger entry in GP. For any of you that have used Integration Manager to import General Ledger transactions into GP, you are probably jumping up and down with joy and high-fiving everyone at the office. A process that used to involve preparing your Excel document, saving it as a tab-delimited file, configuring your integration, and then troubleshooting any errors you might receive with your integration has been simplified into preparing an Excel document and simply pasting it into GP. Neat right? The only thing to keep in mind is that your columns have to be ordered in this sequence: Description, Account Number, Debit, and Credit.
How to edit and generate 1099s with Dynamics GP 2013
It's that time of year again! Time to generate and send out 1099s to your vendors. Luckily, Dynamics GP has this functionality built in. All you need to do when entering a new 1099 vendor is specify that they are a 1099 vendor in their vendor card. Then, at the end of the year, you can print 1099s for all vendors that you have set up. All of the calculations are done for you.
Unable to delete PO Lines after Dynamics GP 2014 Payroll Update
One of our clients discovered a minor, but annoying issue just after their 2014 Year End Payroll Update had been installed. They noticed that they could no longer delete or insert Purchase Order lines while entering a Purchase Order.
Using Direct Links to Inquiries from SmartLists in Dynamics GP 2013
I have been noticing a number of different links and features as I have been working in Dynamics GP 2013 that may not have been in earlier versions, or I just didn’t notice them before. I have checked with a number of our clients, and they didn’t seem to know they were there either.
I was working in a SmartList in Dynamics GP 2013 the other day, and noticed a cool little feature that I hadn’t used before and has turned out to be quite a time saver.
How to Void Accounts Receivable Transactions
Occasionally in Dynamics GP you will need to void an Accounts Receivable transaction. Voiding a transaction in Accounts Receivable differs from voiding an Accounts Payable transaction in that there is only one place to go to in AR: Posted Transactions. To get to this window go to: Sales > Transactions > Posted Transactions.
In the Receivables Posted Transaction Maintenance window, enter or select the customer for the transaction you wish to void. Then you will want to select the Document Type of the transaction you wish to void. Options include Sales / Invoices, Debit Memos, Finance Charges, Service / Repairs, Credit Memo, Returns, Payments. Once you select the type you can click the looking glass next the Number to select the transaction.
Line Item Searches in Dynamics GP 2013 Sales Order Processing
Recently, I noticed a client scrolling through an invoice in Dynamics GP Sales Order Processing to review a specific line item. The invoice contained over 50 lines, and scrolling was not an efficient way to find the line item. There is a line item search feature that allows for searching large invoices for specific items in Dynamics GP.
This search feature works with all SOP Types: Orders, Fulfillment Orders, Backorders, Invoices and Returns. The steps are identical if you are using the Dynamics GP 2013 Web Client. In the invoice example below, simply click the down triangle that appears in the blue bar above the line item entry fields.
Editing and generating 1099s in Dynamics GP
It's the time of year for generating and sending out 1099s to vendors. It's the time of year for generating and sending out 1099s to vendors. Dynamics GP has this process built in. You mark a vendor as a 1099 vendor, and then at the end of the year you can print the 1099s. It does all the calculations for you. This is great, until something happens that causes this number to be incorrect in the report. The great thing is that editing 1099s in Dynamics GP is a simple process. Often what is more difficult is determining what the correct number should be.Dynamics GP has this process built in. You mark a vendor as a 1099 vendor, and then at the end of the year you can print the 1099s. It does all the calculations for you. This is great, until something happens that causes this number to be incorrect in the report. The great thing is that editing 1099s in Dynamics GP is a simple process. Often what is more difficult is determining what the correct number should be.
Of course, when it comes to generating 1099s, the first thing you want to do is verify that all your 1099 vendors are designated as such in their Vendor Card. The easiest way to see which Vendors are currently 1099 vendors is to use a SmartList. There is a default SmartList that works great for this. In SmartList, go to Purchasing > Vendors and select the 1099 Vendors* List. This list will populate with any vendors that are marked as a 1099 vendor. From this list you can drill into the Vendor Card to make any changes. If you do not see a vendor in your list that should be a 1099 vendor, you will need to go into their Vendor Card and make them one.
How to Void Accounts Payable Transactions
Sometimes a transaction in Dynamics GP needs to be voided. This can happen when an invoice is entered in error or incorrectly, or check was lost or destroyed and needs to be reprinted. In order to correct an invoice, you need to void the incorrect transaction, and re-enter it correctly.
If an invoice has been paid, or a payment applied to it, you will need to void the payment before you can void the invoice. To void a payment in Dynamics GP, go to Purchasing > Transactions > Void Historical Transactions. In the Void Historical Payables Transactions window, enter or select the vendor for the payment you want to void. Then mark the check box in the void column next to the transaction you wish to void. Then click the Void button.
The Easy and Accurate Return in Dynamics GP Sales Order Processing
Every so often I come across a client that has been using Microsoft Dynamics GP since the early Great Plains Accounting days. They have done things the old way for so long, they are not aware that there are better options available in the system for completing their daily tasks.
A recent example of this occurred with a client that was using Sales Order Processing. To return inventory, they would select an SOP Type as Return, select the customer, enter the returned items, verify the quantities and price, etc.
Lesson Learned: Integrating Microsoft RMS and Dynamics GP
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.
Month End Reconciling Process for Accounts Payable
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.
Entering Invoices Paid by Credit Card - Inventory Transactions
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.
Dynamics GP 2013 SP2 Upgrade and SmartList Treeview Navigation
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: Never Give Up, Never Surrender
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.
Subscribe to our monthly newsletter
Sign up for the latest news about training, product updates, promotions, resources, and more.