Dynamics Community Forum Thread Details

Payables Reconcile to GL routine

Using GP10 SP5. Is there any good tutorials out there that can explain (in detail) how to use the Reconcile to GL routine – Payables? I ran it, it created the spreadsheet and I'm trying to figure out: 1) how to read it 2) how to fix when there is a difference. For example, I created a PM trx and used a credit card to pay use tax and this shows as possible match and there are other scenarios like this that do not show as a perfect match. And there is a difference. And if the diff is not corrected, the reconcile will be off going forward indefinitely so I’d like a good tutorial on this Reconcile to GL routine. Also some of the rows are shaded and there is no mention of this shading I can find in the help.
Thanks.
LearningGP

There is no tutorial that I am aware of on this but there is a blog you can refer to:

community.dynamics.com/.../frequently-asked-questions-about-the-reconcile-to-gl-routine-in-microsoft-dynamics-gp.aspx

The reconcile criteria we use in the utility are:

Matched

Transactions from Receivables Management or Payables Management are “matched” using the transaction source code, document number, transaction date, and transaction amount.

Potentially matched

Transactions are identified as “potentially matching” if some, but not all the information matches. For example, if the source document code for the transaction in Receivables Management or Payables Management matches the code in General Ledger, but the transaction dates or amounts don’t match, the transactions are considered a potential match. Similarly, the transaction dates and amounts might match, but the source document codes can be different. In this case, the transactions are listed in the spreadsheet as potentially matched.

Unmatched

If a transaction exists in General Ledger, but not Receivables Management or Payables Management—or vice versa—the transaction is considered “unmatched.” For example, a transaction might have been posted in Receivables Management, but not have been posted in General Ledger. Transactions in Work tables aren’t included in the reconcile process.

Regards

Rob

Quick Links

Leaderboard