Our cleek voided an AP transaction (debit AP, credit expense) but then an additional entry was somehow created which debited the bank and credited AP. As the AP entries essentially netted out, my AP listing did not change, when in reality AP should have decreased by the voided amount. If I simply credit bank and debit AP however, my bank balance gets fixed but the AP listing is not affected. How can I get my AP debit to be reflected on the AP listing in this situation?
Appreciate any help you all can provide :)
Hi Brandon, thanks very much for your response.
You are correct that the original AP transaction was posted in May and it was voided in July.
And yes I do see a negative transaction for the amount in the current month bank rec.
The additional entry I was referring to is a debit to bank and credit to AP for the voided amount. This causes my GL bank balance to differ by the bank rec by the amount of that transaction.
Given all of this, how would I go about having my GL bank balance match to the bank rec without just reversing that additional entry (as that would cause my GL AP balance to then differ from AP listing)?
Hey Mo,
It sounds like the transaction was voided in a different period then it was entered on, and your reports might not be run to include the date range when these were voided.
Is it possible that the GL Batch for the void has not been posted yet?
Was this Reconciled before it was voided? If so, GP creates a negative transaction in the Bank Rec when voiding a Reconciled transaction. Is this perhaps what you are seeing as the additional transaction? Do you see a negative transaction from the void on the Bank Rec side?
We can't make a one-sided adjustment to correct this. the actual problem transaction I believe will need to be found and corrected. If we create additional documents in PM to attempt to correct the AP Balance, you will end up with a document that never gets closed out
You say there was an additional entry. Have you found this? What does it look like? Where do you see this at?
It is also hard to tell if you are referring to the actual modules being off, your Checkbook being off or just the GL Accounts being off in the GL side.
Take a read through the link below as it might help to find the transaction(s) that are causing the incorrect balances.
docs.microsoft.com/.../differences-when-reconciling-gl-to-payables-or-receivables-management
I hope this helps!
Thank you!
Brandon | Microsoft Support Engineer.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156