Amount on Check Ledger Entry does not match amount on Bank Account Ledger Entry

mark02tj

I have a situation where the amount on Check Ledger Entry does not match amount on Bank Account Ledger Entry. The are off by approximately $7000. The amount on the check ledger entry does match what was printed on the check. However the Bank Account Ledger Entry and the corresponding G/L Entries are off. The Vendor Ledger Entry for the payment matches the BALE and the GLE. Has anyone seen this before?

I think how this happened is that they do the Suggest Payment Lines using the Summarize By Vendor Option. Then, the A/P person went into the applied entries before printing and deselect some of the entries - without changing the amount on the Payment Journal.

This difference between the Check and Bank ledger is preventing them from voiding the check. When trying to void the check, they are getting a "Currency Not Found" error since this is the error that is generated when the CheckAmountLCY and BalanceAmountLCY fields do not match in codeunit 367. Multicurrency is not enabled in this company.

Version is NAV 2017. Not sure of the build number.

Any suggestions to rectify this would be great!

THANKS!

RockWithNAV

This is quite interesting though. If the system is complaining on currency means some discrepancy had happen on a multi currency transaction.

I think how this happened is that they do the Suggest Payment Lines using the Summarize By Vendor Option. Then, the A/P person went into the applied entries before printing and deselect some of the entries - without changing the amount on the Payment Journal.

System updates the actual amount if you select or deselect any of the applied entries.