Skip to main content

Notifications

Business Central forum
Suggested answer

Custom Calculation Formula in Business Central

Posted on by 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:
  • 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?
  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 11,228 User Group Leader 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

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,623 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,463 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans