Sage 100

 View Only
Expand all | Collapse all

NOTICE ON 1099-NEC UTILITY FOR SAGE 100

  • 1.  NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 11-20-2020 17:45
    I'm using this group to post a notice for the 1099-NEC Utility released by Sage.

    Our own @Jeff Fiddelman discovered a flaw that has been tested and was confirmed yesterday by @Sue Bennett.

    The 1099 NEC Utility does NOT update AP Open Invoice file.   

    Since 1099s are based on payments, invoices paid after the 1099-NEC utility are not properly recorded to the 1099 History. Re-running the utility will not fix the issue. 

    SAGE IS AWARE OF THE PROBLEM AND IS WRITING A HOT-FIX FOR THIS ISSUE.

    If you have installed the 1099-NEC utility from Sage you will need to install the hot-fix when it is released. 

    Release date is pending.  We will keep you informed. 

    BIG Thanks to @Jeff Fiddelman and @Sue Bennett for bringing this issue to the forefront.
    ​​​​

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------


  • 2.  RE: NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 11-30-2020 20:19
    Hi
    Did I miss a hotfix, or is this not released yet?
    Thanks
    Nancy

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------



  • 3.  RE: NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 11-30-2020 21:08
    I have just reported to Sage and they are aware of that the new 1099-NEC is not available in PO module, When creating a new PO for a vendor that is set to receive a 1099-NEC it will be blank and you will not be able to select 1099-NEC.  Apparently this is being fixed in a future service pack but I don't know when this will happen as they have not had many calls on this. Apparently this will not be fixed by year end in time for 2021 and not sure if it will be backward compatible.

    Apparently there is an item on ideas list and please go vote on it. Sage has not deemed this to be urgent.

    ------------------------------
    Avron Katz
    K-Four Systems, LLC
    ------------------------------



  • 4.  RE: NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 12-01-2020 13:19
    The updated utility hasn't been released yet, we will keep everyone posted.

    Regarding the Purchase Order selection of a 1099-NEC form during entry or editing an existing Purchase Order from a 1099-MISC to a 1099-NEC form, I am in process of pursing a resolution. 


    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------



  • 5.  RE: NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 12-04-2020 14:52

    We expect updated utilities next week that will correct issues with the existing 1099 utility and AP open invoices.  The utilities are in testing and review.

    A product update will be released next year (first quarter) to address the selection of the 1099-NEC form the Purchase Order Entry.  It will cover release versions 2019, 2020, and 2021.  It will not cover the 2018 release. 




    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------



  • 6.  RE: NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 12-04-2020 14:55

    Our Support desk sent out this notice to all our consultants this morning.

    Sage has updated the 1099 NEC utility so that it now correctly changes the items in the AP_OpenInvoice file. 

     

    Sage 100 AP Update 1099s Utility AP6001T

    Created on 12-01-2020 | Last modified on 12-03-2020

    Summary

    Product Affected: Sage 100 2020 (6.20.0 – 6.20.1)
    Sage 100 2019 (6.10.3 – 6.10.4)
    Sage 100 2018 (6.00.9 – 6.00.10)
    Program Fix Number: AP Update 1099s Utility AP6001-T
    Date: December 2, 2020
    UPDATES TO THE EXISTING AP1099 NEC UTILITY:
    1. Utility now updates AP_VendorPayment records that are greater > = 2020 (original utility was only updating 2020 records)
    2. Added AP_OpenInvoice to the utility
    3. Added a prompt if the utility has already been run. (reading thru Activity Log)

    INSTRUCTIONS

    1. This utility can only be run if you are at version 6.0.9, 6.10.3, 6.20 or greater. The utility needs the 1099 NEC code that was added in these versions.
    2. Make sure you are in the company that you want to correct.
    3. From the File menu select Run:
    4. Type in SYZCON
    5. At the Command Prompt type in the following command
    6. RUN "../Utility/AP_Update1099s_Utl"
    7. This utility will move 2020 or greater MISC box information that was setup like 2019 MISC box information to the correct 2020 and greater MISC and NEC boxes.
    8. The utility will read SY_ActivityLog to determine if this utility has already been run for this company. If there is record in the activity log indicating that the utility was run.

    Resolution

    This utility can only be run if you are at version 6.0.9, 6.10.3, 6.20 or greater. The utility needs the 1099 NEC code that was added in these versions.
    Make sure you are in the company that you want to correct.
    From the File menu select Run:
    Type in SYZCON

    Related resources

    • 1099-NEC form new starting year 2020 for Accounts Payable Nonemployee Compensation.Product: Sage 100cloudPublished on: 12-03-2020 
    • Applies to: Corruption
    • Solution ID: 108088
    • Keywords: 


    ------------------------------
    [Sue] [Dunn]
    [Client Advisor]
    [MicroAccouting Solution]
    [Milwaukee] [WI]
    [414.587.4641]
    ------------------------------



  • 7.  RE: NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 12-04-2020 15:01
    As of 11:30 am PST that could is still in review, per Sage.

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------



  • 8.  RE: NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 12-04-2020 15:53

    Moira is correct, my apologies.  Our support desk saw the post and assumed it was ready.  They confirmed that it is not yet available for download.​

    ------------------------------
    [Sue] [Dunn]
    [Client Advisor]
    [MicroAccouting Solution]
    [Milwaukee] [WI]
    [414.587.4641]
    ------------------------------



  • 9.  RE: NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 12-08-2020 14:24
    We know that the code has been reviewed, as of today Dec. 8, 2020, but not released yet by Sage.  Per @Jeff Fiddelman, the two utilities looked good and he provided an FAQ for Sage's use. 

    Also, Aatrix isn't ready which was noted in another post too. 



    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------



  • 10.  RE: NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 12-10-2020 15:55
    Per Sage City posting:  "We plan to have the hot fix posted this Friday by end of the day."

    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 11.  RE: NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 12-14-2020 23:06
    Edited by Jeff Schwenk 12-14-2020 23:06
    did this happen?  Or is Tomorrow always a day away???

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 12.  RE: NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 12-15-2020 08:18
    It was posted sometime last night or early this morning, but when I click the link to download, "Hmm...we're having trouble finding that site."  :-)

    ------------------------------
    Susan Pawlowic
    Sage 100 Solutions Architect
    RKL eSolutions, LLC
    ------------------------------



  • 13.  RE: NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 12-15-2020 13:15
      |   view attached
    Attached...

    ------------------------------
    Susan Pawlowic
    Sage 100 Solutions Architect
    RKL eSolutions, LLC
    ------------------------------

    Attachment(s)



  • 14.  RE: NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 12-15-2020 13:23
    Edited by Moira Goggin 12-15-2020 13:23
    This is posted in the 90 Minds Resource Library too with the full install instructions and usage guidelines.  You can find the details here:

    Utility and Usage AP-6001-T for 1099-NEC

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------



  • 15.  RE: NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 12-15-2020 14:05
    Elliott mentioned a version that could be run multiple times?

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------



  • 16.  RE: NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 12-15-2020 14:52
    In the Chat someone asked where that can be found, and he said both the one-time and the multiple-times fixes are in the AP6001T.

    ------------------------------
    Susan Pawlowic
    Sage 100 Solutions Architect
    RKL eSolutions, LLC
    ------------------------------



  • 17.  RE: NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 12-15-2020 15:26
    Documentation I just downloaded 12/15 said message appears:
    "Utility has already been run, Do you want to proceed" if you have run it in the company.
    Document doesn't mention effects of running it multiple times.  Was Elliot referring to an upcoming change?

    ------------------------------
    Lee Graham
    Friendly Systems, Inc.
    ------------------------------



  • 18.  RE: NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 12-15-2020 18:42
    Edited by Moira Goggin 12-15-2020 18:43
      |   view attached
    Under the reference library  post in 90 Minds, I included the PDF instructions, which I've attached directly for quick reference. (From the 90 Minds menu, select Browse, Resource Libraries., then Sage 100 Install Sets)


    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------

    Attachment(s)



  • 19.  RE: NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 12-15-2020 18:59
    Aha, so the AP100Misc7_utl Utility mentioned on page 6 of the doc "can be run as often as needed" and  is different from the AP_Update1099s_utl utility listed on page 1 and 2.


    ------------------------------
    Lee Graham
    Friendly Systems, Inc.
    ------------------------------



  • 20.  RE: NOTICE ON 1099-NEC UTILITY FOR SAGE 100

    Posted 12-16-2020 21:30

    IDK, was it just me or did others have to look under too many rocks to find the hot fix?  Just painful.  Thanks  @Susan Pawlowic for posting it above.



    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------