Serial No. Length Work Around (Already Know Not to lengthen)

derekj22
Member Posts: 16
I have read all of the "DO NOT LENGTHEN SERIAL NO." posts. With that out of the way, my client has a situation where they have to combine two halves which from factory typically are "married" with top half and bottom half having the same serial no. However, there are instances where the bottom or top half could go bad and then they are re-united with a new half. This creates an instance where there are now two serial numbers that have been joined to create a single serial no. In these instances the length can grow over the 20 character max.
I am looking for a solution that would be best practices for this type of situation. Any suggestions would help!
Key points of interest are the following:
I have added a second extension field to the Serial No. Information table (6504) and Card (6504). This is a field I can view from the Item Ledger Entries view, through some extending I have done.
My concern is when my client goes through the Service Orders module, they do not receive their components into inventory so as not to inflate inventory. They track these items through the Service Order and Service Items that are created through this process. Because of this when the Service Item Line is having the Serial No. designated, there will not be away to provide the second serial no. or the overflow field. What would be the best way to account for this?
Thank you,
dj
I am looking for a solution that would be best practices for this type of situation. Any suggestions would help!
Key points of interest are the following:
I have added a second extension field to the Serial No. Information table (6504) and Card (6504). This is a field I can view from the Item Ledger Entries view, through some extending I have done.
My concern is when my client goes through the Service Orders module, they do not receive their components into inventory so as not to inflate inventory. They track these items through the Service Order and Service Items that are created through this process. Because of this when the Service Item Line is having the Serial No. designated, there will not be away to provide the second serial no. or the overflow field. What would be the best way to account for this?
Thank you,
dj
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