Notification of Price Change

(1) Share

Report

Posted on by JE-29041340-0

386

Hi:

In the "Prices & Sales" FastTab of the Item Card, you can choose "Price=Cost+Profit" for the Price/Profit Calculation.

If you make a change to "Profit %", "Unit Price" changes automatically.

Also, for the Item Card, you can click the link for the "Sales Prices & Discounts" field to set up special prices and discounts.

Is there a way to have Business Central notify or alert the end user in some form, when he or she changes the Profit % and causes the "Unit Price" to be different from the "Sales Price" for special prices and discounts?

Thanks!

John

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (1)

Netjacker2097 286 on at

Like (0)

Report

Notification of Price Change

Hi,

this should work for what you need if you table extend on item table. Also add some control on the user setup with the boolean for ITNotify.

I have not tested this so please try in SB enviroment and ensure it all works before you add the Live.

trigger OnAfterModify()

var

RecEmailM: Codeunit "Email Message";

RecEmail: Codeunit Email;

Body: Text;

Msg: Label 'Hello The Item No. is %1. The Profit Percentage has changed, causing the Unit Price to be different from the Sales Price. Regards, BC System Message';

UserSetup: Record "User Setup";

UserIdVar: Text[100];

EmailCreated: Boolean;

begin

if (Rec."Profit %" <> xRec."Profit %") and (Rec."Unit Price" <> xRec."Unit Price") then begin

UserSetup.SETRANGE(ITNotify, TRUE);

if UserSetup.FINDSET THEN BEGIN

REPEAT

UserIdVar := FORMAT(UserSetup."User ID");

Body := StrSubstNo(Msg, Rec."No.");

RecEmailM.Create(UserSetup."E-Mail", 'Item - Email Notification', Body, true);

IF NOT RecEmail.Send(RecEmailM) THEN BEGIN

ERROR('Failed to send email to user: %1', UserIdVar);

END;

UNTIL UserSetup.NEXT = 0;

END;

Message('Profit % has changed for item %1, causing the Unit Price to be different from the Sales Price.', rec."No.");

end;

end;

Was this reply helpful? Yes No
Verified answer

Gerardo Rentería Ga... 23,572 Most Valuable Professional on at

Like (1)

Report

Notification of Price Change

Hi

I would tell you to rely on field monitoring, review this functionality.

Dynamics 365 Business Central: monitoring field changes with telemetry is better… – Stefano Demiliani

Setting up Field Monitoring in D365 Business Central for Improved Secu – ERP Connect Consulting

Auditing changes - Business Central | Microsoft Learn

BR

GR

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 92,292 Super User 2025 Season 2 on at

Like (1)

Report

Notification of Price Change

Hi, As far as I know there is no standard feature for this. You could look for it in My Notifications, but I think this might need customization.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No