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
- 295 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
inventory on item card not tally
Ray2010
Member Posts: 2
Hi All,
good morning.....
I have a problem: on the item card inventory qty are not tally (and sometime negative) with the actual detail transaction in the item ledger entry. There are a lot of items qty like this and our warehouse getting headache ](*,) everyday because the production planner getting wrong figure of stock qty. When we breakdown the inventory qty and paste the data to excel, then calculate manually, the qty was not tally the what appears on item card.
due to our consultant, this is because of the indexing on sql server, is it true?
How to fix it? Is it the bug of Navision?
we're using Nav4.0 sp3 and SQL2005 server.
Kindly share your experience, thanks.
rgds,
Ray
good morning.....
I have a problem: on the item card inventory qty are not tally (and sometime negative) with the actual detail transaction in the item ledger entry. There are a lot of items qty like this and our warehouse getting headache ](*,) everyday because the production planner getting wrong figure of stock qty. When we breakdown the inventory qty and paste the data to excel, then calculate manually, the qty was not tally the what appears on item card.
due to our consultant, this is because of the indexing on sql server, is it true?
How to fix it? Is it the bug of Navision?
we're using Nav4.0 sp3 and SQL2005 server.
Kindly share your experience, thanks.
rgds,
Ray
0
Comments
A flowfield reads data from the SIFT table, not from the base table.
You are probably running a NAV build which has a bug in the SQL trigger which creates the SIFT entries. To fix this ONCE go into the item ledger entries and disbale all "Maintain SIFT" in all Keys and save the object. In a second step enable them again. Depending on the number of records in your table this might take a while.
Thios topic has been discussed in the Forum several times. Please use the search function.
To fix this once and for all you will need to update the Exe to a newer version. For a list of available build take a look here:
http://dynamicsuser.net/blogs/waldo/archive/2009/12/22/platform-updates-overview-3-70-b-nav2009-sp1-updated-2.aspx
FD Consulting