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

phillipjohnson@tgh.org

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