Item Tracking Summary - wrong Total Quantity
Datapac
Member Posts: 97
Nav 4.0 SP2
2 Adjustment in stock of ItemA into location XX
Lot No Quantity
LOT123 138
LOT123 65
Item Card Inventory is correct (203)
Item Ledger Entries are correct
Item Tracking Entries are correct, remaining amount is 138 & 65
Created a Sales Order for ItemA, Qty 203, Location XX
When I go to Item Tracking Lines and use Assist Edit to bring up available Lots, LOT123 appears in the Item Tracking Summary form but with Total Quantity = 138.
Is this a bug or am I missing something? I'd imagine it should be 203?
I've seen some similar posts but no answers that help me out.
Thanks,
Richie
2 Adjustment in stock of ItemA into location XX
Lot No Quantity
LOT123 138
LOT123 65
Item Card Inventory is correct (203)
Item Ledger Entries are correct
Item Tracking Entries are correct, remaining amount is 138 & 65
Created a Sales Order for ItemA, Qty 203, Location XX
When I go to Item Tracking Lines and use Assist Edit to bring up available Lots, LOT123 appears in the Item Tracking Summary form but with Total Quantity = 138.
Is this a bug or am I missing something? I'd imagine it should be 203?
I've seen some similar posts but no answers that help me out.
Thanks,
Richie
0
Answers
-
I've debugged this and the problem line seems to be the following check in Codeunit 6500 Item Tracking Management, Function AssistEditLotSerialNo :
IF NOT TempReservEntry.FIND('-') THEN BEGIN
I've commented out this check and the corrresponding END statement and now the Total Quantity is correct as is the drilldown on this field.
I need to do further testing to see the impact of this change but it looks initially like a standard bug.0 -
Please check, when you will apply the reservation this may give you a problem.Mukesh Sharma0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions