Open Forum

#GP2015and2015R2 #GeneralLedger

I am confused by the Potentially Matched Transactions I get when running Reconcile to GL for AR.

Here are both sides of the spreadsheet with two transactions that appear to match, but are still listed in Potentially Matched Transactions.

Why don't they appear in Matched Transactions or how to I get them to match?



​​

------------------------------
Rick Roen
Seeds by Design
Willows CA
------------------------------

hi Richard,  The potentially matched section just means that the original transaction doesn't have the same document number as the side it's matching up to.  Example shipment receipt from a PO and the invoice match.  They are absolutely related but they have different document numbers.  I've never seen an issue in the potentially matched section.  You only need to focus on the unmatched.  Potentially matched will never move to matched.  Not an issue.  Hope that helps.

------------------------------
Teri Carpenter
President
TD Carpenter & Associates, Inc.
Toledo OH
------------------------------

Original Message:
Sent: Nov 08, 2020 07:02 PM
From: Richard Roen
Subject: Potentially Matched Transactions in AR

#GP2015and2015R2 #GeneralLedger

I am confused by the Potentially Matched Transactions I get when running Reconcile to GL for AR.

Here are both sides of the spreadsheet with two transactions that appear to match, but are still listed in Potentially Matched Transactions.

Why don't they appear in Matched Transactions or how to I get them to match?

​​

------------------------------
Rick Roen
Seeds by Design
Willows CA
------------------------------

Thanks Teri.  It's good to know that I can simply ignore them.

------------------------------
Richard Roen
Seeds by Design
Willows CA
------------------------------

Original Message:
Sent: Nov 09, 2020 08:39 AM
From: Teri Carpenter
Subject: Potentially Matched Transactions in AR

hi Richard,  The potentially matched section just means that the original transaction doesn't have the same document number as the side it's matching up to.  Example shipment receipt from a PO and the invoice match.  They are absolutely related but they have different document numbers.  I've never seen an issue in the potentially matched section.  You only need to focus on the unmatched.  Potentially matched will never move to matched.  Not an issue.  Hope that helps.

------------------------------
Teri Carpenter
President
TD Carpenter & Associates, Inc.
Toledo OH

Original Message:
Sent: Nov 08, 2020 07:02 PM
From: Richard Roen
Subject: Potentially Matched Transactions in AR

#GP2015and2015R2 #GeneralLedger

I am confused by the Potentially Matched Transactions I get when running Reconcile to GL for AR.

Here are both sides of the spreadsheet with two transactions that appear to match, but are still listed in Potentially Matched Transactions.

Why don't they appear in Matched Transactions or how to I get them to match?

​​

------------------------------
Rick Roen
Seeds by Design
Willows CA
------------------------------

@Richard Roen,

The Dynamics GP Reconcile reports just don't dig deep enough into the data to figure out if there is an issue or not.  That's where the Potentially Matched section of the report comes from. More often than not these are false positives and you end up down a rabbit hole.

We use The Closer from Reporting-Central. Their reports and analysis dig deeper and their use of error codes let us know where the underlying issue is, no "potentially matched" transactions with The Closer.

I know purchasing an add-on ISV is not always cost effective, but I believe the time savings have truly offset the cost of the application.

Regards,

Bryan

​

------------------------------
Bryan Robertson
Director, ERP Operations

GPUG All*Star
Member, GPUG Advisory Committee
Chairman, Florida (Ft Lauderdale/Miami) Regional GP Local User Group

SBA COMMUNICATIONS CORPORATION
8051 Congress Avenue Boca Raton, FL 33487

561.226.9568 + T
brobertson@sbasite.com
------------------------------

Original Message:
Sent: Nov 08, 2020 07:02 PM
From: Richard Roen
Subject: Potentially Matched Transactions in AR

#GP2015and2015R2 #GeneralLedger

I am confused by the Potentially Matched Transactions I get when running Reconcile to GL for AR.

Here are both sides of the spreadsheet with two transactions that appear to match, but are still listed in Potentially Matched Transactions.

Why don't they appear in Matched Transactions or how to I get them to match?

​​

------------------------------
Rick Roen
Seeds by Design
Willows CA
------------------------------

The Dynamics GP Reconcile reports only perform a very basic analysis. Data in GP is stored in multiple tables and the GP reports just don't dig deep enough into the data to confirm if there is an issue or not.  These are the transactions that marked as Potentially Matched. These are more often than not false positives and send you a on wild goose chase. We use The Closer from Reporting-Central which is a much better tool. Their analysis is much deeper and they have error codes that classify what the underlying issue is, there are no "potentially matched" transactions with The Closer.  We use it for ap and bank trxs as well.  You should look into it! 

------------------------------
Theresa Rago
Manager, Financial Systems
CV Starr & Co, Inc.
New York NY
------------------------------

Original Message:
Sent: Nov 08, 2020 07:02 PM
From: Richard Roen
Subject: Potentially Matched Transactions in AR

#GP2015and2015R2 #GeneralLedger

I am confused by the Potentially Matched Transactions I get when running Reconcile to GL for AR.

Here are both sides of the spreadsheet with two transactions that appear to match, but are still listed in Potentially Matched Transactions.

Why don't they appear in Matched Transactions or how to I get them to match?

​​

------------------------------
Rick Roen
Seeds by Design
Willows CA
------------------------------