Outstaning check register report

[Former Member]

Where can i get a report that shows me check not cleared yet in Bank Reconciliation?

[Former Member]

Hi Jason,

there is really not a good , easy way to get the info. Usually there is a outstanding check report in any system.

You can pull up the next Month Reconciliation and see what has not cleared.

To look up what has been cleared you can go to manage previous reconciliation.

There are ways to get the info but not as simple.

Try what was suggested above... hope that helps

Make sure you have Rev3 visible since that contains the check number

hope that helps

[Former Member]

That table only shows me the reconciliation summary, I need an outstanding checks report which lists all check not being cleared in teh system.

[Former Member]

Hello Rosi, I was wondering if you found out how to do the Outstanding Check report? Where should I look in the database to see all the checks that were not cashed?

Thanks,

Jason

[Former Member]

The General Ledger doe not give me the checks not being reconciled , I am doing Manual Reconciliation.

Yes I know if I pull up the next Bank reconciliaton I will see what has not been cleared, Need it in report form.

A query would do it which tells me if it is cleared Y or N

[jitin_chawla]

Hi,

Have you checked the table SVR1?

Please check the same and see it the same is of any help regarding the issue mentioned here.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member]

Hi Rosi,

Do you run the 'Unreconciled Transactions' option in the reconciliation reports? It will give list the checks, as well as any other unreconciled transactions.

- Go to Banking / Bank Statements & External Reconciliation / Reconciliation

- Select the reconciliation that was done

- Click on 'Print Settings' (bottom right button)

- Select 'Unreconciled Transactions'

If you also select 'Detailed Totals for External Reconciliations', it will include a nice summary at the end of the report.

Heather

[former_member1269712]

Hi Rosi,

Goto Banking-> Bank Statements and External Reconciliations-> Manual Reconciliations. Select Bank in Account Code and other information you will see uncleared transactions. If you are using Deposits and Checks for payment you will see it or else you will see Incoming / Outgoing payments.

Thanks

Sachin

[Former Member]

Hi Rosi........

You can get it in General Ledger. But select the payment transactions by choosing not reconciled option.......

Regards,

Rahul