web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
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
I have the same question (0)
  • 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,922

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,922

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 835 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans