Moin: In Sales & Receivables Setup|General|Credit Warnings our desired configuration is “Both Warnings”. During the last months we experienced that several times this value was changed to “No Warnings” without any clues to the author. I disabled editing of the Credit Warnings field in the Sales & Receivables Setup form and activated the change log for table 311. Today the modification to “No warnings” has been done again. Looking to the change log I find only one entry for table 311 - my own modification from “No Warnings” to “Both Warnings”. No hint how the reset to “No Warnings” was done. Does anyone outside knows the phenomena? Any ideas how to prevent these unwanted modification? Regards Alarich
Hi, The only possibility that occurs to me is if the Sales & Receivables Setup table has been made common to all companies. That way someone else might be running the table from the Object Designer changing the field and the Change Log might not pick it up…
Edward:
quote:
The only possibility that occurs to me is if the Sales & Receivables Setup table has been made common to all companies.
Originally posted by EBloom - 2005 Jan 27 : 10:37:41
The property “DataPerCompany” is set to yes, the default value. Regards Alarich BTW: In 311 “Sales & Receivable Setup” I have set the the field “Credit Warnings” to not editable. We’ll see what happens
The value can also be changed by a program (most probably by some custom code)
You can find that out by running a where used report on the field in the developer toolkit, or if you don’t have the proper license have your solution center do that for you.
Did you set up the Change Log for all companies?
Instead of making the field NotEditable, you should consider giving Modify permission over the Sales & Receivables Setup TableData to a very small number of users (or possibly only yourself) across all companies in the database.
That’s a good idea Nelson. And rememeber that all users with SUPER(DATA) permission can modify the tables from Object Designer.
quote:
And rememeber that all users with SUPER(DATA) permission can modify the tables from Object Designer.
Originally posted by jsrark - 2005 Jan 27 : 15:57:45
… and that would be recorded in the change log. Alarich, are you using drop shipment? I remember one version where the drop shipment function modified the credit warning field (disabled it, run the function, enabled it). Which version (application) are you using?
Moin, everybody: @Nelson: I am the only one (except our CEO) who has permission to modify the Sales & Receivables Setup TableData. I disabled the editable property in the Sales & Receivables Setup TableData as an additional security. I don’t think that one of our users does this modification. In this case I had a record in the change log. @Walter: We are using NAVISION 3.6. And: yes, sometimes we are using drop shipment. I will have an eye on the next appropriate order if this is the cause. Thank you all. Regards Alarich