Quantity split happens during Transfer

dynamics_prasanth

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.

ufuk

Do you track serial no or lot?

dynamics_prasanth

Yes, we are using Lot No for Item Tracking.

ufuk

Could lot tracking be the reason of line splitting? (Creating line per lot)

kine

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!

dynamics_prasanth

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

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.

dynamics_prasanth

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

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.