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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 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
Nav Standard Cost Revaluation.
prasadcherukumalli
Member Posts: 2
Hi All,
Subject : when we run the item revaluation and Posting For open entries,it is Running for 13.3 Hrs.
We Facing a challenge During Item Revaluation and Posting.
According to our investigation,Total open entries Count in Item Ledger entries for all the Items is 88,000.
So Nav is processing 110 lines Per minute.
Database Specifications:
Nav 2013 R2, SQL Server 2014 Enterprise,Running on 64GB
As our Database size is 400 GB
where ILE Contribute's 8.3GB,Value Entry 14 GB,Item Application Entry 3.4 GB Respectively.
ILE Row Count is 16 Million ,VE Row Count is 17 Million ,ItemAppEntry Row count is 23 Million.
Actions taken:
SQl Profiler & Nav Profiler :
We Run Sql Profiling during this process,There is no recommendation at the end.We checked the Sql Indexes and Nav Keys,Which is Already Optimized and we noticed SQL Select Queries are Consuming more time.
Already SQL Side we taken care of creating Auto Create,Update & Group Statistics.Rebuilding indexes and Defragmentation.
Questions:
Customer not happy waiting for 14Hrs and hold the regular Transaction Posting, is there any way to reduce the time.?
Customer is using Finance, Sales, Purchase, Inventory Processes only not manufacturing.And in our database in ILE table every month 1.8 Million new record's are Adding up,Database is increasing at a rate of 30GB per Month due to heavy transactions on transfer Order and Item Reclassification.
Anybody Please Advise
Thanks In Advance.
Prasad.
Subject : when we run the item revaluation and Posting For open entries,it is Running for 13.3 Hrs.
We Facing a challenge During Item Revaluation and Posting.
According to our investigation,Total open entries Count in Item Ledger entries for all the Items is 88,000.
So Nav is processing 110 lines Per minute.
Database Specifications:
Nav 2013 R2, SQL Server 2014 Enterprise,Running on 64GB
As our Database size is 400 GB
where ILE Contribute's 8.3GB,Value Entry 14 GB,Item Application Entry 3.4 GB Respectively.
ILE Row Count is 16 Million ,VE Row Count is 17 Million ,ItemAppEntry Row count is 23 Million.
Actions taken:
SQl Profiler & Nav Profiler :
We Run Sql Profiling during this process,There is no recommendation at the end.We checked the Sql Indexes and Nav Keys,Which is Already Optimized and we noticed SQL Select Queries are Consuming more time.
Already SQL Side we taken care of creating Auto Create,Update & Group Statistics.Rebuilding indexes and Defragmentation.
Questions:
Customer not happy waiting for 14Hrs and hold the regular Transaction Posting, is there any way to reduce the time.?
Customer is using Finance, Sales, Purchase, Inventory Processes only not manufacturing.And in our database in ILE table every month 1.8 Million new record's are Adding up,Database is increasing at a rate of 30GB per Month due to heavy transactions on transfer Order and Item Reclassification.
Anybody Please Advise
Thanks In Advance.
Prasad.
0
Answers
we set "Automatic Cost Adjustment" to False,Every Night we are running two Job Queue for "Adj Cost Item Entries" and "Post Cost to G/L",These job's take 6 hrs to complete.