Relation between Sales Table and EcoresproductTranslation Tables

Finance and Operations/AX Developer Forum
1

Hi ,

I am working on Ax 2012 R2

I have requirement that when we create new sales order -->Add Line -->product and Supply -->Configure Line

pastedimage1521144281899v2.png
pastedimage1521144281899v2.png929×446 29.2 KB

After clicking on configure line below form will open

pastedimage1521144244541v1.png
pastedimage1521144244541v1.png756×354 3.86 KB

After selecting the values in the above form if we click on ok it will create product variant for that particular item

Released products -->open the item which is mentioned sales line -->Product Variants as below

pastedimage1521144562226v3.png
pastedimage1521144562226v3.png735×403 16 KB

Now what I have to do is the description that is displaying in the just above variants form I need to update it in sales line textbox(salesline.name)

pastedimage1521144663867v4.png
pastedimage1521144663867v4.png785×572 30.7 KB

I need to this after clicking on Ok button of the configure line form.

Kindly assist if anybody knows …I could not find any relation between please help.

Thanks In advance

2

There is no relation between salesTable and EcoResProductTranslation. To get the EcoResProductTranslation you need to have the product and the language id. SalesTable has the language id field and SalesLine has the item Id( field (from itemId you can get the product).
To know how the name is set on salesLine, have a look at \Data Dictionary\Tables\SalesLine\Methods\initName.