1099-NEC question

SOLVED

I have read about the utility to move 1099-MISC data to the 1099-NEC boxes.

I have a few questions.

1. Can the utility be processed at any time?

2. Is it best to run the utility at year-end, after 2020 entries and before 2021?

3. If the utility is run in 2021, will it affect both 2020 and 2021 1099 data?

Just trying to determine the best practices for using this utility.

Any thoughts are greatly appreciated!

  • 0 in reply to Bvulliamy

    Please see my comments above about the details of the original AP_Update1099s_utl utility. It was a one time utility meant to be run once before you entered 2020 1099 data. If you want to add misc box 7 data to existing NEC box 1 data, use the new AP_1099MISC7_utl utility. That can be run multiple times. 

  • 0 in reply to SusanneN

    So the original utility should have only been run if no 2020 1099 data existed and the new AP_1099MISC7 should be run if 2020 1099 data already exists under misc box 7? I think many of us ran the original utility with 2020 1099 data already being entered in the system and now are confused how to move forward with this new utility. It sounds like we will have to fix the open invoices manually?

  • 0 in reply to dhalpin

    The new utility will move the open invoices for MISC box 7. There are documents for both utilities in the Sage100 Utility directory that might be helpful. 

  • 0 in reply to SusanneN

    We recently updated from Sage 100 2019.0 to 2019.4 as well as Payroll 2.20.1 -> 2.20.3 -> 2.21.0. We also installed the hotfixed AP6001T utility. After performing those updates (and doing the normal data conversion after update) we ran the AP_Update1099s_utl on our company. The log indicated that it properly moved data from MISC, Box 7 to NEC, Box 1.

    However, when we pull up one of the vendors that this was done for, it properly shows the Default form as "Nonemployee Contribution" but the Box field is blank. In fact, the dropdown is empty. We're wondering if this is expected behavior?

    As additional datapoints, we also ran the AP_1099MISC7_utl utility with no apparent change. We did open the AP_Vendor.M4T and AP_Vendor1099Payments.M4T files and the data appears correct.

  • 0 in reply to twc

    Change your default 1099 year to 2020 in ap options

  • 0 in reply to Bvulliamy

    That worked! Thank you for the quick and accurate response!

  • 0 in reply to Linda KR

    I just upgraded a client from v2018 to 2021.  Tried to run the utility, but got the message "this utility is no longer available".  It's present in the MAS90\Utility folder.  Nothing happened during the conversion. Was this utility not updated for later versions than 2020?

  • 0 in reply to barbgold

    We removed this utility. It was intended to be run for the 1099s printed in year 2020. It should have only been run if you entered data based on 2019 1099 boxes before the 1099 NEC code changes were completed. The warning was very specific. If your customer is at version 2018PU10, you should not be running this utility. It will corrupt the data. If you are at an older version of 2018, you may need to contact support for guidance. 

  • 0 in reply to SusanneN

    What about when clients on unsupported versions are upgraded into current versions?  What are they to do to update?

  • 0 in reply to barbgold

    Use VI to export the data and then import into the correct boxes.  You may need to import in zeros to clear out the old boxes.

    You will also need to import into Vendor maintenance to change the default form and boxes.