8
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 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
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.
thanks
Thanks
Hi Astrid,
you can use inventDim directly, the relation as below:
select top 10 d.INVENTSERIALID
from SalesLine as sl
inner join InventDim as d
on sl.INVENTDIMID = d.INVENTDIMID
where isnull(d.INVENTSERIALID,'') != ''
or you can add a virtual field on entity. ref below doc:
Hi Astrid,
You don't need the InventTrans. There is also a field InventDimId on the SalesLine table.
#1
André Arnaud de Cal...
291,735
Super User 2024 Season 2
#2
Martin Dráb
230,466
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
