Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Vendor 1099 Totals
Microsoft Dynamics GP (Archived)

Vendor 1099 Totals

(0) ShareShare
ReportReport
Posted on by Jim Briggs 60

Hi all,

To coincide with the changes in 1099-MISC reporting that had been going into effect at the beginning of the year (and since repealed) we had changed all vendors necessary to a Miscellaneous tax type, even if payments were made to a corporation for non-employee compensation.

We have since made changes to reverse that, now have corporations marked off as Not a 1099 Vendor

Problem now is that most of the Not a 1099 Vendors had accumulated some 1099 payment totals over the year, which we need zeroes out for when we print our 1099-MISC forms. To my knowledge, we can adjust the amounts in the 1099 Details window, but only if the vendor card currently shows them as having a Miscellaneous tax type

Long story short :) is there a way to mass update 1099 totals for a specific range of tax types OR when printing 1099-MISC forms can we set to omit any vendors currently set as Not a 1099 Vendor, even if they have 1099 payment totals for the year?

We are currently using version GP 2010

Thanks in advance for any help offered,

Jim B

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Vendor 1099 Totals

    Is there a way for the end user to change the transactions that were flagged as 1099's but shouldn't be?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Vendor 1099 Totals

    Leslie,

    Thanks so much for the quick response and the lazy and effective method!

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Vendor 1099 Totals

    Hi,

    You're speaking my language!

    We change the PM00200 [TEN99TYPE] and [TEN99BOXNUMBER] so they are no longer identified as 1099 vendors. Then, we delete any record in the PM00204 that matches a record in the PM00200 that is marked as NOT a 1099 vendor in PM00200.

    There is still some cleanup work to do as Keith describes, but this gets us past the crisis, just don't run a reconcile before you get your 1099s out. :)

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Vendor 1099 Totals

    Leslie,

    We have the same problem with over 1,000 vendors, so lazy and effective is the way I want to go!  

    Just to be sure I am not missing a table somewhere......

    I am going to change the vendor card to "not 1099" through rolling down a change in the class ID (fortunately all our vendors with this problem are in the same class), then change the 1099 type in PM00204 for year 2011 to match the 1099 type in PM00200.

    Last, I will delete all rows out of PM00204 for 2011 with a 1099 type of "1"

    Does that sound like it will do it?

    Thanks!

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Vendor 1099 Totals

    Hello all,

    Perfect reasoning Keith!  However, if you're in a hurry just zero out the 1099 amounts for any vendor that currently has a 'no 1099' setting, but has records in the 1099 detail tables. Actually I delete the records entirely instead of setting them to 0.

    Lazy, but effective.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Vendor 1099 Totals

    Jim,

        When we edit 1099 amounts we find the invoice in table PM30200 and correct the TEN99AMNT, TEN99TYPE and TEN99BOXNUMBER.  Then we follow that invoice to the payment in the PM30300 table and correct the TEN99AMNT, DEFTEN99TYPE and DEFTEN99BOXNUMBER.  After the corrections are in place we run Tools-Utilities-Purchasing-Reconcile=>Calendar Year and Only 1099 Amounts.  We are running GP version 10.  This works for us.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans