Error: Assertion Failed: Select field AP7PURCHASEORDERS has a different base table - when running a query with GST Tax ID

You may receive the following error when running a query when the GST Tax ID field is selected as field criteria or output field. 

Error: Assertion Failed: Select field ‘AP7PURCHASEORDERS AP7PURCHASEORDERSID 1112’ has a different base table encounter

We are currently evaluating this issue and will update this article when we have more information.

Steps to Duplicate

1. Go to Accounts Payable.
2. Go to Query, create a new Dynamic Purchase Order Query.
3. Expand +Line Items - select the field GST Tax ID and output this field.
4. Click on Results tab to run query.
5. Encounter error:
Error: Assertion Failed: Select field ‘AP7PURCHASEORDERS AP7PURCHASEORDERSID 1112’ has a different base table.
Check the queryfields for this CSQLStmt object
Routine:
6. Click OK, encounter another error:
Query too complex.
General ODBC Error: [Microsoft][ODCB SQL Server Driver][SQL Server]The multi-part identifier
"AP7PURCHASEORDERS.AP7PURCHASEORDERSID" could not be bound.
Native error :4104
[Microsoft][ODCB SQL Server Driver][SQL Server]The cursor was not declared.
Native error: 16945

Environment

 Financial Edge
 7.87
 Accounts Payable

Was this article helpful?