Item Tracking Problem

uto
uto Member Posts: 36
edited 2009-06-04 in Navision Attain
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.

Comments

  • kapamarou
    kapamarou Member Posts: 1,152
    When you drill down are any additional filters applied?
  • uto
    uto Member Posts: 36
    kapamarou wrote:
    When you drill down are any additional filters applied?

    Thank you, Kapamarou.

    There's not additional filter applied.
  • DaveT
    DaveT Member Posts: 1,039
    Hi,

    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.
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html
  • uto
    uto Member Posts: 36
    Hi DaveT,

    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.

Categories