This may be a long shot, but arrange your required data columns in the same order as the way the DMT suggests. The DMT lists the columns like this: Company, Plant, PartNum, TransferQty, FromWarehouseCode, FromBinNum, ToWarehouseCode, ToBinNum.
I have seen data not get processed if it is not in the order DMT suggests.
@CG2 I know this is an old post but I ran across it when looking for an answer to the same question. I think it’s actually (in my case) simply concerning the time it takes to update the database. I am moving about 200 parts and this has happened before:
create bin locations by DMT
set primary bins by DMT
use SQL to generate the DMT to move parts from current bin to newly created and named primary bin
transfer fails with “No warehouse left to assign” on all items
wait 2 or 3 minutes and try again, in defiance of Einstein’s definition of insanity
transfer happily works with no errors
I came back here to write it down partly in case it helps but mostly because I’ll hopefully remember it better next time for having written it
Created Templates from DMT, so they were good. I managed to make it work by using a different Epicor account (doesn’t make sense but that what did it for me)
Previously, I was using the Manager account)
another thing I do is split my DMT in two when there is a persistent failure. Often I find one row is jacking up and the error takes long enough to time out that all subsequent rows fail. Sometimes splitting it lets half complete, then I split the remainder, etc.
Thank you for coming back to this one, @SteveFossey. I had the same “No warehouse left to assign” issue today. Found this thread, tried again without making any changes, and the whole thing uploaded successfully. Weird.