Skip to main content
Microsoft Dynamics GP forum
Suggested answer

'Not a 1099 Vendor' type Vendors being included on the 1099 Edit List

editSubscribe (0) ShareShare
ReportReport
Posted on by 340

1099 Edit List includes Vendors who are not presently flagged as any 1099 Vendor Type, and have never been flagged as anything other than 'Not a 1099 Vendor'

Is ther additional 1099 setup that could cause this?

Categories:
  • Suggested answer
    sueconrod Profile Picture
    sueconrod 335 on at
    RE: 'Not a 1099 Vendor' type Vendors being included on the 1099 Edit List

    Got the answer from Microsoft:

    1.  Make sure your minimums in the 1099 Setup (Setup>>Payables>>1099's) all have at least  a .01 on them.

    2.  Some of the boxes in the setup are wrong and there is a script to correct.  And has to be run against each company.

    From Microsoft:

    (Go to Tools>Setup>Purchasing>Payables then click the 1099 setup button and ensure the 1099 type does not have any 0 dollar boxes. This year there is also a small issue with boxs being mislabeled in some cases due to the new box that was added. The below script resolved. (against each company)

    UPDATE PM40104 SET TEN99BOXTEXT = 13, DOLRAMNT = .01 WHERE TEN99BOXNUMBER = 11 AND TEN99TYPE = 3

    UPDATE PM40104 SET TEN99BOXTEXT = 14, DOLRAMNT = .01 WHERE TEN99BOXNUMBER = 12 AND TEN99TYPE = 3

    UPDATE PM40104 SET DOLRAMNT = 600.00 WHERE TEN99BOXNUMBER = 15 AND TEN99TYPE = 3

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 2,960 on at
    RE: 'Not a 1099 Vendor' type Vendors being included on the 1099 Edit List

    Did you possibly run into the 2020 year-end update known issue, documented here?

    community.dynamics.com/.../microsoft-dynamics-gp-fall-2020-update---known-upgrade-issues

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 2,960 on at
    RE: 'Not a 1099 Vendor' type Vendors being included on the 1099 Edit List

    If a vendor should never have been set up as a 1099 vendor, you need to zero out their 1099 transaction or period information prior to setting them to "Not a 1099 Vendor".  (Changing a vendor's status is Vendor Maintenance window does not impact the way prior transactions were flagged.  This is by design to allow for mid-year vendor status changes.)

    To get the vendors off the 1099 Edit List, set them to be a 1099 vendor again and then Edit 1099 Transactions or Edit 1099 Vendor Details to clear their amounts.  Once the 1099 amounts are zero, go back to Vendor Maintenance and set the Vendor to a "Not a 1099 Vendor."

  • sueconrod Profile Picture
    sueconrod 335 on at
    RE: 'Not a 1099 Vendor' type Vendors being included on the 1099 Edit List

    Now have two different companies with the same issue.  It is printing all the Vendors not just 1099 NEC vendors.

    Think we can get an answer before January 31.  LOL

  • Althea ADS Profile Picture
    Althea ADS 445 on at
    RE: 'Not a 1099 Vendor' type Vendors being included on the 1099 Edit List

    I have the exact same issue with one of my customers.  They have a dozen companies and this is happening in only one company.  All companies share the same 1099 reports and none of them are modified.  Most vendors in this company (95%) are not 1099 vendors, yet all print on the edit list AND print a form and are all $0.00 except for the few that are real 1099 vendors and have an amount.  Every single vendor is printing.  

    Were you able to find what was happening to your 1099s?  Hoping it could help here since they have to print by Friday this week!  

    Thanks!

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,030 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans