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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148