Payables Reconcile to GL Error for voided transactions

(0) Share

Report

Posted on by Community Member

Dynamics GP 2015 R2 (14.00.0952). The spreadsheet generated by "reconcile to GL" is producing confusing results when I:

1)Make an entry in Payables->Transaction entry, where the invoice is entered and paid (with cash in my case) in the same window.

2)Void the payment from Payables->Void historical transactions

3)Void the invoice from Payables->Void open transactions.

Here's what the spreadsheet looks like after that: (DUMMY is the invoice number.)

The two unmatched transactions on the payables side are what's confusing me. I understand why those might appear in payables and not in GL, because the original transaction never touched the payables GL account.

Perhaps the problem is that one of those unmatched transactions should be positive instead of negative? Maybe this is a bug in the reconcile to GL module?

Thanks in advance for any explanations.

Lee

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

MattPaulen 6,912 on at

Like (0)

Report

Seems like a bug to me. I was able to recreate the same thing.

Was this reply helpful? Yes No
sandipdjadhav 18,306 on at

Like (0)

Report

Hi Lee,

I believe when original transaction created in AP it did not hit Accounts Payable. That's what you are seeing both transactions 'Not Matched'

Whereas when it voided it hit your Accounts Payable. All matched shows only voided transactions with PMVP...

Now question is that when voided transaction did someone has change distribution in General Journal?

Thanks much

Sandip Jadhav

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

You're correct that the original transaction did not hit the GL account for AP at all. The original distribution was a debit to the PURCH account and a credit to the CASH account.

When I voided the payment, it created a debit to the CASH account and a credit to the AP account. That's why the voided payment shows up in the matched transaction section.

When I voided the invoice, it created a credit to the PURCH account and a debit to the AP account. That's why the voided invoice also shows up in the matched transaction section.

I didn't edit the distributions at all when I voided the payment and the invoice; GP made those entries automatically, and I'm pretty certain that it made the proper GL entries.

So I understand why the original transactions are not matched in GL (because they weren't in the payables GL in the first place.) What I don't understand is why they add up to $(18.00) instead of $0. Both of those unmatched transactions are negative; I think one of them is supposed to be positive.

Lee

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am having a similar situation and I cannot figure out how to fix this or why the original invoice is showing as credits instead of debits against the GL as credits. All other invoices are showing as debits in the On Account column, except these. The voided documents in the bottom of the report show correctly. How do I fix this? What table is it pulling the On Account amount from?

Was this reply helpful? Yes No
Thomas Shooter 40 on at

Like (0)

Report

Does anyone have a solution for this. Is happening at my customer as well.

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

Hi,

I remember an old problem where a transaction was entered and paid in the transaction entry window and then later voided. The void got confused because the entry never hit the accounts payable account. The original entry was to debit expense and credit cash. To avoid these kinds of things happening, you could go into the Company setup Options window and check the box next to Separate Payment Distributions. With that checked, when you enter and pay the transaction on the transaction entry window it posts two entries:

Debit expense

Credit payables

Debit payables

Credit cash

Give that a try and see if it helps.

Kind regards,

Leslie

Was this reply helpful? Yes No
Thomas Shooter 40 on at

Like (0)

Report

Thanks Leslie. I will check that box so it does not happen in the future. the problem is how to get rid of those two extra reconciled lines. In the above example it is 9.00. The sing entry in AP and GL for the transaction is in the reconciled area (as it should be). there is nothing in the distribution relating to any other entry that is causing it. It is 2 extra negative amounts in the report.

I am not even sure where this information is coming from. I check the usual suspects in the payables tables then I check every table starting with PM but still could not find it. I was hoping to remove it using SQL but I need to find it first.

Does anyone know all the tables that the reconcile to GL accesses for the AP side of the spreadsheet?

Was this reply helpful? Yes No
Thomas Shooter 40 on at

Like (0)

Report

OK I did the good old fashion Table import to identify the tables. It was exactly like I thought PM10100 and PM30600. Nothing unexpected showed up when I looked at those tables but here's how I got it to balance. If I included the bank account that had the voided transaction it matched those two Transactions (and only those two transactions) and everything was in balance.

Does that make sense to anyone?

Was this reply helpful? Yes No