Open Forum

Expand all | Collapse all

1099 SmartList after YE Update-2016

  • 1.  1099 SmartList after YE Update-2016

    TOP CONTRIBUTOR
    Posted 28 days ago

    We have several SmartLists that provide 1099 information. Since the YE update they are not working correctly. So, it sounds like the tables have probably changed? Some of the incorrect information wasn't even affected by the new 1099-NEC changes. Do I have to rebuild those SmartLists or is there an easier solution to get them working again.

    Thanks!

    Joni



    ------------------------------
    Joni Finnell
    GP Projects/Troubleshooter
    Consumer Support Services, Inc.
    Newark OH
    ------------------------------
    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 2.  RE: 1099 SmartList after YE Update-2016

    TOP CONTRIBUTOR
    Posted 27 days ago

    Depending upon the problem, there are a couple of things. 

    1. There is a 1099fix.sql from Microsoft to update tables. This is available with the download of the year-end update but contact me if you need a copy.

    2. The function used in SmartList for returning the description of the new box type is incomplete. Here's the text for the function. 

    /****** Object:  UserDefinedFunction [dbo].[DYN_FUNC_1099_Type]    Script Date: 12/16/2020 2:32:10 PM ******/
    SET ANSI_NULLS ON
    GO
    
    SET QUOTED_IDENTIFIER OFF
    GO
    
    ALTER function [dbo].[DYN_FUNC_1099_Type] (@iIntEnum integer) returns varchar(100) as  begin  declare @oVarcharValuestring varchar(100) set @oVarcharValuestring = case  when @iIntEnum = 1 then 'Not a 1099 Vendor' when @iIntEnum = 2 then 'Dividend' when @iIntEnum = 3 then 'Interest' when @iIntEnum = 4 then 'Miscellaneous' when @iIntEnum = 5 then 'Nonemployee Compensation' else ''  end  RETURN(@oVarcharValuestring)  END  
    GO
    
    
    



    ------------------------------
    Charles Allen
    Senior Managing Consultant
    BKD Technologies
    Houston, TX
    ------------------------------

    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 3.  RE: 1099 SmartList after YE Update-2016

    TOP CONTRIBUTOR
    Posted 21 days ago
    Edited by Joni Finnell 21 days ago

    Thanks  @Charles Allen! Please send me the script.

    Joni



    ------------------------------
    Joni Finnell
    GP Projects/Troubleshooter
    Consumer Support Services, Inc.
    Newark OH
    ------------------------------

    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 4.  RE: 1099 SmartList after YE Update-2016

    GPUG ALL STAR
    Posted 22 days ago

    If you were running a SmartList that used a SQL View based on the old values for 1099's, you can use the new SQL view I included in my new blog post! It works with GP 18.3 and newer versions!

    (I have posted on a bunch of discussion threads about 1099's today...I am just excited about the post because I know this is a HUGE issue!!). 

    https://trainingbyamberbell.com/2020/12/29/training-dynamos-survival-guide-for-microsoft-dynamics-gp-and-the-new-1099-nec-form/



    ------------------------------
    Amber Bell
    Training Dynamo LLC
    Email: amber@trainingdynamo.com
    Website: www.trainingdynamo.com
    Twitter: @trainingdynamo
    ------------------------------

    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 5.  RE: 1099 SmartList after YE Update-2016

    TOP CONTRIBUTOR
    Posted 21 days ago

    Thanks  @Amber Bell! We are using 2016R2. I'll look at your script to see if I can tweak it to work for us.

    Joni



    ------------------------------
    Joni Finnell
    GP Projects/Troubleshooter
    Consumer Support Services, Inc.
    Newark OH
    ------------------------------

    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 6.  RE: 1099 SmartList after YE Update-2016

    GPUG ALL STAR
    Posted 21 days ago

      @Joni Finnell

    I updated my blog post...I should have said it will work for anyone running GP2016 that did the Year-End update or anyone on 18.3 or newer. Basically, it works if you have the NEC option for a tax type.



    ------------------------------
    Amber Bell
    Training Dynamo LLC
    Email: amber@trainingdynamo.com
    Website: www.trainingdynamo.com
    Twitter: @trainingdynamo
    ------------------------------

    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 7.  RE: 1099 SmartList after YE Update-2016

    TOP CONTRIBUTOR
    Posted 21 days ago

    That is fabulous  @Amber Bell. Thanks!



    ------------------------------
    Joni Finnell
    GP Projects/Troubleshooter
    Consumer Support Services, Inc.
    Newark OH
    ------------------------------

    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


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