web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / 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) ShareShare
ReportReport
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:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 14,374 Super User 2025 Season 2 on at
    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
  • LY-02050752-0 Profile Picture
    LY-02050752-0 6 on at
    Custom Calculation Formula in Business Central
     
    Thank you, would you please give me a sample or video?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,553

#2
Sumit Singh Profile Picture

Sumit Singh 2,057

#3
YUN ZHU Profile Picture

YUN ZHU 1,915 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans