News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Custom Calculation For...

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

Suggested answer

Custom Calculation Formula in Business Central

(0) Share

Report

Report

Posted on by LY-02050752-0

6

Hi, everyone,

Here my requirement is let different user has their own calculation formula.

As different country has diff business logic.

For example,

Table:

ID,

Name,

Period,

Insurance,

Tax,

Discount,

Price

Country A user: Price = Period*3*Tax + Insurance

Country B user: Price = Period*Discount + Tax

How can I let user to define their own formula and do the calculation?

Regards,

Categories:

Business Central

All responses Img

All responses (2)

Answers Img

Answers (0)

LY-02050752-0 6 on at

Like (0)

Report

Custom Calculation Formula in Business Central

Saurav.Dhyani

Thank you, would you please give me a sample or video?
Suggested answer

Saurav.Dhyani 17,959 Super User 2024 Season 2 on at

Like (0)

Report

Custom Calculation Formula in Business Central

Hi,

Depending on your need you can choose different ways.

If it's that simple as listed above, then you can have a setup build and based on that setup you can call different companies.

Example - A Enum/option in company information and based on selection use a specific formula.

If it's a big mod that you are doing, then I would recommend using interfaces which make its super flexible.

Regards,

Saurav Dhyani

https://bit.ly/SubscribeSauravYouTube

Helpful resources

News and Announcements

Forum Structure Changes on 11/8 – Update Your Subscriptions!

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2

Martin Dráb 229,275 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans