What causes a part to be moved to Internal Order Transit?

There are other details related to the Inventory Transaction that will help with this.  Internal Order Transit is an in between area for site to site transactions.  The transaction is occurring by a person not an order, so have you found out which user is doing the transaction and trace out what steps they are doing?  

Site

User

Inventory Location

All of those details should be connected to each transaction as well as the underlying financial postings which should allow backtracing how things are getting there.  Order will only come into play for this transaction if it is initiated through the intersite process using connected customer order and purchase orders between sites.

Intersite setup between sites

Transport tasks between sites

Move to Location where the locations are between sites

Issue to a shop order with part from another site directly

….might be others, I don’t know where there is a definitive list actually.

Hi @hmccabe,

This INTORDTR - Move to Internal Order Transit due to issue transaction is posted due to an increase in the qty of the certain part in the Internal Order Transit. As explained above also, this increase of qty in Internal order Transit is happened due to inter-site movements through internal orders.

When the qty of part is delivered from the delivering site through the internal customer order, SHIPTRAN - Ship Customer Order Internal Transit transaction is posted. And that qty is delivered to the Internal order Transit, so the qty in the Internal Order Transit is increased by that amount and the INTORDTR - Move to Internal Order Transit due to issue transaction is posted at the same time (Created Date and Created Time is same in the inventory transactions). But, the INTORDTR transaction does not contain an order reference or location because it is just an increase in the transit, not in the inventory stock, and that’s why its direction is also 0.

And when that qty is received through the internal PO, we have the ARRTRAN - Arrival Inventory Internal Transit transaction. But, we can receive qty as partial qty at different times or also we can receive qty taken into transit from other orders as well, and that’s why transit qty and INTORDTR transaction does not contain order reference.

So, the SHIPTRAN, INTORDTR and ARRTRAN transactions are connected to each other, but not the ARRTRAN transaction not necessarily, because internal PO receipt can be received from the transit at partial quantities and from other lot/batches.

If you want to track the INTORDTR transaction on from which internal CO, that has been posted, you can search for the Created  Date and Created Time for the same part, and qty and lot batch number (if any) in that INTORDTR transaction, and you’ll get the related SHIPTRAN transaction which contains the internal CO number.

Hope this helps.

Thanks,

@hmccabe 

When I had to go through cleaning this up, I first determined which items were real inventory that was physically between sites and hand had a valid PO waiting to be received on the demand end of the trail.  I separated these out and made sure the folks doing the receiving used the right RMB function to do the receipt so they didn’t extend the problem.

Then I created a financial project that was the same on both sites so that I could use that as part of the cleanup.  (I actually had 4 sites that were mixed together, so four projects, but you get the idea).

I then took the list of remaining parts that I suspected were wrong and made both sites do a physical inventory of those parts in both sites (not on system, but on a spreadsheet), that gave me an idea of which way the inventory needed to go and what to do with it when it got there.  Was I receiving phantom inventory that had already been used or was I receiving real inventory that was putting the count back to right?  It matters in the cleanup.

Then I went through part by part and typically created a dummy PO to receive the part then issued it out to the project.  Sometimes after receiving in one site, I had to just move it back to the originating site, it just depended on where my count was off and what my final good count was in each site.  I was careful not to just scrap these parts because then I couldn’t keep track of what was done in which site.  

When I finished going through all of the parts and cleaning them up, I tallied the cost of the ‘lost’ parts and turned it over to finance, it was over $80K worth of parts.  That got enough attention that the various managers paid more attention to the process and I turned it over to a cost/inventory accountant who was responsible for monitoring and making sure inventory didn’t sit there more than a week or 10 days.  

The one complaint I have is the Inventory in Internal Transit overview doesn’t contain date or order information, so it is super difficult to trace the problem ones.  I created a quick report that traced the items back to the last inventory transaction from the same site with the same quantity to help monitor.

The sad thing is….writing this reply made me go look and realize that the person who was supposed to monitor this has left the company and no one is doing it now, so I see a large mess in ours again.  

Ignorance is bliss…...

When parts are delivered on an Inter-Site customer order, are the quantities in the Inventory Part in Internal Order Transit always increased by the delivery quantity?

Yes

And do all of the Inter-Site PO Lines have to be received from Internal Order Transit? 

Yes

In other words, is there a scenario where delivering lines on an Inter-Site customer order will not affect the Internal Order Transit quantities? 

No, not if you want to do it correctly