I have created an extension of the table "Sales line", in which I have created a field "Shipped Not Inv. No VAT", which should be the result of the multiplication of two existing fields in the table, "Qty. Shipped Not Invoiced" * "Unit price", this in each line. I have added the operation in the "OnAfterValidate ()" tigger of both fields, but nothing happens.
Also try to do it through a codeunit, following this example:
But it doesn't work for me either. Is there something I need to add somewhere?
codeunit 52122 ShipNotInvNoVATPub { trigger OnRun() begin end; [IntegrationEvent(false, false)] local procedure OnAfterValidate(var r: Record "Sales Line") begin end; } codeunit 52123 ShipNInvNoVATSub { trigger OnRun() begin end; [EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnAfterValidateEvent', 'Unit Price', false, false)] local procedure UnitPriceChange(var Rec: Record "Sales Line") begin Rec."Shipped Not Inv. No VAT" := Rec."Unit Price" * Rec."Qty. Shipped Not Invd. (Base)"; end; [EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnAfterValidateEvent', 'Qty. Shipped Not Invd. (Base)', false, false)] local procedure QtyChange(var Rec: Record "Sales Line") begin Rec."Shipped Not Inv. No VAT" := Rec."Unit Price" * Rec."Qty. Shipped Not Invd. (Base)"; end; }
Code looks right to me at a quick glance. A few things to try:
Make sure your extension is published. Restart the nav service tier (not sure how that works in the cloud as I'm on-prem). Run the debugger when changing data in those fields.
OnAfterValidate of field trigger will work when we enter/validate data in that field.
Please OnAfterGetRecord on Subpage trigger to check if it is working or not.
Hello,
We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.
dynamicsuser.net/.../developers
I will open this up to the community in case they have something to add.
Thanks
Sohail Ahmed
932
YUN ZHU
841
Super User 2025 Season 1
Mansi Soni
602