Small and medium business | Business Central, N...

Converting data type

(0) Share

Report

Posted on by Salba Z.K

127

I have my table with field "EntryType" of Option datatype with options new, renewal &cancellation I want to add this particular option for specific entryNo to the code of "reason code"

table(231)

For Example for entry 001, EntryType is "New" then I want to add this to code of "Reason code" Table similar for different entries I tried some code but it doesnt working

local procedure reasoncode()

var

ReasonCode: Record 231;

begin

if not ReasonCode.Get(format(InsuranceTable."Transaction Type")) then begin

ReasonCode.Init();

ReasonCode.Code := format(InsuranceTable."Transaction Type");

ReasonCode.Insert(true);

end

end;

thanks,

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 71,565 Super User 2024 Season 2 on at

Like (1)

Report

RE: Converting data type

Hi, Maybe it's an Enum value issue?

Hope the following will help.

https://www.kauffmann.nl/2020/07/16/converting-enum-values-in-al/

Thanks.

ZHU
Suggested answer

Alok.kulshreshtha 934 on at

Like (1)

Report

RE: Converting data type

Hi,

I have run your code and it seems working. in my test i used Item ledger entry -> entry Type column and value is inserting into Reason code.

and below is a result after execute a code.

May i know how you are calling procedure reason code? better to enable debugger and check execution flow.

Regards,

Alok Kulshreshtha

Please Verify my answer if you find my post helpful.