Transfer Order Shipment In Transit

Epicor ERP 10
,
1

Hey all!
We are multi-site and use transfer orders to send material back and forth between sites. What’s the best way to find TO lines that are “in transit” using a BAQ? I am not seeing a status that would correlate with that. I hope I’m just missing something easy.

Thanks,
Dan

2

Bah. I think I figured it out. I just need to look at TFOrdDtl and TFOrdHead. I was filtering based on Open Line and Open TO and I think the Line closes when it’s shipped… but the Order remains open until all lines are received… does that sound right?

1 Like
3

There is a table called Erp.PlantTran.

image
image1244×190 9.43 KB

1 Like
4

I don’t know if it is due to bugs or our own process or not, but there are sometimes discrepancies between PLantTran and the results I get doing what you were originally doing with TFOrdDtl and TFOrdHead or TFShiphead and TFShipDtl

1 Like
5

And yeah, plant tran has a transtatus field that says open or closed.

image
image1609×185 10.4 KB

6

Good stuff. Thanks for pointing this out. It might actually answer a different question that I had bouncing around in my head. I was seeing an extra transaction in SNTran that was not lining up with one in PartTran. It was related to when we transferred a serial tracked part from plant to plant. It was like this weird transaction that was “closing” the transfer order but didn’t show up on PartTran. I wonder if this is where it was coming from.