Write necessary code which will not allow inserting item until "Inventory posting group" and "gen.pr

Mounika22
Member Posts: 18
how can we implement this
0
Answers
-
Please let us also know what did you try till now and what is not working0
-
No you cannot implement this functionality in Navision. All you can do is to check item when you buy or when you sale this Item. If an item has no filled necessary fields, you can stop entering this item as line one purchase or sales or any document.0
-
Hey Mounika22,
There could be two approach.
1. What Xhevat said you can follow as you need to stop execution or transaction while sales or Purchase.
2. Second approach will be write validation while creating new item so that system will stop completion of your Item Creation while creating Item. For this you need to write code on PageOnQueryClose.Thanks
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/0 -
You could put some code in the OnInsert and OnModify triggers that would set Blocked to TRUE if either of those two fields are blank.Kyle Hardin - ArcherPoint0
-
Is this a main table like Vendor, item, customer. Then you could set the blocked to true oninsert.
The onvalidate on the blocked field you could put
testfield('myfmandatoryfield1')
testfield('myfmandatoryfield2')
etc.
if one of them is blank then it wouldn't let you unblock the record. Then the only way to use the record is to make sure all the fields are filled.
Also Set the property "Not Blank"0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions