Use the item unit cost on a sales order

(2) Share

Report

Posted on by LF-16052033-0

526

Hello experts,

Is there a way to use the item unit cost + 15% to be calculated on a Sales Order for a particular customer?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Sohail Ahmed 11,150 Super User 2025 Season 2 on at

Like (2)

Report

Yes, this is possible, but you’ll need a small customization.

If you're a developer, I can share a code snippet to help you implement this logic in AL. Otherwise, I recommend reaching out to a Microsoft partner or a developer who can convert your requirement into AL code. It’s a simple customization and can be done in just a few lines.

Mark this as the verified answer if it helps.

Was this reply helpful? Yes No
LF-16052033-0 526 on at

Like (2)

Report

Please share your suggested code snippet.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,637 Super User 2025 Season 2 on at

Like (2)

Report

Unfortunately not on standard but a little quick customization will work -

Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (2)

Report

Some ISVs like Insight Works’ Pricing Matrix or Lanham Pricing offer cost-plus pricing logic out-of-the-box without needing AL customization.

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,838 Super User 2025 Season 2 on at

Like (4)

Report

Yes, you can achieve this by customizing the pricing logic.

if Rec.Type = Rec.Type::Item then begin
// Check for your specific customer
if Rec."Sell-to Customer No." = 'YOURCUSTOMERNO' then begin
if Item.Get(Rec."No.") then begin
Rec."Unit Price" := Round(Item."Unit Cost" * 1.15, 0.01);
end;
end;
end;

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,150 Super User 2025 Season 2 on at

Like (3)

Report

codeunit 50100 "Custom Sales Price Handler"
{
[EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnAfterValidateEvent', 'No.', true, true)]
local procedure SetCustomPriceForCustomer(var Rec: Record "Sales Line"; xRec: Record "Sales Line"; CurrFieldNo: Integer)
var
Item: Record Item;
begin
// Check if it's a Sales Order and for specific customer
if Rec."Document Type" = Rec."Document Type"::Order then begin
if Rec."Type" = Rec."Type"::Item then begin
if Rec."Sell-to Customer No." = 'CUST001' then begin
if Item.Get(Rec."No.") then begin
Rec."Unit Price" := Round(Item."Unit Cost" * 1.15, 0.01);
end;
end;
end;
end;
end;
}

How it works:

Triggers when the item is selected on a Sales Order Line.

Checks if the customer is CUST001.

Pulls the Item Unit Cost and calculates Unit Cost + 15%.

Sets that as the Unit Price.

You can extend this logic for more customers or make it data-driven via a setup table.

Mark this as the verified answer if it helps.

Was this reply helpful? Yes No
Verified answer

Sagar Dangar, MCP 799 Super User 2025 Season 2 on at

Like (2)

Report

Hi,

You can define on particular items and it will calculate unit price for all customer.

Note: To make it for particular customers only, you need to add small customization through developer

Was this reply helpful? Yes No