error when choosing a vendor in 1099 detail card

(0) Share

Report

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:

Other

All responses (1)

Answers (0)

Suggested answer

Nicole Hellerud 1,712 on at

Like (0)

Report

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