Skip to main content

Notifications

Microsoft Dynamics GP forum
Suggested answer

error when choosing a vendor in 1099 detail card

Posted on by 365

Going into the 1099 detail card and selecting a vendor, we receive the following error message:  A range start operation on table 'pm1099PeriodDtTemp' is for an invalid key.  No vendor has been selected yet, it's when we get to the vendor lookup screen.

We recently upgraded to 2018 version 18.4 with the November, 2021 release so that we could get the new 1099-NEC report layout in our test environment.  We haven't upgraded production yet.  Production is on 2018 18.4 with the October, 2021 release.  The 1099 detail card works perfectly in production.

What happened in the new release to cause this error and how do we remedy it?

Thanks.

Julie

Categories:
  • Suggested answer
    Nicole Hellerud Profile Picture
    Nicole Hellerud 1,712 on at
    RE: error when choosing a vendor in 1099 detail card

    Hi JBeck-

    Thank you for your post. 

    We've seen a few cases around this, and it was a result of the TEN99BOXTEXT in the PM40104 table for TEN99TYPE 3 and TEN99BOXNUMBER 11 and/or 12. TEN99BOXNUMBER 11 should be 13 with a DOLRAMNT of .01 and TEN99BOXNUMBER 12 should be 4 with a DOLRAMNT of .01 .

    The following are SELECT SQL statements that you can leverage to locate these records. 

    SELECT * FROM PM40104 WHERE TEN99BOXNUMBER = 11 AND TEN99TYPE = 3
    SELECT * FROM PM40104 WHERE TEN99BOXNUMBER = 12 AND TEN99TYPE = 3

    I hope this helps.

    I look forward to your feedback when available.

    Nicole Sutton 
    Support Engineer
    Microsoft Dynamics

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans