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 / Microsoft Dynamics NAV (Archived) / Goal Seek function in NAV
Microsoft Dynamics NAV (Archived)

Goal Seek function in NAV

(0) ShareShare
ReportReport
Posted on by Tina Menezes 2,582

Hi all,

Our client is currently using excel sheet to maintain records. They use the goal seek function currently in excel. Now they want to do everything that they did in Excel using NAV. So I want to know is it possible to customize and code goal seek function in NAV and what formula does the goal seek function use?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Tina Menezes Profile Picture
    Tina Menezes 2,582 on at
    RE: Goal Seek function in NAV

    Hi all,

    There is no standard method for developing goal seek in NAV. I completed developing Goal seek functionality in NAV by using customization and using different formulae according to the formulae used in the original Excel. So customization is the only alternative.

  • Verified answer
    dkatson Profile Picture
    dkatson 2,263 on at
    RE: Goal Seek function in NAV

    For users who don't know what is goal seek function www.youtube.com/watch

    In NAV there is no analog of this function, so you have next options:

    - use customisation

    - change users behaviour

    - use Excel Addin for NAV (community.dynamics.com/.../how-do-i-configure-the-excel-add-in-in-microsoft-dynamics-nav-2017)

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans