Reconcile to GL - Cannot Insert Duplicate Key

(0) Share

Report

Posted on by RJarrell

311

Hello everyone,

We are having an issue with our reconcile to gl feature when running against payables. It keeps giving us a duplicate key error from the payables window. I have run the scripts to find duplicates but have not seen anything. I have also manually went through the tables but once again did not find duplicates. The only thing that I have found is that there are some transactions that do seem similar. Please see below.

It gives us the error below. Something I have noticed about this transaction is that it involves credit cards. Below is an example of how it is setup.

Enter invoice for vendor. Ex. Invoice #INV25896 (closed - has distributions)

Create Payments - Payment #003225 (closed - no distributions)

Automatically Creates the Credit Card Invoice - Inv #003225 (open - no distributions)

The payment is in the closed tables and the credit card invoice is open. I don't think the invoice and payment having the same number should cause issue (since one is an invoice and the other is a payment) because it has been this way in the past but this is still the error we are getting. We do have a new accountant and the older accountant is currently unavailable so there is no way for me to know if they did anything different other than what I can see in the tables.

Let me know if anyone has any thoughts.

Thanks,

Categories:

Microsoft Dynamics GP

All responses (3)

Answers (0)

LarryP 2 on at

Like (0)

Report

RE: Reconcile to GL - Cannot Insert Duplicate Key

Justin I am experiencing this now. Has the update to fix this been released since you originally posted this? My client is running GP 18.4 (2021 year-end update) and is experiencing this exact issue with credit card transactions for one vendor. Attached is the error message, and a shot of the transactions that were part of that same audit trail. No duplicate vouchers there, so I'm not sure what the reconcile is pulling that causes the error.

Thanks,

Larry Patterson
Lisa Payment 65 on at

Like (0)

Report

RE: Reconcile to GL - Cannot Insert Duplicate Key

Hello, has an update for to resolve this been released?
Suggested answer

Justin Sutton on at

Like (1)

Report

RE: Reconcile to GL - Cannot Insert Duplicate Key

Hello RJ,

Overall the issue can occur if there are real duplicates, or if there is an identical voucher number and document number in a single batch. This is likely what you are running into, just look at the documents and see what Voucher Numbers and Document Numbers are involved.

This comes down to how the Stored Procedure making the temporary tables involved is coded. We used an OR when really we should have used an AND. This is a known issue as CR 92165 and it is being reviewed for a fix in a future release of GP.

If you confirm this is the issue, you can open a case with the support team and we can provide an updated procedure that just hasn't been tested enough to get included into the main GP release yet. Just note the CR and we will make sure you are not charged for the case.

Let me know if you have any questions or concerns.