One of the most frustration situations I come across is when I walk into an existing user of GP only to find they are using Payables Management (PM) as a fancy check writer rather than a tool to manage payables.

I often wish I had a portable soap box to stand on when I say "enter all of your every day and you'll reap all kinds of benefits!"

If you enter ALL…

Dynamics GP includes a little known feature named Control Account Management. It's part of the Purchasing module and its designed to let companies use a centralized AP account and then split their AP to divisional segments for financial reporting.

Yesterday I talked about using default GL accounts with Vendors to make entering distributions easier in Payables. If you are not currently doing this, you are wasting time.

How does it work? Any vendor that gets coded to the same GL account number most of the time can store that GL number in the vendor card. Then when you enter a transaction in for that vendor, it’ll enter that GL number in the distribution on the PURCH line automatically!

How can I set it up? Simple pull up a vendor in the…

Payables Select Checks Enhancements

Module: Payables Management

Why this feature is cool!

With Microsoft Dynamics GP 2010, you will find a number of new options to increase the flexibility and control when building your Payables Check batches! You can restrict payables invoices by a…

Picture this: the auditors are in, they asking for myriads of reports, and precisely one of the things they ask is something you cannot easily achieved from the slur of reports and SmartLists available from within Microsoft Dynamics GP. To make matters worst, the "go to" guy for queries and special requests is out of the office sick with the flu. Well worry no more! If you are asked to show all the payables transactions that were never recorded or posted to GL you can run the following query from SQL Server Management Studio (or Query…

We’ve all been a new user to GP, whether it was last week or over a decade ago. Invariably we all get stuck in the Payables Entry Window or the Receivables Entry Window while trying to code the GL Distribution. If you are still getting hung here occasionally, today’s entry is for you!
To avoid distribution errors, make sure the entry window matches the distribution window. Let’s talk about Payables in this example, keeping in mind Receivables works the exactly same way.
On the Payables entry window, the amount…

As per the IRS, the 1099 form must be issued to Vendors for amounts of $600 or greater. Somebody recently reported that the 1099s were not being produced for Vendors with amounts which were exactly $600.

By default, the minimum amount for 1099’s is set to be $600 (Microsoft Dynamics…