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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

EcoresproductTranslation And InventTable

(0) ShareShare
ReportReport
Posted on by 130

Hi all,

I want to relate EcoresproductTranslation with InventTable.

I want tonget description fror every Item in Invent Table.

I have created a field Description with EDT : Ecoresdescription and relate the two tables together.

I ddint get any data. How can I solve it please.

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: EcoresproductTranslation And InventTable

    Hi GAE,

    Are you working with AX2012 or D365FO?

    Best regards,

    Ludwig

  • Martin Dráb Profile Picture
    236,822 Most Valuable Professional on at
    RE: EcoresproductTranslation And InventTable

    It's trivial:  EcoResProductTranslation.Product == InventTable.Product. Then you need to filter by language.

    Nevertheless if you need it in X++, can't you simply use existing methods, instead of implementing it by yourself?

  • GAE Profile Picture
    130 on at
    RE: EcoresproductTranslation And InventTable

    Hello

    How I can filtered by language?

  • GAE Profile Picture
    130 on at
    RE: EcoresproductTranslation And InventTable

    Hello

    Woth D365 FO

  • GAE Profile Picture
    130 on at
    RE: EcoresproductTranslation And InventTable

    Which method I can use and I want to put it into a lookup

  • Suggested answer
    Martin Dráb Profile Picture
    236,822 Most Valuable Professional on at
    RE: EcoresproductTranslation And InventTable

    Moved to Dynamics 365 Finance Forum.

    Regarding how to filter by language, do you mean that you don't know how to write select statements at all, or what kind of problem do you have?

    I'm not sure about the method name off the top of my head. But you can easily answer it by yourself. Open InventTable in the designer and display methods containing "name". You'll find something like name(), itemName() or productName(). Alternatively go to EcoResProductTranslation, right-click Name field, click Find References and check out which method use it.

  • Suggested answer
    Martin Dráb Profile Picture
    236,822 Most Valuable Professional on at
    RE: EcoresproductTranslation And InventTable

    InventTable.defaultProductName() seems to be what you asked for. You'll event find it used in many lookup methods, such as InventTable::lookupItemIdHasReleasedVariants().

    Nevertheless check out itemName() as well, you may find it useful (depending on your actual business requirements).

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 765 Super User 2025 Season 2

#2
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 743

#3
Sumit Singh Profile Picture

Sumit Singh 551

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans