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

All responses (3)

Answers (1)

Verified answer

DAnny3211 9,272 Super User 2024 Season 1 on at

Like (0)

Report

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

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
gdrenteria 12,290 Most Valuable Professional on at

Like (1)

Report

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

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
Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (1)

Report

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

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