AX 2012 error: "1:N Fetch Mode is not allowed on Datasource having join condition with node other than its immediate parent." when do transaction concern to few items.

Dynamics 365 for Finance and Operations/AX Technical Forum
1

After upgrade to AX 2012 R2 CU 7, i got this error: “1:N Fetch Mode is not allowed on Datasource having join condition with node other than its immediate parent” when do transaction concern to few items - only items have transaction before i upgraded.

4721.3.jpg
4721.3.jpg969×496 72.2 KB

We already active batch number for these items, and allow null but when we left batch num blank the error appear and cannot post any transaction concern.

1348.1.jpg

7827.2.jpg
7827.2.jpg822×136 29.9 KB

The new items don’t got this error although they have same dimension group.

2

If you haven’t modified the query or anything related, I suggest reporting the problem to Microsoft.

3

We do face the same problem, we have case-logged to Microsoft.

4

Did they give you any solution?

5

Hi Venkatesh,

Did you solve it?

6

Hi Bao,

Not yet, i am waiting for hot fix from Microsoft…i will share the hot-fix link here as soon as i receive.

7

Thanks Venkatesh

8

Hi Venkatesh,

We are getting the same error.

Have you got the hotfix?

Regards,

Faisal Raja J

9

Use this hot fix: KB Article Number(s): 2922779

Bao Huynh

10

Hello Bao Huynh,

Could you please help to send me the link to download KB Article Number(s): 2922779.

I didn’t found this hot fix in the partner source:

https://mbs.microsoft.com/partnersource/northamerica/deployment/downloads/hot-fixes/AX2012hotfixes

Thank you.

11

Login to the life cycle services, https://lcs.dynamics.com

Use issue search to find the hot-fix.