Hello,
I need to add a new field to my extension on the ReturnOrderLine entity.
I need to add the serial number. The problem is that I need to create a connection between salesline and InventTrans and then one between InventTrans and InventDim.
I am not sure how to create the joints between the tables so I will get the serial numbers on ReturnOrderLine
thanks
astrid
Hi Astrid,
You don't need the InventTrans. There is also a field InventDimId on the SalesLine table.
you can use inventDim directly, the relation as below:
select top 10 d.INVENTSERIALIDfrom SalesLine as slinner join InventDim as don sl.INVENTDIMID = d.INVENTDIMIDwhere isnull(d.INVENTSERIALID,'') != ''
or you can add a virtual field on entity. ref below doc:
https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/data-entity-computed-columns-virtual-fields
Thanks
I am pretty new to this, so your suggestion is to add a new computed field and use that sql code on the field? i am not sure what you mean by use inventDim directly.
Hi AstridMalanka,
ReturnOrderLine entity already contains InventDim data source. You just need
1. Drop serial number field from InventDim data source to "Fields" node
2. Add the field with the same name to ReturnOrderLineStaging table with EDT InventSerialId.
3. Build and sync project
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 650 Super User 2025 Season 2
Martin Dráb 582 Most Valuable Professional
CU05031448-0 526
