Send Alert to mail for New Vendor Creation

(2) Share

Report

Posted on by Dividutt

208

Hi,

I have a query on How to trigger an alert to mail when a new vendor card is created?

My mail body should have :

Message: New Vendor card is created.

Table body: should have these fields , 1) account code 2)Name 3) date of creation 4)Who created the record

Please need help in this how can be done in Al code

Thankyou.

All responses (18)

Answers (3)

Sort by

Mohana Yadav 61,248 Super User 2026 Season 2 on at

Like (2)

Report
Copy link

Link copied!

What did you try and what issue are you facing?
NAV_with_Narang 2,410 Moderator on at

Like (1)

Report
Copy link

Link copied!

Since your aim is to write a suitable AL code to send Emails from BC, you can refer the below link

businesscentralgeek.com/5-ways-to-send-an-email-in-business-central

However, I would suggest use Power Automate instead of writing code in AL (if the customer has a license for PA).

Sending an email every time some field is modified on BC on a vendor card, that can turn out inefficient or result into a lot of spam emails to someone. I'd suggest place the email SEND option when the record gets modified AND the vendor card is closed
Dividutt 208 on at

Like (1)

Report
Copy link

Link copied!

When I am creating an new vendor card

Mail not getting triggered, how can I show message when I create new vendor card is there any trigger event?
Verified answer

Mohana Yadav 61,248 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

where did you write code?

You have to use OnInsert triggers but you wont have other data like Name etc. by that time
Muhammad Faizan Sub... 34 on at

Like (2)

Report
Copy link

Link copied!

You can use Power Automate to create a workflow to send emails.
Dividutt 208 on at

Like (1)

Report
Copy link

Link copied!

I have no problem in sending mail, but I have to sent mail only when I create a new vendor card so

This is code I tried is there any modifications needed?

codeunit 50132 "Alert for New Vendor Creation"

{

[EventSubscriber(ObjectType::Table, Database::Vendor, 'OnAfterModifyEvent', '', true, true)]

procedure AlertVendor(var Rec: Record Vendor; xRec: Record Vendor)

var

rec_Vendor: Record Vendor;

begin

if rec_Vendor.FindSet() then

repeat

Message('%1',rec_Vendor."No.")

InsertIntotable (rec_Vendor)

until rec_Vendor.Next() = 0;

end;

procedure InsertIntoTable(rec_Vendor: Record Vendor)

var

rec_AlertNewVendor: Record "Alert New Vendor Creation";

begin

rec_AlertNewVendor.Init();

rec_AlertNewVendor.No := CreateGuid();

rec_AlertNewVendor."Account Code" := rec_Vendor."No.";

rec_AlertNewVendor.Name := rec_Vendor.Name;

rec_AlertNewVendor."Date of Creation" := rec_Vendor.SystemCreatedAt;

rec_AlertNewVendor.User := rec_Vendor.SystemCreatedBy;

end;

So here when I create an new vendor card i need to get the message and table with these fields.
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hi,

Seems that you have taken a wrong approach to create a new vendor. Can you tell me your requirement please?

Thanks
Dividutt 208 on at

Like (1)

Report
Copy link

Link copied!

Hi Nithin Verma,

When I created a new vendor card i want to show alert that new vendor card is created and wanted to show its No Name Date and User who created it.

So just needed to how to trigger when new vendor is created.
Muhammad Faizan Sub... 34 on at

Like (2)

Report
Copy link

Link copied!

Hi Divi,

Seems like you are subscribing the wrong event. try to subscribe insert record events.
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hi,

You need to write your Event in custom codeunit like below and put your code inside Begin..End.

[EventSubscriber(ObjectType::table, database::Vendor, 'OnAfterInsertEvent', '', false, false)]

local procedure OnAfterInsertEventVendor(var Rec: Record Vendor)

begin

end;