Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Vendor 1099 Magnetic Media in Business Central

(1) ShareShare
ReportReport
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
    15,612 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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,039 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,856 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans