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
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
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
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
Check if you have selected Bank Account for credit side. I think you have selected G/L in Bal. Account No field.
Share
Report
All responses (
Answers (
