btamulis 12/19/2025 9:25:11 AM

GP AR Reconcile to GL Routine Error

We have one month where when we run the Financial Routine - Reconcile to GL for our Receivables we get a SQL Error concerning a duplicate primary key violation.

I have run check links on the Sales/AR Files to no avail.

The error only occurs in July - the process does complete after user clicks okay - results are not as expected - GP populates the 'Unmatched section' with lots of transactions that are certainly matched to GL journal entries.

Here's a screenshot - just wondering if anyone had a similar problem and any suggestions on corrective actions.

Version: All
Section: Dynamics GP, SQL for Beginners


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3