Microsoft Dynamics AX (Archived)

Get Item Name on SalesQuickQuot

(0) Share

Report

Posted on by Azam

385

Dear All

I want to get Item Name on SalesQuickQuot Form,

SalesQuickQuot Form Datasource have inventTable_DS and inventTable2_DS

Name Alias field is exist in inventTable_DS , inventTable2_DS

when I set Name Alias field from inventTable_DS then Search Name show Unretrieved

and when I set Name Alias field from inventTable2_DS then Search Name show wrong searchName

and also I tried All ItemName Method butt Item Name did not show

*This post is locked for comments

All responses (16)

Answers (1)

Azeemuddin Chisty 80 on at

Like (0)

Report

RE: Get Item Name on SalesQuickQuot

May be am answering late but i have the solution for this which may help others.

when we have the InventTable_DS on the form it make no sense adding the display methods. Instead add the InventTable_DS NameAlias to the existing items tab and InventTable2_DS NameAlias to the New items tab.

Now the New items tab will display the Search name of the Items whereas in Existing items it will not. Because the InventTable_DS is being modified outside the form methods. To Overcome this issue we need to add one line of code to Classes/InventDimCtrl_Frm_QuickQuote.modifyQuery() as shown in the screen shot.

This will enable the Search name on the InventTable_DS with filteration.
Vikas Mehta 21 1,159 on at

Like (0)

Report

RE: Get Item Name on SalesQuickQuot

Hi Suresh,

Thanks for the quick response.

Form Name : PurchQuickQuote(AX 2012 R3)

The relations are as per standard tables.

I want to give standard filtering on the forms and not the display method filtering.
Suggested answer

Divya Lakshmi 745 on at

Like (0)

Report

RE: Get Item Name on SalesQuickQuot

Hi Vikas,

Please create this question as a New one in the forum.So that it will be easier for the searchers...

As per my understanding , I think you need to filter the item name (need filter in item name display method).If this is your requirement,Please try to add X++ code to add filter criteria in your display method.Kindly refer link provided to do so...axhelpdesk.blogspot.in/.../how-to-add-filter-functionality-to.html

Regards,

Divya Lakshmi.J

Verify If it works.... :-)
Community Member Microsoft Employee on at

Like (0)

Report

RE: Get Item Name on SalesQuickQuot

Hi Vikas Mehta,

Please check the relations once. please share the screenshots and form name!

axsuresh.blogspot.in/.../get-productmaster-based-on-product.html

Thanks

Suresh
Vikas Mehta 21 1,159 on at

Like (0)

Report

RE: Get Item Name on SalesQuickQuot

Hi All,

I am having a similar requirement wherein I need to display the Product Name of the Item which is coming from the EcoResProductTranslation Table.

However the problem over here is that the displayed field should be filtered but the filteration does not works out in display method.

I have added the tables EcoResProduct,EcoResTranslation with standard relations in the form datasources.

I am getting the below error while opening the form

"Query missing QueryBuildDataSource for FormDataSource EcoResProduct."

Please suggest If anyone has cracked it.
Azam 385 on at

Like (0)

Report

RE: Get Item Name on SalesQuickQuot

Thanks Very much
Verified answer

Divya Lakshmi 745 on at

Like (0)

Report

RE: Get Item Name on SalesQuickQuot

Hi,

Try this out!

Verify if it works....

Regards,

Divya Lakshmi.J
Azam 385 on at

Like (0)

Report

RE: Get Item Name on SalesQuickQuot

I have Tried all inventTable method (ItemName, defaultProductName, name ) but Name did not show
Suggested answer

Divya Lakshmi 745 on at

Like (0)

Report

RE: Get Item Name on SalesQuickQuot

Hi,

Your Display is wrong. You have to pass LanguageId also to retrieve respective Itemname in AX2012...

Pass suitable parameters and use base methods.U can use method from Inventtable.

Regards,

Divya Lakshmi.J
Sohaib Cheema 46,610 User Group Leader on at

Like (0)

Report

RE: Get Item Name on SalesQuickQuot

who asked you to create a new method for displaying itemName?

and see your method? where is LangaugeI...??? AX is multi-language system and EcoResProductTranslation has been designed to accommodate that.

Fix your method or use existing method from InventTable

if you want to do testing of your method just write below line and you will get data

Return "Testing Name";