Open Forum

 View Only
Expand all | Collapse all

1099-NEC --> 3-Up instead of 2-Up

  • 1.  1099-NEC --> 3-Up instead of 2-Up

    Posted 24 days ago
    It appears the Federal Government has changed the 1099-NEC form from 2-Up to a 3-up this year.  Our GP still prints the 1099-NEC in 2-Up format.  I have not seen an update to correct this.  Has anyone found a work around for this?

    ------------------------------
    Brian Barnholtz
    Director of Information Technology
    Fullerton Companies
    Plymouth MN
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: 1099-NEC --> 3-Up instead of 2-Up

    Posted 23 days ago
    The new report format is in the 2021 YE update.  Why could they not just make the new format available on its own? I don't know but we have to try to find time to rush in an update in time for the 1099s.

    Hope this helps.

    ------------------------------
    Richard Kinning
    Hillsborough Transit Authority (HART)
    Tampa FL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: 1099-NEC --> 3-Up instead of 2-Up

    GPUG ALL STAR
    Posted 23 days ago
    Hi Brian

    Yes, you are correct, this is included in the year end update.

    Here is our year end landing blog page for all modules, check out the FORMS blog

     

    https://community.dynamics.com/gp/b/dynamicsgp/posts/microsoft-dynamics-gp---2021-year-end-blog-series-schedule

     

     

    Here is the US Release blog and download pages

    https://community.dynamics.com/gp/b/dynamicsgp/posts/microsoft-dynamics-gp-u-s-year-end-update-2021-released


    Thanks
    Terry Heley
    Microsoft

    ------------------------------
    Terry Heley
    HR/PR expert
    Microsoft
    West Fargo ND
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: 1099-NEC --> 3-Up instead of 2-Up

    Posted 23 days ago
    Hell Brian

    We found that out at the last minute as well. We have decided to use 1099Pro to print the 1099 NEC and 1099 Misc.
    The excel format that 1099Pro needs is fairly straight forward. The S/W costs little to purchase.
    Let me know if you would like a copy of the SQL views to use.

    RE: YE update, yes that is a huge undertaking as we have to test all the ISVs and custom functionality pieces before rolling out to a live system.

    Best of luck!

    Ven

    ------------------------------
    Dynamics GP Credentialed Pro (Install)
    Ven Sharma
    Finance and Admin Systems, Administration
    American Public University System (APUS)
    Charles Town WV
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: 1099-NEC --> 3-Up instead of 2-Up

    Posted 23 days ago
    Ven

    Yes, I would love to have the SQLScripts  I don't want to have to do all of the yearend changes with the special customizations that we have

    Let me know if you can provide

    Thanks
    Linda Krawiecki

    ------------------------------
    Linda Krawiecki
    P&L Consulting Inc
    Albuquerque NM
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: 1099-NEC --> 3-Up instead of 2-Up

    Posted 23 days ago
    Hi Linda

    Here it is. I have also included the 1099Pro format for 2021.
    The sql view attached is for INTERID = TWO01,
    please replace this with your company DB name.

    Best of luck.

    Ven

    DISCLAIMER:

    I don't work for the 1099Pro company.

    ------------------------------
    Dynamics GP Credentialed Pro (Install)
    Ven Sharma
    Finance and Admin Systems, Administration
    American Public University System (APUS)
    Charles Town WV
    ------------------------------

    Attachment(s)

    Academy - Online Interactive Learning from Experts


  • 7.  RE: 1099-NEC --> 3-Up instead of 2-Up

    Posted 23 days ago
    Thank you I will try running them on my system

    Linda

    ------------------------------
    Linda Krawiecki
    P&L Consulting Inc
    Albuquerque NM
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 8.  RE: 1099-NEC --> 3-Up instead of 2-Up

    Posted 23 days ago
    Thank you for all the information.

    Much Appreciated!

    ------------------------------
    Brian Barnholtz
    Director of Information Technology
    Fullerton Companies
    Plymouth MN
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 9.  RE: 1099-NEC --> 3-Up instead of 2-Up

    Posted 23 days ago
    Linda and Brian:

    Here is how to go about using the view.

    1. Point the SQL view attached to your Company DB (found in the first line of the sql script).
    2. Run the query.
    3. Output the results to excel.
    4. Feed the above excel to 1099Pro software.
    Please note the output will have a redundant column called year, that can be used to filter out data.
    It will not hurt the 1099Pro processing if you leave that column in there.

    Best of luck

    Ven

    P:S- I have one for 1099 Misc as well, will attach the same soon.

    ------------------------------
    Dynamics GP Credentialed Pro (Install)
    Ven Sharma
    Finance and Admin Systems, Administration
    American Public University System (APUS)
    Charles Town WV
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 10.  RE: 1099-NEC --> 3-Up instead of 2-Up

    Posted 23 days ago

    Ven

     

    Thanks for the information

     

    I did put it in my database, but I then created a smartlist in GP to easily sort etc and then send to excel 

     

     

    Linda Krawiecki

    President

    P&L Consulting Inc

    Office 520-485-1012 Cell 505-250-9256

     

     

     

     

     




    Academy - Online Interactive Learning from Experts


  • 11.  RE: 1099-NEC --> 3-Up instead of 2-Up

    Posted 23 days ago
    Thanks Ven.  Worked like a charm.  I created the view, and exported to excel.  I was able to import this into the 1099Pro demo software.

    Thank You Again for all your help!


    ------------------------------
    Brian Barnholtz
    Director of Information Technology
    Fullerton Companies
    Plymouth MN
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 12.  RE: 1099-NEC --> 3-Up instead of 2-Up

    Posted 17 days ago
    Hello,
    Would it be possible for the SQL view?
    Thank you,
    Jennifer Senko

    jsenko@svcw.org
    SVCW
    1400 Radio Road
    Redwood City, CA 94065

    ------------------------------
    Jennifer Senko
    Silicon Valley Clean Water
    Redwood City CA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 13.  RE: 1099-NEC --> 3-Up instead of 2-Up

    Posted 16 days ago
      |   view attached
    Hi Jennifer

    The NEC SQL view is attached to this thread.

    Here is the sql view for MISC.


    ------------------------------
    Dynamics GP Credentialed Pro (Install)
    Ven Sharma
    Finance and Admin Systems, Administration
    American Public University System (APUS)
    Charles Town WV
    ------------------------------

    Attachment(s)

    Academy - Online Interactive Learning from Experts


  • 14.  RE: 1099-NEC --> 3-Up instead of 2-Up

    Posted 16 days ago
    Thank you very much for your reply!

    ------------------------------
    Jennifer Senko
    Silicon Valley Clean Water
    Redwood City CA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 15.  RE: 1099-NEC --> 3-Up instead of 2-Up

    SILVER CONTRIBUTOR
    Posted 10 days ago
    Hi,

    Tried to print 1099 NEC and have installed the 2021 YE Update, but still printing 2 forms to a page.  Is there something else that needs to be done or checked?

    thanks

    Denise

    ------------------------------
    Denise Amundson
    Senior Accountant
    Missouri River Energy Services
    Sioux Falls SD
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 16.  RE: 1099-NEC --> 3-Up instead of 2-Up

    Posted 10 days ago
    You might want to double check that you are not running the modified form from last year
    Linda

    ------------------------------
    Linda Krawiecki
    P&L Consulting Inc
    Albuquerque NM
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 17.  RE: 1099-NEC --> 3-Up instead of 2-Up

    Posted 10 days ago
    We are having the same issue with 1099-nec they are 2 up not 3 up.  Has anyone contacted tech support from sovos (1099pro)?

    ------------------------------
    Richard Kinning
    Hillsborough Transit Authority (HART)
    Tampa FL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 18.  RE: 1099-NEC --> 3-Up instead of 2-Up

    Posted 10 days ago

    Double check that you have not got the form as a modified form from last year   Last years form was 2  per page

     

     

     

     

     

    Linda Krawiecki

    President

    P&L Consulting Inc

    Office 520-485-1012 Cell 505-250-9256

     

     

     




    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role