Share
Report
277Hello 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,
RJ
All responses (
Answers (
