Open Forum

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

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 ONGOSET QUOTED_IDENTIFIER OFFGOALTER 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

Original Message:
Sent: Dec 23, 2020 08:18 AM
From: Joni Finnell
Subject: 1099 SmartList after YE Update-2016

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
------------------------------

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

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/

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

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

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/

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

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.

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

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/

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