What Table does NAV store Item Tracking (Serial Number) information on?

jdphillips@maattech.com
Member Posts: 1
Where does NAV store Item Tracking information for production orders? In this particular case, we are trying to figure out where NAV stores the serial number so we can retrieve that data to automate the printing of property stickers of items being manufactured. The Production Order Lines table has a lot of useful information for what I am trying to accomplish but doesn't have any of the Item Tracking information. I can also see that the serial number is recorded on the Item Ledger Entries after output from the Production Journal is posted, but I can't figure out where that data is stored prior to completing/posting output of a finished production order. What table should I be looking for to see this data?
0
Answers
-
item tracking is configured in temporary table 336 - Tracking Specification on Page 6510 Item Tracking Lines. Which is then transfered to table 337 - Reservation entry
If you want to see all Item Tracking Entries via Client, there should be a Page named "Item Tracking Entries" somewhere, but I'm not sure where.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