Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / How to add a validatio...
Microsoft Dynamics NAV (Archived)

How to add a validation when add or update data in "Sales Line Discount" ?

(0) ShareShare
ReportReport
Posted on by surajitkundu 975

Hi expert ,

 

   I have added a field( 'field1' ) in "Sales Line Discount"  . Navision have already provide a validation with few fields . Now I want to include my field ('field1') in validation when my field is non empty. How I can add this type of  validation in "Sales Line Discount" ? Please give me suggestion .

 

Thanks

Surajit 

*This post is locked for comments

  • Verified answer
    surajitkundu Profile Picture
    surajitkundu 975 on at
    RE: How to add a validation when add or update data in "Sales Line Discount" ?

    Hi all,

     Thanks, Right i want to stop duplicate record. Now i understand i need to be set my udf column as key .

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,054 Super User 2024 Season 2 on at
    RE: How to add a validation when add or update data in "Sales Line Discount" ?

    What do you mean by Validation?

    If you want to stop duplicate records with your field also then you need to add your field in Primary Key..

  • surajitkundu Profile Picture
    surajitkundu 975 on at
    RE: How to add a validation when add or update data in "Sales Line Discount" ?

    Hi Mohana,

     I want to add validation on ('Sales Type', 'Sales Code', Type,Code,Min Qty , Line Discount , and My UDF) if user try to insert duplicate in above columns then Sales Line Discount will be ot inserted or updated.

    Thanks

    Surajit

  • Mohana Yadav Profile Picture
    Mohana Yadav 60,054 Super User 2024 Season 2 on at
    RE: How to add a validation when add or update data in "Sales Line Discount" ?

    Can you be more clear, better with an example.

  • surajitkundu Profile Picture
    surajitkundu 975 on at
    RE: How to add a validation when add or update data in "Sales Line Discount" ?

    Hi SAVATAGE,

       Thanks for the reply .column is code type field .This field is link with another column(code type) of my user define table .Field is shwing a dropdownlist .Now i have not changes any where .I don't know how can i solved it ?

    Thanks

    Surajit

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to add a validation when add or update data in "Sales Line Discount" ?

    If you are using it in some calculation then it should never be empty.  

    It should either be "zero" or some other value.

    without knowing what this field actually does or why you need it it's hard to answer your question.

    have you looked at the cose behind the "line discount % field?

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans