Open Forum

 View Only
  • 1.  1099 Details Window Error

    SILVER CONTRIBUTOR
    Posted 10 days ago
    Hello all!
    We are all receiving an error when using the 1099 Details window.  Once we select a vendor then click enter or Select, a popup error is displayed:  "Unhandled script exception: SCRIPTS - data area  EXCEPTION_CLASS_SCRIPT_ADDRESSING".  Any changes within the window will create the same error (basically any action that tries to populate data in the window).  This happens to all users including SA.  I was able to use Power Tools to create a log, and it has duplicate key errors: "Violation of PRIMARY KEY constraint 'PKPM00204'. Cannot insert duplicate key in object 'dbo.PM00204'. The duplicate key value is (VendorID** , 2, 2022, 1, 1).*/ " **Vendor ID is the vendor that is selected to view.  If we try to make changes in any fields of the 1099 Details window prior to selecting a vendor, we get a popup error: "A range start operation on table 'pm1099PeriodDtlTemp' is for an invalid key'".

    We are not sure if this started after the year end update (we are on V 18.4.1384), or the October update last fall since we do not access this window often.  I did find something similar mentioned as a know upgrade issue for the fall 2020 upgrade, but we did not have issues with that upgrade (or this one for that matter).

    Any help would be appreciated!

    Thank you,
    Jean


    ------------------------------
    Jean Hill
    Network Engineer
    H&W Computer Systems, Inc
    Boise ID
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: 1099 Details Window Error

    Posted 9 days ago
    I ran into this on a client site please see the attached Link.

     Duplicate Keys error when we went into edit the 1099 Details which also caused the edit list in the print 1099 window to bring in all vendors weather they were 1099 able or not. See link below for this and more 1099 fixes.  it is quick and easy, I also had a problem when I went to run the 1099 Edit List for Dividend there are 2 boxes that need 0.01 added to them.

     

    Microsoft Dynamics GP Year-End Update 2021: Payables Management form changes - Microsoft Dynamics GP Community

    Carol

    ------------------------------
    Carol Mamerow
    Heartland Business Systems
    Little Chute WI
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: 1099 Details Window Error

    SILVER CONTRIBUTOR
    Posted 9 days ago

    Thank you Carol,

     

    I did run across this article, but it doesn't apply to us.  When I checked the PM40104 table, I did not see any duplicate entries, and the values for three text boxes listed in the select statement were all correct. 

     

    Thank you for responding though!

     

    Jean

     

     

    _______________________________
     
    Jean Hill
    Network Engineer
    H&W Computer Systems, Inc.
    jhill@hwcs.com

     
    www.hwcs.com
     

     

     




    Academy - Online Interactive Learning from Experts


  • 4.  RE: 1099 Details Window Error

    SILVER CONTRIBUTOR
    Posted 10 hours ago
    Hello all,
    I just wanted to post the resolution here so that it is available if anyone else experiences this issue.  After ruling out all other areas, we discovered that our FORMS.DIC had been corrupted.  We have a shared copy on a server, so that is why it affected all users.  We had to recreate both the FORMS.DIC and the REPORTS.DIC files and were back up and running.

    ------------------------------
    Jean Hill
    Network Engineer
    H&W Computer Systems, Inc
    Boise ID
    ------------------------------

    Academy - Online Interactive Learning from Experts


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