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

Notifications

Announcements

No record found.

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

    Hi GAE,

    Are you working with AX2012 or D365FO?

    Best regards,

    Ludwig

  • Martin Dráb Profile Picture
    237,829 Most Valuable Professional on at

    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

    Hello

    How I can filtered by language?

  • GAE Profile Picture
    130 on at

    Hello

    Woth D365 FO

  • GAE Profile Picture
    130 on at

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

  • Suggested answer
    Martin Dráb Profile Picture
    237,829 Most Valuable Professional on at

    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
    237,829 Most Valuable Professional on at

    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…

Neeraj Kumar – Community Spotlight

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

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

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 291 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans