Error mvf_STAXInvoice - Sales Tax Query | CLEARIFY

Subquery cannot return more than one row "mvf_STAXInvoice"

You see an error in the log similar to this:

Cause

This error message is one of the few that comes directly from the QQube Database and indicates that there is a problem with the underlying Sales Tax Data in QuickBooks

The Intuit Software Development Kit (SDK) gives developers no direct or easy access to extract individual sales Tax Items (within Sales Tax Groups) from a given sales transaction, and QQube depends upon certain data entry anomalies to make this work.  If they are absent, then we are unable to extract this analytic.

We are hopeful that Intuit will eventually fix this for developers, but given their penchant for NOT fixing issues with the SDK, we are not that hopeful.

Resolution

Since one analytic is not dependent upon another, it is not necessary to load this, and you can successfully remove it from the QQube database as follows:

The key is to remove it from the main analytic area, so that it does not show in the manual refresh area.  Just unchecking this from the manual refresh area, will not work.