web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / display product name f...
Microsoft Dynamics AX (Archived)

display product name from "EcoResProductTranslation" table on release approved purchase requisition form

(0) ShareShare
ReportReport
Posted on by venkates 240

Hi All,

Is it possible to display the product name from "EcoResProductTranslation" table on Procurement and sourcing->common->purchase requisitions->release approved purchase requisition. If yes, can you tell me the ways to achieve it.

I need to do this to make the product name filterable when pressing Ctrl+G.

Thanks.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Use the EcoResProductTranslations view, which can be joined to InventTable or EcoResProduct, whichever is available for your form. That way the product name becomes filterable.

  • venkates Profile Picture
    venkates 240 on at

    Hi Vilmos,

    I'm trying to modify the query "PurchReqCreatePurch", how should i add the tables inventsum,inventtable,ecoresproduct and ecoresproducttranslation. If i try adding the inventsum or inventtable im getting error as below

    Cannot select a record in "ViewName".

    The SQL database has issued an error.

    Can you please tell me how to modify the query.

    Thanks.

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    How about adding InventTable as a datasource for PurchReqLine with 1:1 InnerJoin, Relations = True, Dynamic fields = No. Then adding EcoResProductTranslations for InventTable with 1:1 InnerJoin, Relations = False, manual relation between InventTable.Product and EcoResProductTranslations.Product, Dynamics fields = No and adding ProductName in the field list? The query can compile without any errors, however I have no means of testing this.

  • venkates Profile Picture
    venkates 240 on at

    Hi Vilmos,

    I have added the query after making the modification to the view and when trying to add the field name to the view's field i'm unable to select the field name.

    I guess it is due to the dynamics property of the ecoresproducttranslation set to no. Is there any other way to add the name field.

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    I do not understand what you are saying regarding changing a view, I have not recommended to do any changes on it. What I said is you could join that view on your formdatasource, query, code, whatsoever to use the data in there.

  • venkates Profile Picture
    venkates 240 on at

    For testing purpose I've created a view and added the query "Purchreqcreatepurch" and added the inventtable as ds to purchreqline. Can't I get result using my approach?

  • venkates Profile Picture
    venkates 240 on at

    I'll stop testing with my view and do the modification to the query as you suggested. i.e adding inventtable and ecoresproducttranslation view and ill give a try

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans