I have had success going back to basics and creating my own SQL Server view for this report, then using an external query for the report. So far so good! Although it is frustrating that the built-in tools are so difficult to use.
--- In vantage@yahoogroups.com, "tanya_denison" <tdenison@...> wrote:
>
> I am trying to create a BAQ for a custom AR Invoice report. Actually, I only need to create my own filters for the existing AR Invoice report, but according to what I have read, this is not possible with the RDD type reports. If someone knows this to be wrong, please correct me and point me in the right direction.
>
> For my Invoice BAQ, I need to join with Customer for the Sold To, and again separately for the Ship To (since these may be different accounts).
>
> When I add in Customer, it wants to join with the existing OrderRel table. So I modify that to join to InvcHead, which works fine. Then I add Customer again (aliased) to join with InvcDtl to get the ShipTo. This give me this error in Analyze - Test:
>
> Table: , Level:, Type: , RowID: , Text: Business Query Execution error. Please contact your System Administrator.
> Type:3, Program:lib/sqlConverter.p, Method: sqlQueryPhrase, Table: , Field: , RowID: , Message: Type:3Program:lib/sqlConverter.pMethod:sqlQueryPhraseTable:Field:Rowid:Message:More then one root table detected: Company and Customer. Please check your query for parent-child relation settings and orphan tables.
>
> From what I have read on this forum, multiple versions of the same table in one BAQ was an issue with 9.04 versions of Epicor. We are on 9.05.605. I have tried exporting and importing, does anyone know what might be going on?
>
> Thank you for any assistance!
>
>
> Tanya Denison | IT Manager | NRS, Inc.
> 2009 S. Main Street, Moscow, ID 83843
>
> tdenison@... | www.nrsweb.com
> c: 208.301.0599 | p: 208.883.7834 Ext 277 | f: 208.882.1744
>