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)

Sort by

Suggested answer

YUN ZHU 102,908 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

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... 27,613 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

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,423 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July 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

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Subscribe to this forum!

Select categories

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

Featured topics

Product updates