Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 Microsoft Employee

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

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: 1099 report is not showing all 1099 vendors

    1. In your SmartList, add the columns 1099 Amount and Unapplied 1099 Amount.

    2. If you have SQL skills, look at table PM00204, this is the 1099 period detail from which the 1099s get their numbers.

    3. Run the Reconcile Utility on 1099 amounts. Just print the report, uncheck the Reconcile box.

    4. Run the 1099 Modifier tool that is part of the PSTL module.

    Always backup before you do this.

    Kind regards,

    Leslie

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

    Yes is the same company. The number of records (contractors) in the SQL table are 8. Which I know that is totally wrong base of the volume of contractors in this company.  However on Smart List I have 199 contractors that I paid on 2016. All of them are setup as contractor, misc 1099.

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

    Are you sure the company database you are running the script against is the same as the company you are logged into GP as?  Start with that.  How many vendor records in total does smartlist show you have?  That should match the number of records returned in SQL against the PM00200 table.

  • Community Member Profile Picture
    Community Member Microsoft Employee 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.

  • Community Member Profile Picture
    Community Member Microsoft Employee 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 Microsoft Employee 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 Microsoft Employee 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 Microsoft Employee 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.  

  • 26P2ER Profile Picture
    26P2ER 1,773 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 Microsoft Employee on at
    RE: 1099 report is not showing all 1099 vendors

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

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans