Quantity split happens during Transfer

dynamics_prasanth
dynamics_prasanth Member Posts: 153
edited 2010-10-21 in NAV/Navision Classic Client
Dear Friends,

I have a scenario.
While transfering items from one location to another using Item reclass journal, the entered quantity gets splitted. This was noted while trying to select this entry for consumption.
In short, a single transfer entry is shown as multiple entries.

What could be wrong [-o< ?

Thanks in Advance.

Comments

  • ufuk
    ufuk Member Posts: 514
    Do you track serial no or lot?
    Ufuk Asci
    Pargesoft
  • dynamics_prasanth
    dynamics_prasanth Member Posts: 153
    Yes, we are using Lot No for Item Tracking.
  • ufuk
    ufuk Member Posts: 514
    Could lot tracking be the reason of line splitting? (Creating line per lot)
    Ufuk Asci
    Pargesoft
  • kine
    kine Member Posts: 12,562
    All depends on costing method. If you e.g. "join" two lots, every transfer of this lot will be made by two entries which each is related to the original lot before join. This is common and you NEVER should expect that there will be only one entry for one movement of inventory!
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • dynamics_prasanth
    dynamics_prasanth Member Posts: 153
    But there is only one Lot involved.
    In item reclass we will select the Purchase entry using "Applies to Entry"and the Lot No of the purchase transaction will be selected from Lines > Item Tracking Lines, for the Item Journal.
    But the transfered quantity is splitted into two entries.
    Suppose if there is 250 Kg of Product X with a single lot no, then during transfer, two entries are getting generated. one with 200 kg and the other with 50Kg, both with same Lot No.
  • FDickschat
    FDickschat Member Posts: 380
    As NAV keeps track on remaining qties per ILE it can easily happen that during any outgoing transaction more than 1 ILE is created.

    Assume you have 2 purchases 200 pcs and 200 pcs. Next you sold 100 pcs and then transfer 200 pcs. The result is exactly what you saw. As kine already said, NEVER expect that there will be only 1 entry!

    This behavíour is of course depending on the Costing Method of the item.
    Frank Dickschat
    FD Consulting
  • dynamics_prasanth
    dynamics_prasanth Member Posts: 153
    Thanks to all. But there are 5 different companies created in the same database and this is happening only with a particular company. The costing methods used across these companies are the same. ](*,)
  • Andwian
    Andwian Member Posts: 627
    When I browse this forum, this issue has been reported many times, and come to the conclusion that this is a normal behavior at all.
    Regards,
    Andwian

Categories