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
- 296 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
Interesting Inventory (Item field) calculation
Tomas
Member Posts: 420
NAV5, SQL2005.
Basically, let's say we have Item A.
On Item card, there is a field Inventory - where you get sum of Item Ledger Entries field Remaining Quantity.
On Item A the field Inventory is -100. When we drill down, we see two entries:
1. purchase receipt for 100.
2. sales shipment for -100.
Both entries are not Open, and Fully Invoiced.
Any ideas on why it can happen?
Furthermore, if I create a backup and restore it on Native database, Inventory field on Item card becomes 0 (instead of -100).
I thought I would share interesting question.
Basically, let's say we have Item A.
On Item card, there is a field Inventory - where you get sum of Item Ledger Entries field Remaining Quantity.
On Item A the field Inventory is -100. When we drill down, we see two entries:
1. purchase receipt for 100.
2. sales shipment for -100.
Both entries are not Open, and Fully Invoiced.
Any ideas on why it can happen?
Furthermore, if I create a backup and restore it on Native database, Inventory field on Item card becomes 0 (instead of -100).
I thought I would share interesting question.
Tomas,
Dynamics NAV Enthusiast
Dynamics NAV Enthusiast
0
Comments
At least you'll be sure where the problem is...
Adam, no, there are no warehouse entries.
Dynamics NAV Enthusiast
Disabling/enabling keys with sumindexfields resolved the issue. However, I am still looking why did it happen in the first place.
Dynamics NAV Enthusiast
BTW, the "Inventory" flowfield sums up the quantity in the ILE, not the remaining quantity. Of course , the sum should normally be equal.
We are on 4 SP2. A technical upgrade to 5SP1 is scheduled.
Is there a hotfix for our version of Navision as well? It would be great if this issue could get fixed as soon as possible.
Thank you
For a description why it happened look here:
http://www.mibuso.com/forum/viewtopic.php?f=33&t=19387
For a list of the latest available clients look here:
http://dynamicsuser.net/blogs/waldo/archive/2008/09/13/platform-updates-overview-3-70-b-nav2009-ctp4.aspx
But be warned: MS did change lots of other things in the updates - which might decrease performance. For a discussion about SP3 Update 6 look here:
http://www.mibuso.com/forum/viewtopic.php?t=20831&highlight=
Using the latest 4.0 SP3 Update6.10 should be fine. You might want to disable index hinting though.
Always test on a test system first before going live!
FD Consulting