web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / 1099 report is not sho...
Microsoft Dynamics GP (Archived)

1099 report is not showing all 1099 vendors

(1) ShareShare
ReportReport
Posted on by Community Member

Hi, I printed a report from Tools/Routine/Purchasing/Print 1099

I printed a report from Tools/Routine/Purchasing/Print 1099

I printed a report from Tools/Routine/Purchasing/Print 1099 but is not including all of my 1099 vendors. I went online and checked all of the suggestions below and nothing. What I'm missing here? New in GP

  • The vendor is not set up to be a 1099 vendor.  
  • Make sure the correct 1099 Type is selected in the Print 1099 window as the vendor is set up for.  
  • Check to make sure the vendor has exceeded the minimum amounts in the 1099 Setup window. 'paid date/apply date' of the payments applied to the invoices.
  • The vendor was set up as 1099able 'after' the invoices were paid.
  • Verify the 1099 amount field on the invoice is populated. If the vendor is set up to be 1099able, the 1099 Amount field in the Payables Transaction Entry window should automatically populate. However, the user may be editing the 1099 Amount field to $0.00 prior to posting the invoice.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    26P2ER Profile Picture
    26P2ER 1,775 on at
    RE: 1099 report is not showing all 1099 vendors

    Awilda,

    With IRS deadline round the corner, I know how this can get really frustrating.

    1. Can you check if from payables setup window the box amounts threshold is correct? - Setup>Purchasing>Payables>1099 setup button
    2. When you print from Purchasing>Routines are you sure you are leaving 2016 for the tax year and Miscellaneous for the 1099 type?
    3.  Also from Purchasing>Cards>1099 Details - If you look this vendor up for the 2016 year, you may want to check if the box 7 amount is correct. GP will let you overwrite and save. 
    4.  If you are on GP 2013 or higher you can follow the below MS KB to correct 1099 amounts

    https://support.microsoft.com/en-us/help/918536/how-to-change-the-1099-amount-for-a-vendor-who-was-not-marked-as-a-1099-vendor-in-the-year-that-the-transactions-were-posted-in-payables-management-in-microsoft-dynamics-gp

    Hope this helps!

  • Community Member Profile Picture
    Community Member on at
    RE: 1099 report is not showing all 1099 vendors

    Thanks Ven!

    1. Ok

    2. Ok

    3. OK

    I have 2010. The report is giving me 8 contractors when I have 200. Also, some of the 8 contractors amounts are wrong.

  • Suggested answer
    26P2ER Profile Picture
    26P2ER 1,775 on at
    RE: 1099 report is not showing all 1099 vendors

    Awilda, 

    If you have access to Fabrikam company, I recommend you run the task as detailed in MS KB in the sample company first.

    I have GP 2010 myself here and I do see the Update 1099 from Purchasing>Utilities>Update 1099 Information.

  • Community Member Profile Picture
    Community Member on at
    RE: 1099 report is not showing all 1099 vendors

    Sorry! New in GP. How I can get to the sample company?

  • 26P2ER Profile Picture
    26P2ER 1,775 on at
    RE: 1099 report is not showing all 1099 vendors

    If you click on the company from the left bottom (same place where you would see your user ID), GP will prompt you to switch companies.

    If the sample company is installed and if you have been given access you will see "Fabrikam" as part of that list. Fabrikam is the name of the sample company.

    Please have this company added to your GP environment. Dynamics GP Utilities is an application that your IS administrator needs to use to add this sample company.

    Best of luck. 

    Alternatively, you can try the 1099 utility task by picking just one vendor for both the from and to. 

  • Community Member Profile Picture
    Community Member on at
    RE: 1099 report is not showing all 1099 vendors

    I have had this issue in past versions of GP.  There is a weird bug with the 1099s that is looking to a Workflow Setting in the PM00200 table.  Check the Workflow_Approval_Status field, I believe it needs to be 9.  What I experienced was that as soon as it got to one that wasn't 9, it stopped printing 1099s regardless of whether there were more 1099 vendors.  If you aren't comfortable in SQL to run a query, touch base with your IT staff or your GP partner.  The query to start with would be as follows:

    select * from PM00200 where Workflow_Approval_Status <> 9

    Look at those results to see if your missing 1099 vendors are either some of those records, or more importantly, if their record in the database is after the first record that shows as something other than a status of 9.  If that seems to be the culprit, you will want to do an update on that table to change that workflow approval status to 9.  In all of this, I'm assuming you are NOT really using Workflow which was the case I experienced.  

  • Community Member Profile Picture
    Community Member on at
    RE: 1099 report is not showing all 1099 vendors

    I did it. No luck. Is still with the same 8 contractors instead of 199

  • Community Member Profile Picture
    Community Member on at
    RE: 1099 report is not showing all 1099 vendors

    Thank you Cindy. I checked the tables and nothing even the table has 8 contractors instead of 199

  • Community Member Profile Picture
    Community Member on at
    RE: 1099 report is not showing all 1099 vendors

    The table that you are looking in is the Vendor Master.  If you only have 8 records in there, you have an issue with the vendor master.  The 1099s need a vendor master record.  So, something else is wrong then.

  • Community Member Profile Picture
    Community Member on at
    RE: 1099 report is not showing all 1099 vendors

    I know something is wrong. I don't know how to fix it.  I also took one of the 8 from the 1099 and the amount in the 1099 report is not marching the amount of payments for that contractor on my smart list report.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans