Article Details
Id:9624
Product:fdPOWER
Type:FIX
Version:5.02.19
Opened:01/02/2012
Closed:02/02/2012
Released:07/08/2012
Job: J008904

Invoicing; opening Invoice may cause a Runtime error 5

A Runtime error 5, "Illegal function call. (SQL Table not defined)" may occur when drilling down to the Invoicing form.

To recreate:

1. Under Tools, Options, User tab may show the "Show large database dropdown lists?" is unchecked.
2. Open an Arrangement with an existing Invoice.
3. Click the "Invoices" button, on the right hand side of the form, to open a list of Invoices for the Arrangement.
4. Drilldown, ie double click, on an Invoice.
5. The Invoicing form starts loading and then the error occurs.

A workaround for this is to check the "Show large database dropdown lists?" under Tools, Options, User tab.