Finance | Project Operations, Human Resources, ...

How to make Sales Line un editable on a button click

(0) Share

Report

Posted on by HARISH MEHRA

113

Hi Experts,

I have created a Enum-'NOYes' field in SalesLine.
Now I want If this field is set to Yes, the user will be unable to add, modify or remove the sales order lines.
Can anyone help how can I achieve this through X++.

I have the same question (0)

All responses (26)

Answers (0)

Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

Hi Harish,

You can set the condition on the active method of the SalesLine datasource.

Set the datasource allow edit property to No.

Thanks,

Girish S.

Was this reply helpful? Yes No
HARISH MEHRA 113 on at

Like (0)

Report
Hi Girish,

How to write the logic . I have written the code like this -

[ExtensionOf(formControlStr(SalesTable, SalesLine_PickingInProgress_CAP))] internal final class SalesLine_PickingInProgress_CAP_Extension { public void OnModified() { FormControl formButtonControl = any2Object(this) as FormControl; FormDataSource formDatasource = formButtonControl.formRun().dataSource(tableStr(SalesTable)); SalesTable salesTable = formDatasource.cursor(); SalesLine salesLine; while select SalesLine where salesLine.SalesId == SalesTable.SalesId { if (salesLine.PickingInProgress_CAP == NoYes::Yes) { //formDatasource.object(FormTabPageControl, LineViewLines).allowEdit(false); formDatasource.object(fieldNum(SalesLine, ItemId)).allowEdit(false); formDatasource.object(fieldNum(SalesLine, SalesQty)).allowEdit(false); formDatasource.object(fieldNum(SalesLine, QtyOrdered)).allowEdit(false); formDatasource.object(fieldNum(SalesLine, SalesPrice)).allowEdit(false); } } } }

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report

You need to add code in active method of SalesLine datasource. And Instead of checking all sales order lines, active method should check the NoYes field value and make the fields editable or non editable. Also, you mentione din the question that user should not be allowed to create, delete or edit the record, what if this field is Yes in one sales order line but No in another, what is the expectation in that case.

Was this reply helpful? Yes No
HARISH MEHRA 113 on at

Like (0)

Report

Hi Mohit,

My requirement is -

If this field is set to Yes, the user will be unable to add, modify or remove the sales order lines. Users will continue to be able to edit the sales order header and perform other functions such as generating picking lists, warehouse work, etc. But will be unable to make changes to values on the sales order line .

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

For unable to add, modify or remove requirement, is it based on YesNo value found in any of sales order line or all sales order lines.

Instead of allowEdit on field level, you should use SalesLine datasource allowCreate, allowEdit and allowDelete properties.

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

Yes setting datasource.allowedit(false) and allow Delete(flase) at active method will meet your scenario you are expecting.

Thanks,

Girish S.

Was this reply helpful? Yes No
HARISH MEHRA 113 on at

Like (0)

Report

It should be YesNo value found on particular Sales line.

Can you suggest a demo code.

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (1)

Report

You can refer the below link for sample for how to write active method COC.

dynamics365musings.com/.../

Thanks,

Girish S.

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Your requirement is still not clear. Do you want that when user clicks button, all sales order lines where enum field value is Yes should become non editable and cannot be deleted. Sales lines where enum value is No will remain editable and can be deleted. And I don't understood requirement for denying record creation. Please explain in detail so we can provide you a solution.

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

In the active method, you can call,

Ds.allowedit(false);

Ds allowdelete(false);

Based on condition.

Was this reply helpful? Yes No