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
*This post is locked for comments
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
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.
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.
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.
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.
Thank you Cindy. I checked the tables and nothing even the table has 8 contractors instead of 199
I did it. No luck. Is still with the same 8 contractors instead of 199
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.
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.
Sorry! New in GP. How I can get to the sample company?
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156