Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Unanswered

Vendor 1099 Magnetic Media in Business Central

Posted on by 75
We have a client that ran the Vendor 1099 Magnetic Media to generate the electronic 1099 file. It generated the file, and they sent it to the IRS. The IRS rejected it because it waws missing the vendor names.
When reviewing the file, we found that any vendor name that was longer than 40 characters was replaced with 40 asterisks.
Publication 1220 by the IRS is the specifications for the Electronic Filling of 1099 forms, does state that the field for the names is 40 characters. The Vendor Name field in Business Central is much longer than 40 characters.
I am surprised that BC does not through an error or at least give a warning.
It would be nice if it gave an option to truncate the name at 40 characters. The client had to edit 160 vendor names to reduce them to 40 characters or less and re-generate the file.
When they resubmitted the file it was accepted.
Has anyone else run into this situation? What is the best way to handle this, so it does not happen in the future?
Thank you for your suggestions.
Dave
  • gdrenteria Profile Picture
    gdrenteria 12,183 Most Valuable Professional on at
    Vendor 1099 Magnetic Media in Business Central
    Hi
    I am not a specialist in this functionality, but I have been able to find that what you request was proposed as an idea.
    Microsoft Idea (dynamics.com)
    I advise you that you can also publish this topic within the Viva engage localization group (yammer)
    Best regards
    Gerardo

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans