Howdy, Stranger!
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
- 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
- 305 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Item cost adjustment taking long time..
raghuramkanna
Member Posts: 18
Hi...
Our company has entries from 2009 and we are using nav5.0, from past 1 year we are unable to run batch job "Item cost Adjustment" for some Raw material items.. due to this we are facing the problem of cost for FG items also.. it was taking long time but still unable to complete..
Our company has entries from 2009 and we are using nav5.0, from past 1 year we are unable to run batch job "Item cost Adjustment" for some Raw material items.. due to this we are facing the problem of cost for FG items also.. it was taking long time but still unable to complete..
0
Comments
poor performance in NAV ACIE seems a never ending story and you can find dozen of articles.
I had similar issue and my advise are:
1 . check if you have patched with latest MS hotfix objects C5895, T5802, T339
2. be sure that SQL statistics/indexes are updated for Value and Item LedgeEntry
3. create e pre report that call R795 doing a commit after each item has been processed
Good luck