Hello Expert,
i am inserting record into my custom table consuming web services that's work fine.
now i am storing its history in history table Like old value / New value which is working properly when i am updating the record directly in Business Central but when i update record from jsonObject mean through web service it is not working i have debug the solution so the xRec not getting the X value below is the code.
if (xRec."RFI DueDate" <> 0D) then begin
Message(Format(xRec."RFI DueDate"));
if (Rec."RFI DueDate" <> xRec."RFI DueDate") then begin
rfiHistory.Init();
if rfiHistory.FindLast then
rfiHistory.ID := rfiHistory.ID + 1;
rfiHistory."job No." := Rec."Job No.";
rfiHistory."RFI No." := Rec."RFI Number";
rfiHistory."Modified On" := Rec."Modified On";
rfiHistory."Modified By" := Rec."Modified By";
rfiHistory."Old Value" := format(xRec."RFI DueDate");
rfiHistory."Current Value" := format("RFI DueDate");
rfiHistory."RFI Field Name" := 'RFI DueDate';
rfiHistory.Insert(true);
end;
end;