Account Payable - Open Liability Reconciliation Report out put

Hello All ,

I need a small help , where in AP we have couple of voucher under one company and user posted the manual journal for those voucher in GL . but when they are running the

Accounts Payable > Reports > Voucher Reconciliation > Open Liability Reconciliation > APY1400 (PSJOB) those voucher still showing in the report are open AP , how can i make them not to come in the open liability report ..

When i look at the data in vchr_acctg_line table the GL_DISTRIB_STATUS is not D(Distributed) and journal date is empty due to user manual journal entry.. i thought updating the GL_DISTRIB_STATUS to D and journal date with some date so that it will not list into