Penta created two 1099s for the same vendor
Issue/Symptom/Question
When running 1099's for 2018 Penta created 2 separate 1099 MISC forms for the same vendor.
On reviewing the 2 vendors, they have the same vendor name, same tax ID, and same address, even through they are separate vendor numbers in Penta. They should not be separate. I did not think it was possible to set up 2 different accounts with the exact same federal tax ID. There is usually a pop up that says “Federal Tax ID is already in the system” if you try to enter the same tax ID twice
Applies To
System Management > Technical Services > Options / Option 164
Accounts Payable > Vendors > Vendor Information
Resolution/Fix/Answer
There is a popup warning issued when a duplicate federal id is entered, but Penta will allow it - so if a user chooses to ignore the warning, the duplicate entry is allowed. In this case, the two different vendor numbers had the same Federal Id.
In this case, Option 164 was set to Yes, and will use the Vendor Address Name on the 1099s.
For each vendor number, the Vendor Address Name for address #2 was identical, so even though the Vendor Name was not the same for both vendor numbers, the Vendor Address Name was, and the two 1099s appeared to be for the same vendor number.
To re-assign payment amounts to the correct vendor, you can do so by voiding the check(s) paid to the wrong vendor number, voiding the invoice(s) issued to the wrong vendor number, reissuing the invoice(s) to the correct vendor, and re-issuing the check(s) to the correct vendor.
Related content