Hi All,
Does anyone out there know which tables the in-transit stock report pulls it’s information from? We’ve had a few transfers get hung up in transit due to a make direct functionality, and Epicor doesn’t allow us to do anything with them. I already tried going into our database and writing a SQL query to remove the transfer and packID completely, but it doesn’t delete it from this report.
The Transfer Order Shipment tables are TFShipHead and TFShipDtl.
@Ernie That’s what I thought. So I tried running a “drop” for the transfer order number. The transfer orders are now non existent, but the information still shows up on the in transit stock report…
You can use PlantTran to see what’s “Open”. These transactions happen after “Shipped” is marked on the TO Shipment.
Doug, I was trying to remember the table haha and I didn’t have time to dig in. Glad you brought it up!
That worked! Thank you! 