Hi Team,
Can someone help me on this please.
I have an error as per below. I don’t know which table set to use that contains the UD field I added on Sales Order Detail Screen.
Have you traced a method transaction where you are changing that field?
1 Like
You shouldn’t have to use OrderDtl_UD. You can use:
ds.OrderDtl.Select(r=>r.Weight_c).Sum()
2 Likes
Wonder if this topic might give you an idea?
e.g. something like one of these?
tsSalesOrderOrderRelRow.UDField<System.String>(“xxxxx_c”)
tsSalesOrderOrderDtlRow.UDField<System.String>(“yyyyyy_c”)
1 Like
Nice Doug!
1 Like
Hi @Doug.C . I see an error as UD field not contain on the SalesOrderTableSet on this.
I tried ds.OrderDtl.Select(r=>r.Weight.c).Sum() and it gives another error.
In the last picture, it’s back to dsOrderDtl_UD. I don’t see any Temp-tables listed. What directive are you using?
1 Like
I am using method directive for Sales Order Master Update …
Hi @Doug.C , here is the result. I think the Sales Order table set in the variables does not contain the UD fields. Not really sure what this error is all about… Sorry
Ok, I see what the problem is. Try:
ds.OrderDtl.Select(r=>r.UDField<decimal>("Weight_c")).Sum()
I don’t know if Weight_c is decimal or double. You can replace the type in the <decimal> if Weight_c is double.
2 Likes
Thank you so much!!
Above and beyond Doug, nice!