How can I identify checks not previously included in positive pay

[former_member585823]

I have received a request to provide a lis t of all checks not reported to the bank via the positive pay feature.  I've looked at table PAYR, but haven't idenfied a field that has the flag set indicating the check has been reported.  The positive pay program that creates the extract has an indicator that identifies checks previously reported.  Does any one know  in what table/field this indicator is stored?

Thanks,

Thomas P. Campbell

Business Process Manager, Finance

[vivek_srivastava12 · Accepted solution]

Hi Thomas,

Did you check the field "Date of Extract Creation" in PAYR table?

Regards,

Vivek

[former_member585823 · Accepted solution]

So looking for records where PAYR-EXTRD is zero will give me the checks that haven't been picked up by the positive pay program.  Makes sense, thanks.

[Former Member]

Dear Thomas,

If you have 3 gls account for one bank like Main, Receipt and Payment then you can easily find out list of check not reported to bank.

After posting bank reconciliation, all check payment open items available in sub ledger i.e Payment and Receipt are checks not reported to the bank.

Thanks,

Aditya

[former_member585823]

Hi Aditya,

That sounds like checks that haven't cleared the bank and that's not what I was looking for.

Thanks.

Tom.