By using this website, you agree to our Terms of Use (click here)
Does anyone know where this error comes from?
Adding this Data Field to the generic inquiry will affect the system performance. To avoid unnecessary queries, join with the related table. The generated query for this field is
(SELECT [BAccountRExt].[AcctName] FROM [BAccount] [BAccountRExt] WHERE [BAccountRExt].[bAccountID] = [APInvoice].[VendorID])
It seems to give me the correct data in my Generic Inquiry, but I'm concerned about the error.
Hi Scooter,
When you see that warning, you don't need to worry about it unless things are running too slow for you.
All the warning is telling you is that the query isn't as efficient as it could be so it could run a little slow.
But if you aren't noticing any performance problems, I wouldn't worry about it.
In case you're interested, you could fix your query by adding the BAccount DAC table. Then join APInvoice and BAccount together like this:
APInvoice.VendorID -> BAccount.BAccountID
Then you can change APInvoice.vendorID_description to BAccount.AccountName on the Results Grid tab. It will grab the same data, but more efficiently, and you won't get the warning message that you were getting.
Ah, I see. Sounds like a pretty harmless warning message, especially for me since it isn't running very slowly.
Online Members