Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 298 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.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
Adjust Cost Item problem
vasam
Member Posts: 53
Hi,
When we try to 'Adjust Cost - Item Entry' we are getting the following error:
'Another user has modified the record for this Avg. Cost Adjmt. Entry Point after you received it from the database ...'
Error always occurs for single Item No. but for different Entry No.
The table 'Avg_ Cost Adjmt_ Entry Point' is empty.
We have found the solution (with LOCKTABLE) for Navision 3.7, but the same could not be applied to Navision 4.0, because the procedure is different.
We have started test database where we are the only user, and then started the adjustment, but yet no result.
We are using Navision 4.0 SP2.
When we try to 'Adjust Cost - Item Entry' we are getting the following error:
'Another user has modified the record for this Avg. Cost Adjmt. Entry Point after you received it from the database ...'
Error always occurs for single Item No. but for different Entry No.
The table 'Avg_ Cost Adjmt_ Entry Point' is empty.
We have found the solution (with LOCKTABLE) for Navision 3.7, but the same could not be applied to Navision 4.0, because the procedure is different.
We have started test database where we are the only user, and then started the adjustment, but yet no result.
We are using Navision 4.0 SP2.
0
Answers
= Are you running this while users are posting?
= Did anyone modify the Adjust Costs report or Inventory Adjustment codeunit?
= Has anyone gone in and deleted entries from the Avg. Cost Adjmt. Entry Point table?
Dynamics West
http://www.dynamicswest.com
We have solved this issue.
The problem was in the "Item Ledger Entry" table, field "Applied Entry to Adjust". It was set to 1 which means that the item must be adjusted, but the item was allready shipped, but not invoiced.
We updated this field to 0, run the adjustment procedure and everything is ok now.
thank you all