Hello, i have a custom table named /CX Timesheet/. and this table has fields /Project/ and /Project Task/ related Job and Job Task tables. When I add a record from dataverse and run full sync, it gives below error.
The data could not be updated because of the following error: The field Project Task of table CX Timesheet contains a value (JOB00010) that cannot be found in the related table (Job Task).
Project field is working but /Project Task/ field gives error because the value /JOB00010/ is job no. not job task no. How can i correct this issue?
Field Mapping:
GeneralHelper.InsertIntegrationFieldMapping(
'Timesheet-Timesheet',
CX_Timesheet.FieldNo(ProjectNo),
DataverseTimesheet.FieldNo(cr334_Project),
IntegrationFieldMapping.Direction::Bidirectional, '', true,false);
GeneralHelper.InsertIntegrationFieldMapping(
'Timesheet-Timesheet',
CX_Timesheet.FieldNo(ProjectTaskNo),
DataverseTimesheet.FieldNo(cr334_ProjectTask),
IntegrationFieldMapping.Direction::Bidirectional, '', true,false);
Custom table definition:
field(49; ProjectNo; Code[50])
{
Description = '';
Caption = 'Project';
TableRelation = /Job/./No./;
}
field(51; ProjectTaskNo; Code[50])
{
Description = '';
Caption = 'Project Task';
TableRelation = /Job Task/./Job Task No./ where(/Job No./ = field(/ProjectNo/));
}
28
Share
Report
All responses (
Answers (
