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

Get the default values from setup form

(0) Share

Report

Posted on by peopleeater

I want to Insert some fields in my table from my setup table, as default fields for every new record.

Currently, it is not getting the records from my Setup Table, as soon as I add the source type and move to the next field it gets records on my page.

I have tried both OnInsert() in my table and OnInsertRecord() in my form, but it only works when the record is inserted into the table... when I leave the control that shows the primary key in the form.

// This is the code on my Card Page of above screenshot.
trigger OnInsertRecord(BelowxRec: Boolean): Boolean
var
uerRoyaltyAllocationParm: Record uerRoyaltyAllocationParameters;
begin
uerRoyaltyAllocationParm.Get();
Rec.uerCommLedgerDimensionAccount := uerRoyaltyAllocationParm.uerCommLedgerDimensionAccount;
Rec.uerAllocLedgerDimensionAccount := uerRoyaltyAllocationParm.uerAllocLedgerDimensionAccount;
Rec.uerBatchLedgerDimensionAccount := uerRoyaltyAllocationParm.uerBatchLedgerDimensionAccount;
end;

Is there any way or any other method to initialize the values before I insert the primary key.. as we do with the Init method of D365F&O?

Thanks.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Amit Baru 3,037 on at

Like (0)

Report

Hi,

Pls write code on Table trigger

trigger OnInsert()

var

uerRoyaltyAllocationParm: Record uerRoyaltyAllocationParameters;

begin

uerRoyaltyAllocationParm.Get();
Rec.uerCommLedgerDimensionAccount := uerRoyaltyAllocationParm.uerCommLedgerDimensionAccount;
Rec.uerAllocLedgerDimensionAccount := uerRoyaltyAllocationParm.uerAllocLedgerDimensionAccount;
Rec.uerBatchLedgerDimensionAccount := uerRoyaltyAllocationParm.uerBatchLedgerDimensionAccount;

end;

Regards

Amit Sharma

www.erpconsultors.com

linkedin.com/in/amit-sharma-94542440/

Press Yes if info is useful.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi,

You can use the Install codeunit functionality in Business central, it help you insert the default data as you load any company in any of the tenant. Please refer the below link how to use that.

docs.microsoft.com/.../devenv-extension-install-code

Was this reply helpful? Yes No
peopleeater 67 on at

Like (0)

Report

Hi Amit Sharma,

As I've mentioned in the post I have tried both ways, at first, I tried using the OnInsert() event on my table, but it gives the same result as OnInsertRecord() on my form.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,750 Super User 2025 Season 2 on at

Like (1)

Report

Hi, This looks like a Setup page.

So I think you can try to use OnOpenPage() trigger of this setup page.

More details: https://yzhums.com/8924/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No