New to business central, how to modify Currency Code in Requisition Line

(1) Share

Report

Posted on by CU11091502-0

I added a Currency Code field to the Item Vendor table so that when this field is changed (e.g., to USD), it also updates in the Requisition Line table. This allows a vendor to use a different currency code for an item without changing their default currency code. My question is how to implement this, as I'm very new to this environment and missing the underlying logic.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

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

Like (1)

Report

Hi, Just add the update logic in the OnValidate (Field) Trigger of this new field.

OnValidate (Field) Trigger

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/triggers-auto/field/devenv-onvalidate-field-trigger?wt.mc_id=DX-MVP-5004336

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,213 Most Valuable Professional on at

Like (1)

Report

Hi

As our colleague Yun has indicated, you could rely on validations. Here is some interesting information.

Many ways to validate a field in AL and Business Central – hougaard.com

How Many ways to validate a field in Business Central? - MADHDA Business Solutions - a Microsoft Partner

Best

GR

Was this reply helpful? Yes No
Verified answer

DAnny3211 11,397 on at

Like (0)

Report

hi,

see this

tableextension 50100 "Item Vendor Extension" extends "Item Vendor"
{
fields
{
field(50100; "Currency Code"; Code[10])
{
trigger OnValidate()
begin
UpdateRequisitionLineCurrencyCode("No.", "Currency Code");
end;
}
}

local procedure UpdateRequisitionLineCurrencyCode(ItemNo: Code[20]; CurrencyCode: Code[10])
var
RequisitionLine: Record "Requisition Line";
begin

//INSERT YOUR FILTER
if RequisitionLine.FindSet() then
repeat
RequisitionLine."Currency Code" := CurrencyCode;
RequisitionLine.Modify();
until RequisitionLine.Next() = 0;
end;
}

regards

Was this reply helpful? Yes No

Join the conversation

Community site session details

New to business central, how to modify Currency Code in Requisition Line

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

New to business central, how to modify Currency Code in Requisition Line

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates