Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Reflect reversal of Bank/AP transaction in Ap listing

Posted on by 5

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 :)

Categories:
  • Mo J Profile Picture
    Mo J 5 on at
    RE: Reflect reversal of Bank/AP transaction in Ap listing

    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)?

  • Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Reflect reversal of Bank/AP transaction in 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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans