EFx for inventory transfer with serial numbers

[JasonMcD (Jason McDermott)]

Sorry for dragging this on, and I do appreciate the help. But I’m still not getting through this wall.

It won’t compile that way, either - and I tried with and without an “s” and the end of Number(s)

[Joseph_Martin]

You should have no issues with the Fill Table widget, I have done it this way on a few different serial number selection customizations. I have a feeling that your Fill Table query is returning 0 rows so not filling any new row in the ds.
Try making your query on the SerialNo table with your serial / part as table criteria. Then see if there is something in the insert.

[josecgomez]

Try

Erp.Tablesets.SelectedSerialNumbersRow

[JasonMcD (Jason McDermott)]

I need to be able to mark at least two of these as the solution!

@josecgomez

try using the Fill Table Widget to fill in the SelectedSerialNumber subtable with the data you need right before the commit.

This was, of course, right all along, but I was struggling with this

@Joseph_Martin

Try making your query on the SerialNo table with your serial / part as table criteria. Then see if there is something in the insert.

And that did it. (I used the SerialNo tableset; I think that’s what you meant, as you can’t access DB tables in the fill query designer.)

Well, that and I removed that GetSelectSerialNumbersParams method. I don’t know why, but it was stopping me, too.

You all are AWESOME!