Adjust Cost Error in SQL

fcipriano
Member Posts: 26
When triyng to run the Adjust Cost - Item Entries batch job in Navision Database SQL, the following error occurs:
"Another User has Modified the record For this item after you retrieved it from the database......."
If we try to run the routine using the same data, but on a Navision Server database, the routine runs until the end.
The intalled software versions are:
SERVER
OS: Win2000 Server + SP4
DB: SQL Server Standard Edition 2000 + SP3
CLIENT
OS: Win2000 Profesional + SP4
What should we do to handle with this situation?
"Another User has Modified the record For this item after you retrieved it from the database......."
If we try to run the routine using the same data, but on a Navision Server database, the routine runs until the end.
The intalled software versions are:
SERVER
OS: Win2000 Server + SP4
DB: SQL Server Standard Edition 2000 + SP3
CLIENT
OS: Win2000 Profesional + SP4
What should we do to handle with this situation?
0
Comments
-
You should obtain the latest hotfix for 3.70 - or just get hold of 3.70A.Dean McCrae - Senior Software Developer, NAV Server & Tools
This posting is provided "AS IS" with no warranties, and confers no rights.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