Ernst wrote:Just wondering why JIWA made it non modifiable in first place?
We don't let you modify the identifier type fields anywhere once the record is saved. Debtor Account No, Sales Order No, Creditor Account No - they all behave the same and do not allow edit of that field once created.
For fraud prevention reasons you shouldn't be able to modify a Sales Order (Invoice) No.
An inventory items Part No. is also not supposed to be changed, as existing documents - including ones like sales orders, you've sent to the customer and changing the inventory Part No. invalidates that document. So we don't let you do that.
Another underlying reason is because it's often used by people and external systems as a pseudo primary key - an external CRM system might use the ProspectNo from contacts as the primary key instead of the ProspectID (which is not visible to the user) for associating a record in the CRM with a prospect in Jiwa.
It's not recommended to do that, but people do.
Ernst wrote:But is there any risk to rest of JIWA if we do this?
Maybe. Only way for me to know is go through the code, to look for references to the ProspectNo field / column and try to work it if there is an obvious issue - and even then I'd want to actually do a bunch of tests to see for sure.
That's more effort I personally am willing to do... so the official recommendation is to not change fields the software is preventing you from changing.