When should the process start?

I will admit that, from time to time, I get confused by some of the processes that I see being used to get things done. In the accounting world, one process in particular always keeps me wondering. Most companies have to go through it every year and it always seems unnecessarily stressful and arduous. I am not referring to manufacturing, the shipping of millions of items, inventory counts, managing a logistics chain or budgeting for next year … no, no … nothing that glamorous, I am talking about good old fashioned 1099’s. If you just cringed, shook your head or wanted to stop reading, I completely understand.

In talking with Dynamics GP users and researching the different processes that are employed to get 1099 forms out the door and filed properly, it became clear that all of the focus is put on the “end” of the process. So I started to think about why it is being done this way because NOT everything HAS to be done at the end of the year to get ready for filing 1099’s.

There are manual and automated things involved here. Everyone I know wants to get things done as accurately as possible while using the fastest and most efficient process. Why is that? People like to save money and time while maximizing productivity (their own and their co-workers). Anything to let the boss know how awesome we really are!

There is one part of “1099ing” that does not need to wait until the end, in fact it really should be done periodically (weekly, monthly, quarterly) because it will save you from having to do what some users have described as the most frustrating and time consuming step in the whole process. TIN Matching, yes TIN Matching – making sure that the 1099 vendor information in your system matches up with what the IRS has in their system.

This is a step that can and should be done throughout the year, rather than all at once at the end of the year. Dealing with the IRS poses its own challenges but at the end of the day, they make the information available and now Dynamics GP users get the benefit of streamlining the interaction between their systems and the IRS Bulk TIN Match service.

Here’s what happens to make this possible:

  • 1099 Vendor data is pulled from Dynamics GP into The Validator1099 solution and allows users to quickly and easily give the list a once over for any obvious issues.
  • After a quick review, a file that meets the IRS TIN Match format specifications is created and made available for upload into the IRS Bulk TIN Match Service.
  • The file is uploaded and run up against the IRS data and users are notified when to retrieve the results file from the IRS TIN Match Service.
  • The resulting IRS file is imported into The Validator1099 solution and analyzed, by vendor, based on what the IRS has determined are issues with the data.
  • The file is then archived for future reference as needed.
  • From this point users can use the report to track down any information needed to make sure the identified 1099 vendors are updated properly in Dynamics GP.
  • Dynamics GP users now have a solution that takes the heavy lifting out of the TIN Match process.

Looking ahead to filing the next round of 1099’s, how nice would it be to have all of your TIN Matching done well ahead of time? Ponder that for a few minutes, trying to get the books closed and reconciled, trying to get financials pulled together, doing all of the other year-end tasks – now think about not having to track down vendor information or waiting for someone else to do it.

Learn how The Validator1099 will save you time and money during your busiest time of the year.

Please give us a call at 813-579-4991 or send us an e-mail to sales@reporting-central.com or request more information on-line at www.reporting-central.com

GPUG Summit 2016


Come visit us next week, in Booth 346 at GPUG Summit, for a demonstration of The Corrector. Amber Bell, The Training Dynamo, will be with us talking about the new GP User Guides being created!

OCTOBER 11-14, 2016 | BOOTH 346

What’s the best way to correct an AP Distribution error in Dynamics GP?

Anyone that uses or supports Dynamics GP has posted an AP transaction incorrectly or had to clean-up after someone else who did.

No big deal right?  A journal entry here, a journal entry there and the problem goes away.  Not so fast, it only goes away UNTIL someone gets hit with that cryptic journal entry on their Trial Balance or an auditor sees it and wants to know more about it.  All of a sudden that transaction is a problem again.  Now someone has to go and dig up the details, explain what the entry is correcting, find out who made the correction, what vendor it applies to and what the total transaction details are…AND then life can go on until the next AP Distribution mistake and well, you know the drill…

Wouldn’t it be nice to have all of that information – who requested the correction, who made the correction, why was the correction needed, which vendor does it apply to and what the original transaction being corrected was – in one place, be accessible from AP and have the correcting entries properly presented on Trial Balance reports?

Dynamics GP users now have a solution …“The Corrector” for Payables Distributions.

“The Corrector” gives Dynamics GP users the ability to approach AP Distribution corrections from the AP distributions window, not from the GL. This way users see it from the originating transaction side and can process corrections more efficiently and with all of the relevant information needed.

