Personalization, Customization and Productivity Tools

[FunkMoney33]

Does anyone know a better way to automatically skip a column in SO Detail entry?

Currently I'm using a user-defined script to respond to the PostValidate event of the ItemCode field.  The script then uses the SendKeys() method to send an Enter key back to MAS.  That way, effectively, we skip the ItemDescription field (which is positioned on the main grid) and go right to the QuantityOrdered field. 

The only problems with this approach are:

1.  Users can re-arrange the columns in the Grid, so the script would need to be rewritten each time someone does this.

2.  If the user selects an ItemCode using the lookup button, as opposed to just typing the item code directly in the cell, the script is never fired (presumably because the lookup bypasses Validation).

So I'm looking for a better approach. 

Thanks.

[connex]

I think hiding columns is about all you can do.

[FunkMoney33]

Yeah, hiding is not an option.  they want to see the column, and have the ability to go back and edit it if they need to, but ordinarily they just want to skip it.

Anyone else?

Aaron