Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Same data in 'No.' field in Production BOM page.
Rajat_M
Member Posts: 34
Hello,
In 'Production BOM' page within the Lines fasttab whenever I entered a type 'Item' & a 'No.' which was already there it'll take it again. But it shouldn't be like this. The 'No.' field must not take the same numbers in subsequent entries.I test this by creating another primary key as 'No.' but it doesn't helped me.
Can anyone suggest me how should I proceed??
Thank You,
In 'Production BOM' page within the Lines fasttab whenever I entered a type 'Item' & a 'No.' which was already there it'll take it again. But it shouldn't be like this. The 'No.' field must not take the same numbers in subsequent entries.I test this by creating another primary key as 'No.' but it doesn't helped me.
Can anyone suggest me how should I proceed??
Thank You,
0
Answers
If in your case you do not want this, then you need customization to prevent the use of the same item; you should probably write some code in the OnValidate triggers of both the Type and No. fields in the Production BOM Line table - better yet: use events!
DO NOT CHANGE THE PRIMARY KEY!