# DMT and Line Sequence Advice

**Category:** [Epicor ERP 10](https://www.epiusers.help/c/e10/5)
**Created:** 2016-10-31 18:21 UTC
**Views:** 991
**Replies:** 2
**URL:** https://www.epiusers.help/t/dmt-and-line-sequence-advice/36026

---

## Post #1 by @ckrusen

This isn't as much a question , as it is just a chance to vent.  And hopefully someone else will find it useful before finding it the hard way.

When creating new PO Details, if a line fails, the remaining POLine's created won't match the input data.

For example, if the following was the input data for DMT

    PONum  POLine   Description  TranType
    1000   1        Widget A     PUR-UKN
    1000   2        Widget B     PUR-UKN
    1000   3        Widget C     PUR-UKN
    1000   4        Widget D     PUR-UKN


At the time the PO 1000 was created, Widget C was a part on the fly, but has since been made a stocked part.  So Line 3 will fail.

DMT keeps processing and Line 4 becomes Line 3.  Querying the db after DMT is done shows:

    PONum  POLine   Description  TranType
    1000   1        Widget A     PUR-UKN
    1000   2        Widget B     PUR-UKN
    1000   3        Widget D     PUR-UKN


Fixing Line 3 and attempting to upload the following doesn't do what you'd think

    PONum  POLine   Description  TranType
    1000   3        Widget C     PUR-STK
    1000   4        Widget D     PUR-UKN

DMT, will give an error as it won't change line 3.  It will continue and create line 4

The only solution appears to be deleting all the lines for the PO (or at least back to the first "wrong one"), and then adding the missing lines back in.  If any errors occur, you'l probably have to delete all lines for the PO and start again.

---

## Post #2 by @gpayne

I got around this type of issue by having a query in the same workbook for all parts that now exist in the destination part master and using vlookup to set the field.

I found that I had to do quite a few data changes before I was ready to import.

Greg

---

## Post #3 by @ckrusen

Pretty much what I did.  Many iterations of upload, check, fix, delete, rinse , repeat ...

---


**Canonical:** https://www.epiusers.help/t/dmt-and-line-sequence-advice/36026
**Original content:** https://www.epiusers.help/t/dmt-and-line-sequence-advice/36026