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 96,039 Super User 2025 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... 25,396 Most Valuable Professional 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,399 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

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

News and Announcements

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