Bank Reconciliation Status show "Not Posted"

SUGGESTED

Hi 

I have a deposit batched posted with 14 entries, and Entry no. 9 has repeated in bank recon with status show "Not Posted" in bank recon. This repeated entry actually was already replaced with a other details. Somehow it show in the bank recon and not allow to edit or change the status. Anyone can advice how to remove or fix this error?

Many thanks.

Parents Reply
  • 0 in reply to Eva Paterson

    Receipt batch is posted.  

    The complicated part is that there are many entries in the AR Receipt batch, entry 22 was deleted and the batch posted successfully.

    When doing bank reconciliation, unable to change the Receipt entry to "Cleared".  When zoomed in to detail, all entries showed "Reconciliation Status" as "Outstanding" except for entry 22 showing "Not Posted" which was previously deleted in AR.

    How do i go about to change file/field in the MSSQL for Reconciliation Status from "Not Posted" to "Cleared" ?

Children