Vendor TIN export

More of an FYI to the community with 1099 season approaching.

If you’re looking to export vendor information with unencrypted TIN numbers, you’ll find that BAQs and direct queries won’t work.

However, if you use the REST services, the business object VendorSvc will allow you to pull in the vendors, with the unencrypted TIN.

Example I used which for ODATA just pulls the VendorNum, VendorID and TIN. Note the order by, and top has this odd effect of getting around paging, so I just set it to 100,000.

“https://{YourEpicorServer}/epicorerp/api/v2/odata/{YourCompany}/Erp.BO.VendorSvc/Vendors?%24select=VendorNum%2CVendorID%2CTIN&%24filter=TIN%20ne%20’’&%24orderby=VendorNum&%24top=100000”