Sage 300

Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Optional Field Value. Attempt to modify a different record than was retrieved.

Posted By asthy over 8 years ago

I'm facing this error message when i click on the value for one of the optional field in common services > Optional fields.

Description: Optional Field Value. Attempt to modify a different record than was retrieved.

Kindly advice what to do. Thanks.

0 Ettienne Schwagele over 8 years ago

Close the screen and try again.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 asthy over 8 years ago in reply to Ettienne Schwagele

Tried, error still prompted. Ran data integrity, database dump & load back, error still there.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ettienne Schwagele over 8 years ago in reply to asthy

What are you attempting to do?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 asthy over 8 years ago in reply to Ettienne Schwagele

Insert new value for this optional field.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ettienne Schwagele over 8 years ago in reply to asthy

Check if the same value exists in a different case.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 asthy over 8 years ago in reply to Ettienne Schwagele

Table CSOPTFD carried different values in column VALUE and SORTEDVAL, amend it to same value can solve the issue.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

Optional Field Value. Attempt to modify a different record than was retrieved.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING