Serial Number Information

spena
Member Posts: 45
Hi!
How can I see a list of serial numbers on hand and the serial numbers that have been reserved?
When I open sales quote or sales order and go into Item Tracking Lines, and click the elipsis next to Serial No, I see the the information I need. However, when looking at the corresponding table, the Entry Summary table (338), the table is empty. The Entry Summary is a temp table.
I need to find the correct source to pull a list of serial numbers in the system and the serial numbers that have already been reserved.
Thanks,
Steve
How can I see a list of serial numbers on hand and the serial numbers that have been reserved?
When I open sales quote or sales order and go into Item Tracking Lines, and click the elipsis next to Serial No, I see the the information I need. However, when looking at the corresponding table, the Entry Summary table (338), the table is empty. The Entry Summary is a temp table.
I need to find the correct source to pull a list of serial numbers in the system and the serial numbers that have already been reserved.
Thanks,
Steve
0
Comments
-
You can use standard view Item tracking entries on Item card.
Use filters Open = True and add column Reserved quantity.0 -
Steve,
Any reserved or lotted items would show up in the Reservation Entry table. I highly recommend you cobble a report together on the serial no. info table and add links to the reservation entry table to find out if your serial no. is in fact on hand and available or reserved or consumed.
I hope this helps.
Regards,Mohamad El-Sadek, MCP, MBSS, MCTS
G.R. & Associates, Inc.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