Hi all,
I have a situation where i have to get dimension values, names and codes and move them to other company's general journal. For this purpose i am using GetDimensionSetID method from Dimension Management code unit. I am facing issue as GetDimensionSetID is getting ID from same company instead of the change company. Here is the code:
DimVal1.Reset();
DimVal1.ChangeCompany(CompanyName);
DimVal1.SetFilter(DimVal1."Dimension Code", 'PROJECT');
DimVal1.SetFilter(DimVal1.Code, Project);
IF DimVal1.FindFirst() THEN begin
ProjValID := DimVal1."Dimension Value ID"; //////////////////////Working fine here(getting dimension value from other company)
end;
dimSetTemp.ChangeCompany(CompanyName);
dimSetTemp.Reset();
dimSetTemp."Dimension Code" := 'PROJECT';
dimSetTemp."Dimension Value Code" := Project;
dimSetTemp."Dimension Value ID" := ProjValID;
dimSetTemp.Insert();
GenJnlLine."Dimension Set ID" := dimMgt.GetDimensionSetID(dimSetTemp); //////////////////////Get id of same company instead of the other company.
Please help me how i can resolve this.
Regards,