Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 270 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Production Journal Lines Not Deleting
KimDyn
Member Posts: 35
Encountering a recurring issue in NAV 2009 R2 Manufacturing where the end user opens the Production Journal from a Released Production Order and receives the following error:
The Item Journal Line already exists. Identification fields and values: Journal Template Name='PROD ORDER', Journal Batch Name='A';Line No.='-2147477296'.
Having investigated this issue in the past, the underlying issue is there are too many lines and the system cannot add anymore without hitting an overflow error. When looking at the records, a great number of the lines are related to production orders that have already been closed, but the Production Journal Lines are not deleted. Other records have been sitting in the journal for months. Of course, the lines are deleted as expected in other cases. I have not been able to find the reason why some delete the lines while others do not.
Since old Production Journal lines are not always being cleared out, new Line No.'s eventually increment up to the point that no more lines can be added and the errors start again. I have created a process to delete all lines for Production Journals that is run off hours. I don't believe this process shouldn't be necessary. Hoping someone has some insight into this issue. I can code around this, but would rather address what is causing it to happen.
The Item Journal Line already exists. Identification fields and values: Journal Template Name='PROD ORDER', Journal Batch Name='A';Line No.='-2147477296'.
Having investigated this issue in the past, the underlying issue is there are too many lines and the system cannot add anymore without hitting an overflow error. When looking at the records, a great number of the lines are related to production orders that have already been closed, but the Production Journal Lines are not deleted. Other records have been sitting in the journal for months. Of course, the lines are deleted as expected in other cases. I have not been able to find the reason why some delete the lines while others do not.
Since old Production Journal lines are not always being cleared out, new Line No.'s eventually increment up to the point that no more lines can be added and the errors start again. I have created a process to delete all lines for Production Journals that is run off hours. I don't believe this process shouldn't be necessary. Hoping someone has some insight into this issue. I can code around this, but would rather address what is causing it to happen.
Kimberly Weir
0