# QuoteMtl MtlSeq changes when importing via DMT

**Category:** [Epicor ERP 10](https://www.epiusers.help/c/e10/5)
**Created:** 2016-10-20 16:00 UTC
**Views:** 2624
**Replies:** 23
**URL:** https://www.epiusers.help/t/quotemtl-mtlseq-changes-when-importing-via-dmt/35900

---

## Post #1 by @ckrusen

I understand that DMT uses the business object to create new records and that end up overriding imported data.

There's a work around for this, for things like QuoteDtl.QuoteLine - as they are always incremented by 1.

DMT aut assigns QuoteMtl.MtlSeq, but with a step of 10.  This prevents "fixing" data if you have a MtlSeq that is not a multiple of 10.

V8!QuoteMtl.MtlSeq = 35 become 40 in E10.  And if the next record from V8 happened to be 40, then that overwrites original 35.

What to do?  Or am I worrying about nothing and should just let the new numbers fall where they may?

Calvin

---

## Post #2 by @josecgomez

MTL Sequence can be set in DMT so I am not sure what you are refering to here... If you set the MTL Sequence to number X it should honor it.

---

## Post #3 by @ckrusen

Here's what was in the input file

<img src="/uploads/default/original/1X/2c9d61a035ae2a3ceb1d3e307cc4307a822dc135.png" width="555" height="221">

And here's what ends up in E10 DB

<img src="/uploads/default/original/1X/4d9aee1c193f671cbeb76859942c45f3df91629e.png" width="644" height="221">

MtlSeq 35 becomes 40, 61 -> 70, 62 -> 80, 100-> 90

---

## Post #4 by @josecgomez

That's strange.... Try and run the same file again (now as an update)

---

## Post #5 by @ckrusen

Remove the records from E10 first?

---

## Post #6 by @josecgomez

No, run the initial file again (now that the records are there) and run it as an Update.

---

## Post #7 by @ckrusen

Okay. Here's what i've done

1. Removed all ecords for the QuoteNum\QuoteLine\Assy in question.  Confirmed that E10 has no records for 159200\1\0
2. Processed the following - with both Add and Update checked
<img src="/uploads/default/original/1X/569a6333e3bdcd6738b0289884b230639924f71e.png" width="427" height="221">

3. Qry'd E10 for 159200\1\0.  I get
<img src="/uploads/default/original/1X/5a677f2e6ee57851a9193fad02b08afbb9f5d582.png" width="552" height="221">

4. With the same data in DMT, ran the process with just UPDATE checked.  Got 4 errors
<img src="/uploads/default/original/1X/68abc236f2d7c934ea717e01fde80ac2b34bfcbd.png" width="537" height="139">

5. Qry'd E10 for 159200\1\0.  I get (note that there's an extra line now.
<img src="/uploads/default/original/1X/f6fb542f6416beee11dad40f33b3728df0f6f371.png" width="552" height="221">

**EDIT: No extra line, but 100 was redifined**

---

## Post #8 by @josecgomez

Hmmm that seems like a bug then it should allow for changing the MTL Sequence... Epicor does... (you are on 8.03 though so maybe not)... maybe @Edge has some input on this?

---

## Post #9 by @ckrusen

The source data is from 8.03.  

The DMT program is "DMT 4.0.12.4 for 10.1.400"

---

## Post #10 by @josecgomez

How about doing the initial import again as Add Only so that SEQ 35 becomes SEQ 40 and SEQ 40 (should become 50)?

---

## Post #11 by @ckrusen

6. Ran "Add" with data from step 2 (above).  Got 7 errors 
<img src="/uploads/default/original/1X/6327e09a5b6fd65da3b37901ce7cd827b22bdc4f.png" width="339" height="180">

7. qry'd E10 and got 3 more lines (35 -> 110, 61->120, 62 -> 130)

<img src="/uploads/default/original/1X/f7b0ab93e7dcc888045728bd8073e9183482f572.png" width="633" height="281">

---

## Post #12 by @josecgomez

Yeah but you need to "Clean' the system first so that no data exits. Then Import with Add Only


I think then it should  make 35-> 40 and 40 -> 50 etc..

---

## Post #13 by @ckrusen

1. Deleted  all related records - confirmed by querying E10

2. Processed original data with just "Add" checked.  No errors
<img src="/uploads/default/original/1X/6a01ccf4fec8d03ae44517450c1533ebb92feaa5.png" width="427" height="221">


3. Qry of E10 yields same problem (MtlSeq replaced 
<img src="/uploads/default/original/1X/41e6334ee667c6761f60067a0809f7ce2286a470.png" width="552" height="221">

---

## Post #14 by @josecgomez

Hmmm Add only shouldn't be replacing.... that smells like a bug. Poke at Support?

---

## Post #15 by @ckrusen

Email address for DMT support?

---

## Post #16 by @josecgomez

DMT == Epicor just called the main number

---

## Post #17 by @ckrusen

Last time I called Epicor about a DMT question, I was directed to DotNet.uk (or something like that)

---

## Post #18 by @josecgomez

Right but epicor bought DMT and DotNet IT and they are now a part of Epicor (main)

---

## Post #19 by @ckrusen

Hmmmm .... Are you sure that you can change the MtlSeq in a Quote?  

Using Actions \ Quote Line \ Mfg Details \ Add Material  auto sets the MtlSeq. to 10 above the last item.

I even tried using Paste update into the grid view, with:
<img src="/uploads/default/original/1X/fd2b51b274b91dff626a2655241aede2e5251de8.png" width="257" height="21">


But the MtlSeq ends up being changed to a multiple of 10.
<img src="/uploads/default/original/1X/0ddf7ff9d82057757d9d28a6f0d1bf1dae90bdf2.png" width="494" height="46">

---

## Post #20 by @josecgomez

You can in 10
You have to add the material, then Update the Number

---

## Post #21 by @ckrusen

I tried that earlier.  I did:
1. Add Material (the Mtl Seq is automatically set to then ext multiple of 10 above the highest)
2. Changed the MtlSeq number (was 110 to 61)
3. Entered the Materials P/N and Qty
4. Saved

Upon saving the MtlSeq reverts back to 110.

---

## Post #22 by @josecgomez

Something is up with your setup then... I can change the MTL Sequence all day long see below

Original
<img src="/uploads/default/original/1X/4af8d6e08ec0869c09fb34389fe178c093f48617.png" width="616" height="342">
Change it, Hit Save
<img src="/uploads/default/original/1X/872b13b9a47a530bcaa17411333fdd4c1cbefa46.png" width="533" height="291">

Refresh
<img src="/uploads/default/original/1X/919d24766d620748f38e60268ea12404930abffb.png" width="588" height="355">

Version 10.1.400.18

---

## Post #23 by @ckrusen

That is **JobEntry**.  I'm taking about during **Quote Entry**

---

## Post #24 by @josecgomez

Well hot damn we both need to pay better attention haha
So yeah Ignore the last like 10 replies.... It doesn't allow gaps between those records sorry... **I'll go sit in the corner now**
<img src="/uploads/default/original/1X/ff77dcee618917b37898cf627803ae10a83a4839.jpg" width="270" height="299">

---


**Canonical:** https://www.epiusers.help/t/quotemtl-mtlseq-changes-when-importing-via-dmt/35900
**Original content:** https://www.epiusers.help/t/quotemtl-mtlseq-changes-when-importing-via-dmt/35900