web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Posted payment show in...
Microsoft Dynamics NAV (Archived)

Posted payment show in G/L & COA, but the entry is missing in Bank Trial Balance

(0) ShareShare
ReportReport
Posted on by Kelvin Fish 20

Hi Experts,

We have posted a payment to vendor through payment journal.

Debit the Vendor Account, Credit the Bank Account.

The entry is showing in the General Ledger Entries.

Also, it is showing in the COA Bank account.

However, when we print the Bank Detailed Trial Balance report,

the transaction is missing and it cause discrepancies.

How can we troubleshoot this issue?

Thanks

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Amol Salvi Profile Picture
    Amol Salvi 18,698 on at

    Check if you have selected Bank Account for credit side. I think you have selected G/L in Bal. Account No field.

  • Verified answer
    RobertasR Profile Picture
    RobertasR 5,004 on at

    Hi Kelvin

    if you click 'Navigate' on any of the created entries, does it show 'Bank Ledger Entry' as one of the entries created, or just 'Vendor Ledger Entry', 'Detailed Vendor Ledger Entry' and 'G/L Entry'?

    If 'Bank Ledger Entry' is not there, it means the payment was posted directly to the G/L Account of the bank, rather than a Bank Account card to balance the payment (it is recommended to remove 'Direct Posting' from such G/L Accounts to prevent them from being used directly on journals).

    Otherwise you might have some filters on the Bank Detailed Trial Balance report that prevents the entry from showing there (Posting Date, or Dimension).

    Robertas

  • Kelvin Fish Profile Picture
    Kelvin Fish 20 on at

    Hi Robertas,

    It is exactly what you said.

    Only G/L, Vendor Ledger Entry, Detailed Vendor Ledger Entry were created.

    Apart from remove Direct Posting from the related G/L (e.g. Accounts Payable).

    What can I do to fix it now?

    Thanks

    Kelvin

  • Suggested answer
    RobertasR Profile Picture
    RobertasR 5,004 on at

    Hi Kelvin,

    before you remove 'Direct Posting', you can either 'Reverse' the transaction (from GL Register) and post again properly, or the quicker way is to post a general journal - Debit the G/L Account, and Credit Bank Account. That will not change the G/L balance (credit&debit goes to the same account) but will create the Bank Account Ledger. And if you use the same date and Document No. as original transaction (journal batch should allow manual numbering) then Navigate will always include the correction as well.

    And then remove the Direct Posting.

    Happy to help.

    Robertas

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans