Howdy, Stranger!
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
- 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
- 305 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Item Tracking Problem
uto
Member Posts: 36
I have problem about Item Tracking which tracking by Serial&LOT.
The problem is :-
User would like to issue Sales Order with this item, let say ItemA. When she select this item on Sales Line and try to select LOT/Serial on the Item tracking Line. There's something quite surprised.
On the Item Tracking Summary of this item display the Total Quantity is 3. (Picture1) But when I try to drilldown into Item Tracking Line, it's display just only 2 records (Picture2).
What's wrong? What should I do?
Any comment, pls let me know.
Thank you.
The problem is :-
User would like to issue Sales Order with this item, let say ItemA. When she select this item on Sales Line and try to select LOT/Serial on the Item tracking Line. There's something quite surprised.
On the Item Tracking Summary of this item display the Total Quantity is 3. (Picture1) But when I try to drilldown into Item Tracking Line, it's display just only 2 records (Picture2).
What's wrong? What should I do?
Any comment, pls let me know.
Thank you.
0
Comments
Thank you, Kapamarou.
There's not additional filter applied.
This is not a standard flowfield drilldown - there is code in the Item Tracking Summary form. This is looking at Surplus reservation entries only. Have a look at your reservation entries for the item in question for a full picture.
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html
Thank you for ur comment.
I tried to check in the reservation entry table for this item, but there's no record found.
I also check in the Tracking Specification as well, there are many records from unpost documents. (or shipped/received but not invoiced)
BTW, I noticed that :-
In the Item Ledger Entry table, there is only 1 record for this item which has positive to inventory, but there are 3 records which transfer this item (same serial/lot) from the same location.
Example :-
27/04/2009 :
Entry Type = Purchase
Lot/Serial = 270409/5200307
Qty = 1
Location = Factory
30/04/2009
Entry Type = Transfer
Lot/Serial = 270409/5200307
Qty = -1
Location = Factory to Office
09/05/2009
Entry Type = Transfer
Lot/Serial = 270409/5200307
Qty = -1
Location = Factory to Office
11/05/2009
Entry Type = Transfer
Lot/Serial = 270409/5200307
Qty = -1
Location = Factory to Office
12/05/2009
Entry Type = Transfer
Lot/Serial = 270409/5200307
Qty = -1
Location = Factory to Office
Even this item has tracking by Serial. And the Item Tracking Card already check "SN Specific Tracking".
Sorry, on my first post, I told u that this item has tracking by Serial&LOT. Actually, it's tracking by Serial only.
I'm quite confused that how's it happened.