Add new field Real Type at SalesLine Table

(0) Share

Report

Posted on by benjamin84

2,075

Dear All,

i have some question for adding new field at some table.

Previously i had add string type to table salesline, once added to salesline form and i edit sales line, this field typeable.

later, when i add real type to table salesline, once added to salesline form and i edit sales line, this field is not typeable, i had try several real field using extendedtype same as unitprice/qty field, but those added new field still not typeable.

Please help to inform , is there any location/class where i can write some code to make this field typeable.

Please help.

Any advice would be nice.

Thank you.

I have the same question (0)

All responses (15)

Answers (1)

Suggested answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

Fields are editable by default; no special code should be needed. If other fields of the same record were editable, I could mean that you inadvertently set field property AllowEdit or Enabled to No.

Nevertheless the SalesLine data source in SalesLine form is set with Allow Edit = No, therefore no fields can be edited there.

Was this reply helpful? Yes No
benjamin84 2,075 on at

Like (0)

Report

Hi Martin,

i had check property setting and its already setted to Yes, as attached,

and i check SalesLine data source in SalesLine form is set with Allow Edit = No, but the origin field for unit price, qty, uom is enable, its only new field with type real that not typeable, my new field for string type is typeable.

Please advice.

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

If a data source is disabled, enabling individual fields make no difference.

Was this reply helpful? Yes No
Suggested answer

ergun sahin 8,826 Moderator on at

Like (0)

Report

Several possibilities come to mind. First of all, may you have opened the new string field to edit in the code? (If you are not the one who opened the field, you can check the autoDeclaration. If it is "No" search with fieldName in the from codes)

Second, there may be a syncronization problem. Does it change when you press F5?

You may have turned it off to edit in the form datasource or table.(check allowEdit and allowEditOnCreate properties)

Finally, when you open the table directly, can you change the related field?

Was this reply helpful? Yes No
benjamin84 2,075 on at

Like (0)

Report

Hi Martin,

already change and sett property for allow to Yes.

After that, already logout and login again, clear reset usage data for all ( form, parameter, etc ) but still same. its not typeable.

but my new field with string type typeable.

thanks

Was this reply helpful? Yes No
benjamin84 2,075 on at

Like (0)

Report

Hi Ergun,

i never do edit in the code, i usually only add new field and personalize at form to shown it.

only me do the customization, no one else understand X++ in my office.

i had compile, sinchronize and increment CIL too.

never change at table or form datasource,

my practice is create new field and i can use those field directly.

if i open at table, i can it directly.

the strange thing is : if i create string type, its typeable, but if i create real/int its not typeable when i edit data at salesline form.

thank you

Was this reply helpful? Yes No
ergun sahin 8,826 Moderator on at

Like (0)

Report

Did you add a new field or duplicate an existing field

Was this reply helpful? Yes No
benjamin84 2,075 on at

Like (0)

Report

Hi Ergun,

had tried both, duplicated from qtyordered and from unitprice ( since they typeable at salesline ), but still same, the created file is not typeable.

thank you

Was this reply helpful? Yes No
ergun sahin 8,826 Moderator on at

Like (0)

Report

Can you create new form and try change values (at least we can understand that are we have table (sql) problem or problem come from form)

Was this reply helpful? Yes No
benjamin84 2,075 on at

Like (0)

Report

HI Ergun,

had tried create new form, drag table salesline to datasource ( no touch anything at property )

compile, increment cil, then open my form and its typeable.

strange why its not typeable at form salesline grid.

is there any other location i could check ?

Thank you

Was this reply helpful? Yes No