I created a UDF for the Journal Transactions screen. It is a selector that pulls from a custom table. The ID of the value from the custom table is supposed to be stored in the UDF.
When you create a new JE, the lookup works great!
After selecting:
So far so good. The problem is that when the RowSelected fires, the value is cleared from the field.
There is one record in the custom table with an ID of 1. If I edit the Batch table and put a 1 in the UDF, and then go to that JE, the screen shows a “1”. It should show “TEST1 - Test 1” which would be what would show if you actually selected something.
When creating a new JE, I selected the TEST1 from the selector. When I go to add a line item to the grid, the RowSelected handler fires. I put a little code in the handler to see if there is a value in that field:
In the RowSelected event for the batch, the itemExt.UsrProjectID is null.
The only thing I have to work from is the Acumatica Training code and there isn’t an example of adding a UDF as a Selector. I’m stuck.
So this is really two issues.
- How do I get the selected value in the Selector to save to the UDF field in the Batch table
- If a UsrProjectID value IS in the Batch record, how do I display it as the value would show if it was selected rather than by it’s ID value (1 in this case).
Any help is greatly appreciated.
Thanks!
Joe
