Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Get Item Name on SalesQuickQuot

Posted on by 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

 

  • 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.

    SalesQuoteCreateLines_5F00_SearchName_5F00_Filteration.png

  • Vikas Mehta 21 Profile Picture
    Vikas Mehta 21 1,159 on at
    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 Profile Picture
    Divya Lakshmi 745 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Vikas Mehta 21 1,159 on at
    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  Profile Picture
    Azam 385 on at
    RE: Get Item Name on SalesQuickQuot

    Thanks Very much

  • Verified answer
    Divya Lakshmi Profile Picture
    Divya Lakshmi 745 on at
    RE: Get Item Name on SalesQuickQuot

    Hi,

    Try this out!

    ItemName-code.PNG

    ItemName-code.PNGDesignLevel.PNG

    Verify if it works....

    Regards,

    Divya Lakshmi.J

  • Azam  Profile Picture
    Azam 385 on at
    RE: Get Item Name on SalesQuickQuot

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

  • Suggested answer
    Divya Lakshmi Profile Picture
    Divya Lakshmi 745 on at
    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

  • sohaibcheema Profile Picture
    sohaibcheema 46,594 User Group Leader on at
    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";

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,263 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,112 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans