web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Split the cost of cust...

Small and medium business | Business Central, N...

Suggested Answer

Split the cost of custom Boolean field item before deleting and split the cost to other items

(1) Share

Report

Report

Posted on by CU22100733-0

291

if the item with custom Boolean field ON is deleted before posting the order then it should distribute the custom Boolean field item's cost using Line Amount of other items as weight so if the Boolean field item is marked as 50 cost and there are 4 other items each with 5 quantities with line amount as 30,50,50,70 so total sales value is 250.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Khushbu Rajvi. 22,315 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

It will require customization, You can create a codeunit to check if the item has the Boolean field set to true, calculate the total sales value of the remaining items, and distribute the Boolean item's cost based on each remaining item's line amount relative to the total sales value. The code would update the line amounts of the other items accordingly before the Boolean item is deleted, ensuring that the cost is effectively allocated.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,024 Super User 2026 Season 1

#2

YUN ZHU 1,145 Super User 2026 Season 1

#3

Khushbu Rajvi. 705 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans