Hey there Daisy,
Hope this finds you well. I’m not on Kinetics so take everything I say with a grain of salt.
Since these fields aren’t available on the OrderOpen Dataset, you’ll need to add them to the grid. Here’s an example which helped me with a similar problem a while back:
You can try using this thread to add the needed fields to the datagrid when the form loads.
That’s only half the battle. We need to actually populate these fields with data, and since they aren’t on the Dataset, you’ll need to add them.
Add an EpiUltraGrid InitializeRow event to the OrdersOpen grid. Since it’s not a custom control you can’t do this through the wizard, but you can use the wizard as a guide and grab the native control using the csm.GetNativeControlReference(“EpiGuidHere”) method.
Then in the InitializeRow method, you can call GetList or another method to pull in the sales order information for each row and populate the added fields ShortChar02 and DocExtPriceDtl.
WARNING
This will slow down customer tracker when you click the “Retrieve” button. Depending on how many open orders exist for the customer, the performance hit could be significant.
Let me know if this makes sense or if I need to clarify anything.