Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Get Item Name on SalesQuickQuot

(0) ShareShare
ReportReport
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

 

*This post is locked for comments

  • 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

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 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";

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans