62
Scenario: I have 2 table (custom Invoice and standard Purchase Header).
I am inserting multiple records using codeunit from "Custom Invoice" to " Purchase Header".
I want to put logic or validation that if any record facing error while inserting multiple records it should store value of error for that record and let it insert the next records.
Hi,
To achieve this you can do the following
1. Create a functions in some other objects to Loop through your table to get the records
Function()
{
table repeat
codeunit.setparameter(table);
if not codeunit.run() then
logyourerror here in some other table.
until table.next = 0;
}
2. Now as you can see we are calling Codeunit.run in if condition and before that we are setting up our table paramter
codeunit
trigger OnRun ()
begin
recordingtransferfromhere;
end;
setparameter(table:record)
begin
table2 := table;
end;
local function recordingtransferfromhere()
var
destTable:record;
begin
destTable.transferfields(table2);
destTable.insert();
end;
Hi, hope the following can give you some hints.
Handling Errors using Try Methods:
Collecting Errors:
https://www.youtube.com/watch?v=8_ltR1ceTKA
Thanks.
ZHU
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,564
Super User 2024 Season 2
#2
Martin Dráb
228,651
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (