A line on an order got FUBAR’d during a DMT import, and I can’t figure out how to fix it.
There is a line in the order line that specifies a P/N in with a UOMClassID that is not compatible with the UOM’s in the OrderDtl and OrderRel records.
The parts UOMClassID is WEIGHT, while the UOMS on the OrderDtl and OrderRel records are EA
I tried using DMT to change the UOMS on the OrderDtl and OrderRel to LB (which is in the WEIGHT class). But DMT fails, stating that “EA” is not of the class WEIGHT.
I’ve also tried deleting the release, and deleting the line, but both fail as well.
I had the same issue, but with a purchase order. Epicor sent me a fix to close the PO, Line, & Release since everything else we tried failed. We were unable to add EA to Weight as it is in another UOM class. Updateable BAQs error out the same as DMT errored out.
If the reason you cannot delete the release is due to it being linked to a job, just remove that link, create a new release re-link using the correct UM and then delete the bad release. We have that same issue about once quarter. Not sure why but it usually gets caught during the shipping process of generating a packing slip. If it is a stock item then I am unsure of a solution.