Is this a bug?? Insert data in another company - the change log settings from the source company ???

edoderoo

We have a company that gets a refresh of all customers, suppliers, items and a few other base files. Therefor we do not need to track any changes in the change log in the destination company, and they *are* switched off in the change log settings. Nevertheless we get a full set of log-entries, and I get the feeling this is due to the settings in the source company, where we do want to track changes. NAV is looking at the wrong settings when

Is this a known bug in NAV2017 when using Record.CHANGECOMPANY()?

A work-around might be to start the daily copy codeunit from the destination company, and use Record.CHANGECOMPANY('source company') to retrieve the records, but for now I'm just amazed that this is necessary.

Jan_Veenendaal

When using CHANGECOMPANY on a record variable, only that instance of the table is referring to the new company. ALL code (including VALIDATE and INSERT/MODIFY/DELETE/RENAME triggers in the record that was changed!!!) is executed in the 'old' company, and all records that are read/modified through the code are also read from the Original company.

So, for instance, if you do an INSERT into a table that is changed to a different company, and the code in the INSERT trigger tries to find the last available record in order to set a new entry. no. , the insert code reads the last available record in the current company, NOT in the 'changed' company !

Jan_Veenendaal

When using CHANGECOMPANY on a record variable, only that instance of the table is referring to the new company. ALL code (including VALIDATE and INSERT/MODIFY/DELETE/RENAME triggers in the record that was changed!!!) is executed in the 'old' company, and all records that are read/modified through the code are also read from the Original company.

So, for instance, if you do an INSERT into a table that is changed to a different company, and the code in the INSERT trigger tries to find the last available record in order to set a new entry. no. , the insert code reads the last available record in the current company, NOT in the 'changed' company !