Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / error when choosing a ...
Finance | Project Operations, Human Resources, ...
Suggested answer

error when choosing a vendor in 1099 detail card

(0) ShareShare
ReportReport
Posted on by jbeck2014 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:
Microsoft Dynamics GP
  • 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

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,419 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,492 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans