Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Leaving Microsoft Dyna...
Microsoft Dynamics NAV (Archived)

Leaving Microsoft Dynamics NAV Screens forms rejecting input data

(0) ShareShare
ReportReport
Posted on by Halweg 5

Hi together!

As a software auditor I have to proof if in any ERP software it is possible to leave screen masks rejecting before inputted data.  Often ERP programs based on MD NAV (formerly Navision) fail this test. Any in a screen form inputted data directly goes to the database. There seems no possibility to reject inputted data or making some undo while the screen form is open. 

I'm curious if this is really a problem by MD's design. May be there are any workarounds unknown to the audited MD NAV developers.  

Greetings, Halweg

*This post is locked for comments

  • Halweg Profile Picture
    Halweg 5 on at
    RE: Leaving Microsoft Dynamics NAV Screens forms rejecting input data

    OK, it seems my optimism was prematurely: No rejecting as soon the new data is entered.

    Thus, this test case remains a problem case: User will not be able to reject input when he detects to late that the new data is wrong.

    What about the case if entering the city of a new postal address and then, when entering the zip code, the data validation detects there's no correct zip code and hence no valid address? Is the user forced to save incorrect data? Moreover this seems to stand in contrast to a late form-related data validation.

    I'm afraid there are no plans in the Navision team to add data rejecting methods  in future releases :(

    Suresh Kullas way over a temporary table may be interesting, if there are some Navision methods to get rapidly a small copy of a database table with the same properties as the original table: same data types, same data validation rules, same index checking (in case of a related table) a. s. o. In all other cases the programmer has to code far from the original database rules what reduces the reliability.

    Could it be a good idea to have a special flag of a database record for a temporary state while input is in progress?

    But thanks for your patiently help! It seems my user group has to make a more general decision for or against Navision based programs.

    Greetings, Halweg

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 47,789 on at
    RE: Leaving Microsoft Dynamics NAV Screens forms rejecting input data

    There is one possibility but it is not straight forward, we need to get all the data into a temporary table and use that as the source for the page, so when user updating data it is updating temporary table and based on the user action if he wants to save then move that data to the real table.

  • ManishS Profile Picture
    ManishS 80 on at
    RE: Leaving Microsoft Dynamics NAV Screens forms rejecting input data

    There is not process of rejecting a data which has been inputted in a particular field.

    If the user has inputted the data in a field and he moves to the next field the data is saved automatically.

    To what i understood is that you want a validation of the data inputted is correct or not so that system pops up a error message to correct the data !

  • Halweg Profile Picture
    Halweg 5 on at
    RE: Leaving Microsoft Dynamics NAV Screens forms rejecting input data

    Sorry, there may be some misunderstanding: I don't mean a Navision defined Cancel Button but some button the programmer adds to a input screen. The screens I have to test have multiple tabs (with input controls) and different context related buttons.  I don't know if these are "standard forms". But as there are programmer defined buttons there should be an option to add a button that (1) sets a cancel condition and (2) closes the input screen triggering the validation (following be rejecting data).

    So the right question may be not about "standard forms" or "pages" but about some functionality to reject previously entered information in screen fields.

    Greetings, Halweg

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 47,789 on at
    RE: Leaving Microsoft Dynamics NAV Screens forms rejecting input data

    In Navision there is no Cancel Button whether it is a form or Page, so only way to avoid the changes made by the user is by adding validation on the field or adding code on the onQueryClosePage Trigger, but to reject the values there should be some kind of validation.  

  • Halweg Profile Picture
    Halweg 5 on at
    RE: Leaving Microsoft Dynamics NAV Screens forms rejecting input data

    As an auditor I often don't know which version of Navision / MD they use. I have to inspect programs based on Navision every 2-3 years. Also do my colleagues, they have the same test cases. A 2013 reported Dynamics NAV Version was "2009 (Version 6)".

    And yes, often there were no "Cancel" buttons. The users demand is to have an "option to leave a partially filled screen form without changes in the database".

    But I don't know if the audited screen forms were Navision forms or "pages" or something self-made.  

    But the unique statement from the programmers was "There's no way to make the user able to reject (or undo) input as soon as he leaved one or more input fields by cursor movement. This is a Navision issue."

    Currently I'm updating the test criteria and together with a user group I have to decide how to handle Navision based programs test failing.

    Greetings, Halweg

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 47,789 on at
    RE: Leaving Microsoft Dynamics NAV Screens forms rejecting input data

    If you open any standard form, normally it don't have any cancel button.  It is very important to know what version you are referring because in the newer version there are no forms there are only pages.

    We can program to add the cancel button but that is for each form you have to program that way.

  • Halweg Profile Picture
    Halweg 5 on at
    RE: Leaving Microsoft Dynamics NAV Screens forms rejecting input data

    Thanks again!

    In my case the cancel button (or any other cancel-control) is essential: the user should be able to freely decide to reject the input. For his decision he needs an explicit and clear control. There's no special data condition.

    I wonder why programmers don't use this apparently easy mechanism. May be there are some problems with nested forms (i. e. input new client-data leads to the input new country dialog or similar).

    I missed the cancel-function (on a form level) with all audited ERP-solutions based on Navision. 

    Greetings, Halweg

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 47,789 on at
    RE: Leaving Microsoft Dynamics NAV Screens forms rejecting input data

    You don't need any Cancel button by default that is available when you open the form, you need to add the condition on QueryCloseForm event the close action if it is OK or Cancel and perform necessary validations and throw the Error Message which will stop the user closing the form and have the ability to rectify.

    It is not new in Navision,

  • Halweg Profile Picture
    Halweg 5 on at
    RE: Leaving Microsoft Dynamics NAV Screens forms rejecting input data

    Just for understanding:

    The programmer has just
    - add a Cancel button to the form

    - make the button press event to (1) set any cancel condition and (2) close the form

    - proof the cancel condition with the "OnQueryCloseForm" event

    - and when Cancel=True launch the ERROR('Message') statement

    This will discard all changes from the input form and close it? The user may see any Dialogbox with any customizable text? No timestamps are made?

    Is this applicable to any normal input form? Is this new in Navision?

    Greetings, Halweg

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans