Howdy, Stranger!
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
- 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
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Create/Update Item No. after Insert
anushafdo
Member Posts: 32
Here is an adamant customer who wanted to have the Item No. in a way he wants nothing else. He is not willing to create it manually too. He is constructing the Item No. in the following way
101001001
first 2 char (10) - Item Category
char from 3rd to 6th (1001) is Product Group
Last three chars are Item and he wants the number to automatically increase.
I suggested to have different No. series. But, the way he has combined Item Category and Product Group, he may end up with more than 150 No. Series and, it is a REAL problem.
I suggested to have an additional field which I will programmatically populate. But, they insist that they want this for Item No.
One solution I see is to use a temporary No series to create the Item, and then update/rename the No. field by giving a button. He agrees that he will do this right after the item is created and before any transactions entered. I will programmatically create the necessary code. (I know that this process may also take time to finished as the no of items and transactions grow.)
Can you please share your thoughts and any other better solutions for this issue?
101001001
first 2 char (10) - Item Category
char from 3rd to 6th (1001) is Product Group
Last three chars are Item and he wants the number to automatically increase.
I suggested to have different No. series. But, the way he has combined Item Category and Product Group, he may end up with more than 150 No. Series and, it is a REAL problem.
I suggested to have an additional field which I will programmatically populate. But, they insist that they want this for Item No.
One solution I see is to use a temporary No series to create the Item, and then update/rename the No. field by giving a button. He agrees that he will do this right after the item is created and before any transactions entered. I will programmatically create the necessary code. (I know that this process may also take time to finished as the no of items and transactions grow.)
Can you please share your thoughts and any other better solutions for this issue?
0
Comments
1. Disable the ability to create new items from the standard page.
2. Create a new page with text boxes for "Item Category" and "Product Group" and an action to run the item page. To create a new item, the user would fill in the 2 text boxes then run the action. The system would create a new item record and open the page. The item no. would be determined by the values the user entered plus an incremented string.