Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Marguerite Manelski]

We are trying to receive a transfer for 247,000 pcs.  Everything appears to have posted correctly.

Lot A – 79,290
Lot B – 167,710

Problem is that when trying to receive the receipt is showing 

Lot A – 79,290
Lot B – 88,420 (79,290 less than shipped)

I do not want to process further and cause a greater problem.  (We have done this in the past and the balance goes MIA and we are unable to receive, thus having to have our partner find it and receive it in the background.)  Trying to figure out not only how to fix this issue but what is happening and why.

——————————
Marguerite Manelski
Purchasing Agent
American Ring
Solon, OH
**Great Lakes Chapter Member**
——————————

[Lewis Rosenberg]

?Marguerite, 

I can sympathize!   I have seen my share of crazy things concerning lot controlled inventory.  I wish I had an answer for you.  Hopefully some questions might lead to something.

* What version of NAV?
* How much inventory does NAV show in your INTRANSIT location?
* How is your ship-from location defined (ex: directed putaway & pick, require ship, etc.)?
* How is your receive into location defined?
* What is your process?  When was item tracking applied – on the Transfer Order, the shipment, or pick? (depends on how your ship-from location is defined)
* Do you know what your partner has done in the past to fix the inventory?

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-

[Marguerite Manelski]

Lewis,

* We are on 2015, cumulative update 37.
* We had the full 247,000, though now there are only 79,290, in-transit.  (Someone processed what they could).
* Both locations are set up as Directed Put-Away & Pick 
* We use FIFO so the lots will be defined once the pick is created.  In this case all stock from one location was transferred to another.  
* Unfortunately, I have no idea what our partner has done in the past to fix this issue and I am trying to figure out why it happens and how to keep it from happening.  

This does seem to  happen more when we ship from this particular location so not sure if there is something with the set up or how they process transfers.

——————————
Marguerite Manelski
Purchasing Agent
American Ring
Solon, OH
**Great Lakes Chapter Member**
——————————
——————————————-

[Matt Dunaj]

I’ve had this same issue and could never get a satisfying answer as to why it was happening, but I do think that we found a solution. We changed the “Reserve” field in the Planning section on the Item Card to “Never.” The system was having issues transferring the reservation entries from the ship-from location to the transit location, and this does seem to have prevented it from happening again.

We use lot code tracking, and we manually assign lot codes on all documents. We’re not using automatic reservation functionality that would be activated with the “Always” option on the Reserve field on the Item Card, so if you are using that functionality then you may need to find another solution.

There’s this Hotfix for NAV 2009, but we are on NAV 2016 and still had the error.
https://support.microsoft.com/en-us/help/2536288/you-receive-an-error-message-when-you-try-to-post-a-transfer-order-lin

For any transactions that you do have hanging, your partner will need to go in and manually create reservation entries in order to post the receipt.

Good luck!

——————————
Matt Dunaj
Director of Accounting
Earth Island/Follow Your Heart
Chatsworth CA
——————————
——————————————-

[Val Gameiro]

It sounds like the shipping side of the transfer order was short shipped.

I would expect the normal process to be Receive the quantity transferred so far, then ship the remainder and receive that separately.

The lots should end up with the correct quantities, but you’ll have to pick 2 lines for one of the lots when you try to sell/etc.

——————————
Val Gameiro
Senior NAV Analyst
BPL Plasma
Austin, Texas
——————————
——————————————-

[Astur Iano]

Marguerite, welcome to the wonderful world of Reservation Entries and Lot Entries.
Be ready for great pain 🙂
The main problem is that when you setup an item with “Order Tracking Policy” with Tracking Only orTracking & Action Msg., Navision starts generating “soft” reservations using table “Reservation Entry”. A soft reservation is a link between a supply and a demand (i.e. a purchase order with a sale order, or an on-hand stock with a sale order).
This links recorded in table Reservation Entry are dynamically changed if new transactions arise.
The problem is that this “dynamically change” is not managed correctly by Navision when using Lot Tracking and unfortunately this happens sometimes, but some other times it works well (making the issue even worse to find).
With warehouse transfers Navision misses even more.
Just a trick I propose you to investigate: go to Reservation Entry table and filter by Transfer Order Number and check LOT NO. field. I bet you some of those entries are blanked.
Good luck and please do not touch any table directly if you are not absolutely sure of what are you doing (do not imitate me 🙂

——————————
Astur Iano
PKVEN
——————————
——————————————-