Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K 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
- 317 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.6K 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
Data integrity for Item Tracking 4.0
Bokk
Member Posts: 138
We are working on an upgrade from Nav 3.10 to Nav 4.0. We are getting some data related errors while trying to convert the DB. I would like some clarification if possible.
During the data transfer from the temp tables into 4.0, some checking is happening. For each Item Ledger Entry record, there should be corresponding Item Tracking Entry records equal to the Quantity (Item Ledger), so if the Item Ledger Entry Qty = 3, there will be 3 Item Tracking Entry records, each with Qty = 1. In some of our records, type OUTPUT, the Invoiced Quantity in the Item Tracking Entry records are 0 which is stopping the process.
We need to correct the data, but also be able to establish why it is happening so that it doesn't continue after the upgrade. I am not sure why the Invoiced Quantity would need to be <> 0. If items are produced, consuming things in the process, then output, is it not reasonable that they could be in inventory with an Invoiced Quantity = 0? Is it the relationship to the Item Ledger Entry that is causing problems? I am trying to determine what process they are doing that is creating the problem and it is not clear.
I think half my problem is not understanding all the functionality.
Thanks!
During the data transfer from the temp tables into 4.0, some checking is happening. For each Item Ledger Entry record, there should be corresponding Item Tracking Entry records equal to the Quantity (Item Ledger), so if the Item Ledger Entry Qty = 3, there will be 3 Item Tracking Entry records, each with Qty = 1. In some of our records, type OUTPUT, the Invoiced Quantity in the Item Tracking Entry records are 0 which is stopping the process.
We need to correct the data, but also be able to establish why it is happening so that it doesn't continue after the upgrade. I am not sure why the Invoiced Quantity would need to be <> 0. If items are produced, consuming things in the process, then output, is it not reasonable that they could be in inventory with an Invoiced Quantity = 0? Is it the relationship to the Item Ledger Entry that is causing problems? I am trying to determine what process they are doing that is creating the problem and it is not clear.
I think half my problem is not understanding all the functionality.
Thanks!
SGM
0