Cross Company BAQ not working

Hi All,

E9.05.702A

My user account does have the option to allow the creation of cross company BAQs and the account has access to both companies in question.

I am trying to create a query that lists our customers, across both companies, and show the last invoice date.
I linked Customer to InvcHead by Company and CustNum. I made InvcHead a summary table and then added a calculated field to get the maximum invoice date.

If the BAQ is checked as cross company AND the table join is an inner join, no results are returned.
If the BAQ is checked as cross company AND the table join is an outer join, all customers in both companies are returned but the calculated fields is always blank.

If I clear the cross company field on the BAQ I get the expected results both when the join is an inner and outer join.

Anyone know if this is a known bug or just a limitation of cross company BAQs?

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL + DESIGN & DEVELOPMENT
Advancing Your Innovations For Health

261 Cedar Hill Street | Marlborough, MA 01752
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245
EMAIL: JoRojas@ventionmedical.commailto:JoRojas@ventionmedical.com | WEB: ventionmedical.com http://www.ventionmedical.com/

THINK QUALITY. BE QUALITY. GO BEYOND.

This communication may contain information that is confidential, proprietary or exempt from disclosure, and is intended only for the use of the individual and/or entity it is addressed to. If you are not the intended recipient, please note that any other dissemination, distribution, use or copying of this communication is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone or by return e-mail, and delete this information from your computer.

Hi All,

I found this in AnswerBooks:
124711 - Cross-company BAQ fails to return data when child table is summarized (Fixed in 10.1.200).

I’m going to call support to see if they have a one-off for E9…wish me luck.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL + DESIGN & DEVELOPMENT
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

Just to close the loop. Called support. No one-off for E9 and development will not create one because there is a work around.

JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL + DESIGN & DEVELOPMENT
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245

You can do the latest trick I was shown by a consultant of making the baq updatable and then adding an obscure ud as the updatable field. This allows you to write abl code on the post processing of getlist and do any query or calculation you want and then set the ttresults calculated fields.

Greg

hat trick right there. especially since youre just using the ttUD field but never actually write anything. ill have to remember than next time i run into this issue.