summarized Remaining Quantity differs "sometimes" from summarized Quantity in Item Ledger Entry

gycsiak
Member Posts: 19
Hi all,
Using CU23 of Dynamics NAV 2017 I have come across the problem, which I couldn't reproduce even with the Item No. that has got the problem with Item Ledger Entry.
The problem is, that in some unidentified cases, the Remaining Quantity seems to differ from Quantity, when summarized and so the items with this problem are throwing error, when inside a Shipment or Invoice document and the user tries to post the document.
I have written a short SQL script, just to double-check which Items are having this problem, and this shows a low count of different items, where the Quantity differs from Remaining Quantity. We are talking about a live company with over 45 000 records in Item table (!!!), and the result displays at the moment 8 different items, but still it is unclear, how this can happen.
I have gone through all the Where-Used information regarding Remaining Quantity, I have created flow-charts and call-stack graphs regarding the complete item ledger entry creation and modification process, checked customizations and standard code as well, checked available cumulative updates also, have discussed this story with senior consultants, but no answer, so I am turning to this Community, in hope of a usefull answer to be received.
How come, this can be happening? How to avoid it? If there is a hotfix or cumulative update fix for this, please let me know!
Thank you in advance,
Best regards,
Gyula
Using CU23 of Dynamics NAV 2017 I have come across the problem, which I couldn't reproduce even with the Item No. that has got the problem with Item Ledger Entry.
The problem is, that in some unidentified cases, the Remaining Quantity seems to differ from Quantity, when summarized and so the items with this problem are throwing error, when inside a Shipment or Invoice document and the user tries to post the document.
I have written a short SQL script, just to double-check which Items are having this problem, and this shows a low count of different items, where the Quantity differs from Remaining Quantity. We are talking about a live company with over 45 000 records in Item table (!!!), and the result displays at the moment 8 different items, but still it is unclear, how this can happen.
SELECT SUM([Quantity]) as Quantity,SUM([Remaining Quantity]) as [Remaining Quantity],[Location Code],[Item No_] FROM [dbo].[Cronus$Item Ledger Entry] group by [Location Code],[Item No_] HAVING SUM([Quantity])<>SUM([Remaining Quantity]) order by [Location Code],[Item No_]
I have gone through all the Where-Used information regarding Remaining Quantity, I have created flow-charts and call-stack graphs regarding the complete item ledger entry creation and modification process, checked customizations and standard code as well, checked available cumulative updates also, have discussed this story with senior consultants, but no answer, so I am turning to this Community, in hope of a usefull answer to be received.
How come, this can be happening? How to avoid it? If there is a hotfix or cumulative update fix for this, please let me know!
Thank you in advance,
Best regards,
Gyula
0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions