UD column in Kinetic grid not editable

Kinetic ERP
1

Hello everyone !

I’M sorry if the question has already been asked, but here I go.

I created a UD field name UD_MetalSheetNumber_c in the SugPODtl table. its value is set by a data directive, as it is a calculation on the RelQty field.

It correctly is added in the dataview in application studio and correctly displays in the new suggestions grid in the PO suggestions screen.
image

My problem is, this column is read only, and I want the user to be able to change that field, which would in turn change the RelQty with the data directive.

Any idea why is that ? I simply added a column like this in the application studio
image

Thanks in advance !

2

My best guess is this:

image
image1697×591 35.4 KB

There is a row rule that is disabling rows, EXCEPT certain columns. Unless your UD column is added to that list, it may be disabled by default. To test this theory, I’m assuming you’ll need to create a new data rule by copying this base rule and adding your UD column to the exception list.

Not sure if it will override the base rule by default when you copy them? I’ve never done that step.

4 Likes
3

A lot of things that you would expect to happen automatically actually need to be configured manually in Kinetic …

There is a checkbox for Editable way at the bottom of the details for that column - see if that does the trick for you
image

1 Like
4

I was thinking that too, except the base grid is not marked editable… and none of the columns which you CAN change (Buyer, VendorID, etc.) are marked as editable either.

Can’t say I understand why anything in that grid is editable if the grid itself is not checked as editable. But, just add it to the list of things I don’t understand about App Studio settings! :rofl:

But, that’s why I started combing through the row rules to see if they were disabling columns there. But… can’t say for sure.

1 Like
5

Thanks both you !

@jwphillips I actived that checkbox and it didn’t change anything

@dcamlin I see that this rules seems to be the key I will try to fidget around and find how to overrule this thanks !

2 Likes
6

I did a few tests but I couldnt do it. Copying the data rule works on other fields (I can disable RelQty for example) but didn’t suffice.

Is there any other place to set the UD field as updatable ? extended properties or else ?

1 Like
7

Some more testing showed that binding the field in a numericbox in the detail slider works perfectly well,

image
image1022×480 27 KB

but not in a numeric box in the same grid

image
image1244×355 34 KB

Changing the disabled setting with an event after the last one (sugpodtl row changing) didn’t solve it.

Still searching !

8

I found by that forceully setting “Transview.SliderDetails” to true it enables the field…so it really was the rule.

By copying the rule and add the exception for the UD field, ti doesn’t invalidate the previous rule. it ADDS the new one on top of the first, not invalidating the previous one.

Is there a way to invalidate a locked rule ?

1 Like