palleagermark: It is possible for users to edit the Item reference fields of sales order lines and purchase order lines.

[Blog bot]

Источник: http://palleagermark.blogspot.com/20...edit-item.html
==============


It is possible for users to edit the Item reference fields of sales order lines and purchase order lines of a user adds these fields to the forms.
Hopefully no adventurous end users read this post J

Repro:
Open Sales Order Details
Go to Lines / Other
Select one the Item reference fields
Note that you cannot change the values
Right click in the form and select Setup
Select the Line / TabLine/Lines/SalesLineGrid node
Click Add fields
Expand Order lines
Select for example the Reference number (InventRefId) field
Close the selection form
Close the User setup form
Observe that the Reference number field is now added to the grid, and you can edit it.

Obviously if you tamper with the references of the lines, you will destroy the integrity between the references entities, links are broken, and subsequent actions will not perform as expected.

You should lock these fields on datasource field level by setting the AllowEdit property to No. Maybe you should even consider setting the AllowEdit property to No on the table level. I'm not sure if the later suggestion causes any problems elsewhere in the application, but I can't imagine a place where you'd want users to edit these fields manually.

Here are the fields where you should set AllowEdit=No if you want a fix at table level:
AOT > Tables
SalesLine > Fields >
InventRefTransId
InventRefType
InventRefId

PurchLine > Fields >
InventRefTransId
InventRefType
InventRefId


Источник: http://palleagermark.blogspot.com/20...edit-item.html