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.