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
Check the image attached … Data source is :: InventTransALLTransView
It looks like a custom one. Check the query generated in the form data source.
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
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.
see the both form ,. same one only created in menu item and assigning
I mean, how did you added your view in \Forms\InventOnhandItem? (join data source, link types etc)
in grid i mention my view IN DATA SOURCE HERE I ATTACH IMAGE CHECK THIS
Ok, but that doesn’t describe how the view is joined with the other data sources in the form.
I CREATE QUERY FOR AND ADDED IT IN VIEW THEN FROM VIEW INVENTTRANSALLTRANSVIEW ,
ALL THE FIELDS IS USED FRO GLOBAL TRANSACTION TAB IS TAKEN FROM INVENTTREANSALLTRANSVIEW ONLY … ALL R THE DIRECT FIELDS
CHECK THIS DIFFERENCE IN THE FORM IMAGE I ATTACHED HERE … FIRST IMAGE IS OPENING FROM ECORESPRODUCTPERCOMPNAYLISTPAGE …SECOND IMAGE IS ECORESPRODUCTDETAILSEXTENDED FORM
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) .
OK , I WILL SEND U XPO FILE …
The only difference i can see is that the query generated, while opening the intercompany on hand form,
- opened from list page
SELECT FIRSTFAST * FROM InventTransAllTransView(InventTransAllTransView)
- opened from form - itemId is added
SELECT FIRSTFAST * FROM InventTransAllTransView(InventTransAllTransView) WHERE InventTable.ItemId=InventTransAllTransView.ItemId