A save operation on table 'pm1099PeriodDTTemp' has created a duplicated key

(0) Share

Report

Posted on by Robert Yao

522

Hi All,

Received an error in 1099 details when switched to tax type to Miscellaneous 'A save operation on table 'pm1099PeriodDTTemp' has created a duplicated key' for all the vendors, see below:

Click More Info and see

Does anyone see this error before?

Thanks,

Rob

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Andrea Melroe 3,437 on at

Like (0)

Report
Copy link

Link copied!

Hi Robert,

Yes, I've seen this error crop up. Please see Question/Answer #7 in the following blog for the cause/resolution:

Microsoft Dynamics GP Year-End Update 2021: Payables Management form changes - Microsoft Dynamics GP Community

Hope this helps!

Was this reply helpful? Yes No
Robert Yao 522 on at

Like (0)

Report
Copy link

Link copied!

Hi Andrea,

Thanks for the quick response, it looks like this problem only affected upgrading from early version to GP18.4.1384, it did not happen to if you are already in GP2018, very interesting.

Thanks again,

Rob

Was this reply helpful? Yes No
Beat Bucher GP Gee... 28,061 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Robert,

check this other thread where the problem was evoked too..

community.dynamics.com/.../gp-2018-and-1099-nec-forms

I noticed too that a new Fabrikam company that was created with the newer GP version did already have the right values in the PM40104 table, except for the 600$ amount in one row, where it had 0$. Other companies where I ran into the problem were created with a version 2016 or likely much earlier in GP 2010 or 2013.

Was this reply helpful? Yes No