Here’s a quick overview on how “The Corrector” for Dynamics GP works:

From the Payables Distribution Zoom window, you will now have the “Correct” button.

The Corrector for Dynamics GP




















From the Correction window, pick the lines that need to be fixed, input the relevant details and then Create your Journal entry.

The Corrector for Dynamics GP - Create Journal Entry


“The Corrector” creates a PMTRXCORR reversing entry with the relevant details for you, that means you just have to enter the correct account information and save the entry.

The Corrector for Dynamics GP - Correcting Entry

Once you’ve posted the batch with the correcting entry, all of the relevant details now reside with the transaction and can be viewed and reported on.

No more mystery, no more research projects – it’s all right there waiting for you…who requested the correction, who made it, why was it needed and the all of the accounting detail in one place tied to the originating transaction.

The Corrector for Dynamics GP - Transaction History Window
Stop by and see us at GPUG Summit in Reno, we’ll be in Booth 255 on the Expo Floor.

Call or e-mail with any questions:  813-579-4991 or gsalzano@reporting-central.com

Visit us on-line to request a trial license of The Corrector:


Microsoft Convergence 2015

Come visit The Closer Guys at Convergence 2015
March 16-19, 2015 | Atlanta, GA

You love saving time with The Closer, stop by BOOTH 1352 to check out our NEW time saving solutions for Dynamics GP!

The Closer
Reconciling Sub-Ledgers to the General Ledger

The Corrector
Quickly and easily fix AP distribution mistakes

The Validator
Easily confirm 1099 vendor information and easily check over 100 Dynamics GP system & data points

The Allocator
Intercompany Allocations for AP Transactions and Journal Entries and detailed allocations across departments

Dupe Check
Check for duplicate vendors and vouchers across all of your companies

Batches for Bank Transactions
You do it everywhere else, now it for bank transactions

Intercompany Enhancements
Void and view transactions across all of your companies with detailed transactions in both the due to/due from company

To review any of our products prior to Convergence 2015, please visit our Solutions page.



Come Join Reporting Central at GPUG St. Louis

GPUG St. Louis 2014

Reporting Central will be located at BOOTH 1443.  Stop by and check out all the new products NEW PRODUCTS from Reporting Central!

While there, you can pick up your VIP invite to the BEST PARTY IN ST. LOUIS!

Experience GPUG Summit 2014, the ultimate learning and networking event for the Microsoft Dynamics® GP community.

Every attendee is focused on Dynamics GP, and you’ll learn first-hand how they’ve overcome challenges you face every day!

Register HERE

Convergence 2014 – March 4-7 | Atlanta, GA

Join Shane and Gianmarco at Convergence 2014.

Convergence 2014 returns to the Georgia World Congress Center in Atlanta, Georgia March 4 – 7, 2014. We’re excited to announce that some of the activities, including the keynotes and the Celebration, will be held at Philips Arena, located right next door.

There are a ton of good reasons you should be at Convergence 2014. But if you’ve never been to Convergence (or if it’s been a while) here’s why you need to go:

  • Learn. See how you can make your life easier when you get back to work.
  • Connect. Find out how other customers, partners, and Microsoft specialists use Microsoft Dynamics.
  • Expand. Check out how our fabulous partners are bringing innovation and new value to Microsoft Dynamics.
  • Discover. Watch Microsoft experts demo the new releases and talk about the product roadmaps.
  • Discover. Hear where Microsoft execs and industry analysts think the industry is going.
  • Enjoy. Mingle with your new best friends at evening events and the closing celebration.

Register HERE


Convergence 2014, March 4-7 | Atlanta, GA


Announcing…Analytics for Dynamics GP – created by Mark Polino

It’s no secret that Mark Polino is passionate about improving the lives of everyone who uses and supports Dynamics GP. In continuing his tradition of providing value, Mark has created a cost effective and easy to use Business Intelligence Solution called Analytics for Dynamics GP. Simplicity is the key driver in this plug and play sales dashboard.

The Analytics for Dynamics GP dashboard includes:

  • Top Customers with corresponding costs
  • Top Items with corresponding costs
  • Top Sales people, Territories and Sites
  • Sales Over time with forward looking projection
  • Sales mix over time by Item Class
  • A full range of data filters to control information

Learn More about Analytics for Dynamics GP…