How to link the warehouse entries with Item ledger entries?

gdkve9
gdkve9 Member Posts: 161
edited 2010-05-11 in NAV/Navision Classic Client
Hello everyone..

Advance regards for sharing your thoughts.

The situation where we stuck is here below.

In the Item tracking code we have used for all the items so far, On the Item Tracking Code Card, on the Lot No. tab, Lot Warehouse tracking is unchecked. Hence the warehouse entries have generated without lot no. Now the client wants to look into the lot nos. with bin specific which I guess would only be possible if we update the warehouse entries with Lot.

For this, I am tring to find a unique relation between the Item Ledger entry and Warehouse entry and here I am stuck. Would be very grateful if someone could suggest on how to update the warehouse entries with lot no. based on Item ledger entry or if any other possiblity which would solve my purpose.

Thank u all.
Dilip
Falling down is not a defeat..defeat is when you refuse to get up.

Comments

  • chengalasettyvsrao
    chengalasettyvsrao Member Posts: 711
    when you do any transactions with Bin then system will update the ware House entry - 7312.

    But this table does not have the ILE relation.

    But you have the Reference document type and reference document No .

    So it may be helpful to you.
  • matttrax
    matttrax Member Posts: 2,309
    Item Ledger Entries contain financial information. Warehouse Entries don't. Also most places don't track their inventory by lot / serial so you never have an idea of what specific inventory you're moving at any given time. Thus there is no direct relation between the two.

    You can try going through all of the documents, linking them together, but that will be a lot of work and not a guaranteed result.
    Matt Traxinger - ArcherPoint
  • gdkve9
    gdkve9 Member Posts: 161
    chengalasettyvsrao wrote:
    But you have the Reference document type and reference document No.
    Thanks sriniavas but this will not work for me. I was looking for a unique relation between these tables.
    mattrax wrote:
    You can try going through all of the documents, linking them together, but that will be a lot of work and not a guaranteed result.
    Thanks Mattrax. Hope this should work but seems very tedious.

    Any simplier solution :-k
    Dilip
    Falling down is not a defeat..defeat is when you refuse to get up.
  • chengalasettyvsrao
    chengalasettyvsrao Member Posts: 711
    The Reference document type and reference document No will update in ILE also when you do any transaction..
  • dspasov
    dspasov Member Posts: 33
    edited 2010-05-12
    Hi,
    I`m sure but you could try these relations:
    "Item Ledger Entry"."Entry No." = "Item Entry Relation"."Item Entry No."
    "Item Entry Relation"."Order No." = "Warehouse Entry"."Source No."
    "Item Entry Relation"."Order Line No." = "Warehouse Entry"."Source Line No."

    It is not covering on 100% because of splitting lines when do tracking but is near
  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    You can link it using document number.
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book

Categories