Inventonhand form customization values not showing properly

Dynamics 365 for Finance and Operations/AX Developer Forum
1

Hi Every one

InventOnhand form i have one customization . added one tab for "Global Transaction " it will bring all legal entities details against the item id …

then i added this menuitem in ECORESPRODUCTPERCOMPNAYLISTPAGE form and ECORESPRODUCTDETAILSEXTENDED form …

in ecoresproductpercompanylistpage for i can see global values against item id . but in ecoresproductdetailsectended form showing only current company values … how to bring global values in this form too

2

What data source it has?

3

go.jpg
go.jpg1886×938 220 KB

Check the image attached … Data source is :: InventTransALLTransView

4

It looks like a custom one. Check the query generated in the form data source.

5

same menu item is calling in two different forms . ECORESPRODUCTPERCOMPANYLISTPAGE // ECORESPRODUCTDETAILSEXTEND … when i open the my menu item button of the customized form in ECORESPRODUCTPERCOMPANYLISTPAGE all data’s showing correctly with all legal entities … then if i right click any item and view details select means it open ECORESPRODCTDETAILSEXTENDED form here values showing only for current company .,. this is my problem

6

That is understood. But we are not sure how you have used that view in the inventOnhand form.
So asking you to see the query generated on inventOnHand form in both the cases.

7

eco.jpg
eco.jpg1881×921 336 KB

see the both form ,. same one only created in menu item and assigning

8

I mean, how did you added your view in \Forms\InventOnhandItem? (join data source, link types etc)

9

ve.jpg
ve.jpg1898×750 186 KB

in grid i mention my view IN DATA SOURCE HERE I ATTACH IMAGE CHECK THIS

veVIEW.jpg
veVIEW.jpg1906×648 95 KB

10

Ok, but that doesn’t describe how the view is joined with the other data sources in the form.

11

QRY.jpg
QRY.jpg1920×1080 81.3 KB

I CREATE QUERY FOR AND ADDED IT IN VIEW THEN FROM VIEW INVENTTRANSALLTRANSVIEW ,

12

ALL THE FIELDS IS USED FRO GLOBAL TRANSACTION TAB IS TAKEN FROM INVENTTREANSALLTRANSVIEW ONLY … ALL R THE DIRECT FIELDS

13

CHECK THIS DIFFERENCE IN THE FORM IMAGE I ATTACHED HERE … FIRST IMAGE IS OPENING FROM ECORESPRODUCTPERCOMPNAYLISTPAGE …SECOND IMAGE IS ECORESPRODUCTDETAILSEXTENDED FORM

6215.FIRST.jpg
6215.FIRST.jpg1899×845 402 KB

SEC.jpg
SEC.jpg1920×1080 370 KB

14

That may not help to actually identify the issue in your case.
Either investigate the query generated during the run time(that is causing the a different behavior when the same form is called from different places) (or) explain the total changes in brief (or) create a project and attach here (that can probably run in any environment) .

15

OK , I WILL SEND U XPO FILE …

16

17th july.zip (56 KB)

17

The only difference i can see is that the query generated, while opening the intercompany on hand form,

  1. opened from list page

SELECT FIRSTFAST * FROM InventTransAllTransView(InventTransAllTransView)

  1. opened from form - itemId is added

SELECT FIRSTFAST * FROM InventTransAllTransView(InventTransAllTransView) WHERE InventTable.ItemId=InventTransAllTransView.ItemId