Update on CompanyInfo table

(0) Share

Report

Posted on by Sangram Shinde

2,114

Hi Techies,

We are facing strange issue need some inputs.

One custom field is created on CompanyInfo table and we are trying to update it by code.

Here, it doesn't throw any error but field doesn't update as well.

companyInfoUpdate.skipDataMethods(true);

update_recordset companyInfoUpdate
setting customField = _installedProdVersion
where companyInfoUpdate.customField != _installedProdVersion &&
_installedProdVersion;

Where as, we have tried above code without where clause, but getting error like 'Cannot edit a record in Legal entities (CompanyInfo). Data update is not allowed on field that has not been selected.

Do we need to update in any other table as well.

Can anyone help giving some inputs here that how we can update the CompanyInfo table here please.

Any response is appreciated!

Thank you in advance!

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

André Arnaud de Cal... 301,014 Super User 2025 Season 2 on at

Like (0)

Report
Hi Sangram,

Have you used the debugger to check if the _installedProdVersion variable has an actual value?

You can try to set the update_recordset statement in an 'if-clause' where you first evaluate if there is an value provided.

E.g.:

ttsbegin; companyInfoUpdate.skipDataMethods(true); if (_installedProdVersion) { update_recordset companyInfoUpdate setting customField = _installedProdVersion where companyInfoUpdate.customField != _installedProdVersion; } ttscommit;

Was this reply helpful? Yes No
Sangram Shinde 2,114 on at

Like (0)

Report

Thank you for reply Andre, yes the _installedProdVersion has the value, we've checked that in debugger.

While adding new field in CompanyInfo also, it was showing error on DirPartyTable that field doesn't exist. Then we've added same custom field in DirPartyTable from SQL with same characters and that error got resolved.

Hence I am wondering if we need to update any other table as well.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,014 Super User 2025 Season 2 on at

Like (1)

Report

Hi Sangram,

Manually adding a field in the SQL database is not recommended. The Database synchronization should take care of that job. There is an SQLDictionary table (and probably some others) which are used to translate the x++ queries to SQL queries. This table is not updated when you manually add fields in the SQL database. I would suggest to run a full database synchronization job.

Was this reply helpful? Yes No
Sangram Shinde 2,114 on at

Like (0)

Report

We were facing sync issue after adding field in companyInfo saying it's not available in DirPartyTable, means the SQLDictionary table which you are referring wasn't updating SQL query it seems.

For now we've used an alternate way.

Yeah we would try with full db synch once.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Update on CompanyInfo table

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Update on CompanyInfo table

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates