We have multiple vendors with different vendor id numbers (due to different remit to addresses/locations) but they have the same tax id number. How do I get the information to roll up and print all payments made on one tax id number and to print that information onto one 1099? Also, how do I select which vendor address is to receive that 1099?
*This post is locked for comments
Missy,
First let me start by thanking you for running this in your test company first!
It is not uncommon for a certain degree of manipulation to be required to print 1099 information out of GP. When this is the case, I tend to recommend to folks that they create a 1099 company database, akin to your test company. This allows you to manipulate the data, and not be worried about these changes being destroyed the next time someone runs the utilities used to perform these manipulations (i.e. when they go to adjust their 2017 1099 amounts). This database should be set aside, should these documents need to be reprinted later.
If you use this approach, instead of doing these changes in the live company database, then you don't have to worry about the problem with merging the vendor records.
If this isn't optimal, then you'd likely need to do something outside GP to get the totals you need.
Harry,
I tried this in our test environment but it completely deleted the one vendor after I combined them. The total payment amount after combining them was correct but we don't want one of the combined vendors to be deleted because we need to have multiple locations to remit the payments to. Is there a way to combine the information for 1099 purposes without deleting the child vendors?
Missy,
In order to get to a single 1099 for a vendor with multiple records setup, you'll need to use the Vendor Modifier/Combiner Utility. This utility is also available in PSTL (Professional Services Tools Library), which has been free to all GP customers for awhile now. The process would go like this:
1. Combine your vendors using Purchasing >> Utilities >> Vendor Modifier Combiner or PSTL
2. Use Purchasing >> Utilities >> Update 1099 Information to make sure the newly merged Vendor record has 1099 information calculated correctly.
3. Use Purchasing >> Transactions >> 1099 Details in the Month View, make adjustments as necessary.
4. Use Purchasing >> Routines >> Print 1099s to print the 1099 for the new (merged) vendor.
Depending on your version of GP these windows may look a bit different; however, they are all located in the same navigation locations.
#1
André Arnaud de Cal...
292,468
Super User 2025 Season 1
#2
Martin Dráb
231,287
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
