Updateable UBAQ in a Grid Questions

Kinetic ERP
, , , ,
1

I am trying to setup a grid on the sales order to update UD01 which we are using as a change log. I have a created a UBAQ to update UD01 and have setup the data view and grid as per the instructions in How To: Kinetic - Updateable UBAQ in a Grid. I am able to edit existing rows and have them update successfully. I have a few issues I am trying to resolve.

  • How do you add a new row to the grid?
  • How do you delete a row?
  • I have made the grid model editable and selected columns editable. However, I can edit all columns in the grid, not just those I marked as editable. How do I prevent the user from modifying the other columns? I couldn’t find a column setting to make them read only.
2

Any reason you are not using the built-in change log?

3

The built-in change log did not suit our needs. We do not want to audit the sales order transaction. We are interested in tracking changes to sales lines with change in dollar value and notes related to the change.

4

I have checked my UBAQ, data view and grid. I can find no setting that will allow me to add a new row or delete a row. I have added buttons to the grid via action data, so far I only have save working. Is there a setting somewhere that I am missing?