#574 Bank reconciliation not printing SQL error

Received from Cheryll Richter
Bank reconciliation (Action -> Reconciliation (Bank Reconciliation screen - Print button) not printing - SQL error:

A:
Dynamic SQL Error
SQL error code = -204
Table unknown
BAT0T3
At line 1, column 24

Set of Books does not contain BAT0T3 - Checked in SQLBrowser.

...\plug_ins\reports\GENERAL\documents.rep
Dataset A on Bank recon report
select * from BAT0T3 where Waccountid <> 0 and Wlineid = Wlinkedid

[Anonymous]

This SQL error is not replicated in other Sets of Books where BAT0T3 table exists.

Checked in Builds 600, 962 and 980 - Works fine Bank Recon report is printing - Also in the available postgres and MySQL databases.

On all the mentioned builds, it does not print and produces the SQL Error only when the books with a missing BAT0T3 table is found.

[Anonymous]

Checked the Books created with the Advanced option on the Creation wizard (Customize yout own Set of Books (Advanced). The BAT0T3 table is in the database.

[Anonymous]

Location : ...\plug_ins\reports\GENERAL\documents\recon.rep

This report works in most databases (e.g. HANDYMAN-B) can print it for a Petty cash (as a bank account) and the existing Bank account (e.g. ABC-Bank) older Bank accounts.

The Bank reconciliation report does not print, when:

When create (add) a new Bank account (Accounts on Action ribbon) and overtype the Receipts and Payments batch names (automatic generated batch names, e.g. Pay 831000ZZZ-BA and Rec 831000ZZZ-BA) on the Bank tab with your own batch names (e.g. ZZZ-Payments and ZZZ-Receipts). Save after overtyping. It produces the following error:

UNPOSTEDPAYMENTS:
Dynamic SQL Error
SQL error code = -204
Table unknown
BAT0T37
At line 1, column 23

The Bank reconciliation report will print, when:

When create (add) a new Bank account (Accounts on Action ribbon) and do not overtype (change) the Receipts and Payments batch names (automatic generated batch names, e.g. Pay 831000ZZZ-BA and Rec 831000ZZZ-BA) on the Bank tab. Save as is.

You may chance (overtype) the Receipts and Payments batch names (automatic generated batch names, e.g. Pay 831000ZZZ-BA and Rec 831000ZZZ-BA) on the Batch setup option (Setup ribbon) with your own batch names (e.g. ZZZ-Payments and ZZZ-Receipts). The Bank reconciliation report will still print.

In some databases, no Bank reconciliation reports can be printed (for example a database with 4 Bank accounts).