- 3 Posts
- 300 Views
Merging Supplier Payments by TIN for 2017 1099 Processing
Hello Everyone -
My organization has roughly 70-80 PS Suppliers who have the matching TIN's but different supplier ID's. The accounting department would lke to combine the total dollar amount of payments by tax id and I was wondering if anyone knew the correct/most effecient way of doing this.
For example, we have one supplier with three supplier ID's (1000001370, 1000001371, and 1000001372) that have the same TIN but we have made payments made to all three supplier id's. AP needs to send one 1099 copy B to the vendor, not 3.
Any direction would be a huge help!
Thank you!
Phillip Johnson
PeopleSoft FSCM Functional Analyst
813.844.7499
Hi Kevin -
Thank you so much for following up.
I was aware that I could merge the total payment amounts using SQL statements but I wasn't sure if the same outcome could be performed from the web app.
Thanks again for the feedback!
–
Phillip Johnson
PeopleSoft FSCM - Systems Analyst II
ERP - Business Applications Team
Office – 813.844.7499
Cell – 813.298.8388
Phil,
When extracting the data, you will need to sum the payment amount by Tin (ie. take Vendor Id out of the SELECT statement) - and join the Vendor Id in the WHERE CLAUSE (from the Vendor table to the Payment table). From there, you should be able to create the 1099's by Tin.
Hopefully that helps and please reach out if you need additional information.
–
Kevin Meyer
Meyer Consulting Group, LLC.
Phone: 516.713.0805
Email: kmeyer@meyercgrp.com | www.meyercgrp.com
Implementations | Support | Upgrades | Compliance