Похоже на то
Щас читаю Release Notes к R3, тут про то же написано похоже:
Цитата:
Invalid information might be displayed in query results
When there are multiple relations between two tables in a Microsoft Dynamics AX database, and you run a query that includes relations that are automatically detected, the query results might contain invalid information. The system might detect relations in a sequence that is different from what is intended in the query.
Queries where relations are automatically detected include the following examples:
1. Auto join in query
2. Queries created by using the sys query form
3. Delete actions where a relation path is not specified
4. Dyna-linked data sources
To work around this issue, open the AOT and rename the relations so that they appear in the desired alphabetic order. For example, if you want a query to return results from the InventTable that are associated with a vendor and not the AlcoholManufacturerer_RU relation for the vendor, change the AlcoholManufacturerer_RU relation name to ZAlcoholManufacturerer_RU.