# DMT null value

**URL:** <https://www.epiusers.help/t/dmt-null-value/74770>\
**Category:** Epicor ERP 10\
**Tags:** dmt, e10\
**Created:** [January 22, 2021, 1:11pm UTC](https://www.epiusers.help/t/dmt-null-value/74770 "2021-01-22T13:11:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![psiebers](https://www.epiusers.help/user_avatar/www.epiusers.help/psiebers/32/8715_2.png) [@psiebers](https://www.epiusers.help/u/psiebers)\
**Post date:** [January 22, 2021, 1:11pm UTC](https://www.epiusers.help/t/dmt-null-value/74770/1 "2021-01-22T13:11:55Z")

</div>

Just a quick DMT question. Hopefully someone has figured this out: I have two fields in the parts table with incorrect values for most parts: SchedBCode and Country. How do I blank those out and leave empty/null in a DMT? I tried with nothing between the comma’s, but that doesn’t change the value of those fields.

Thanks!

---

<div class="post-metadata">

**Author:** ![Doug.C](https://www.epiusers.help/user_avatar/www.epiusers.help/doug.c/32/26714_2.png) [@Doug.C](https://www.epiusers.help/u/Doug.C)\
**Post date:** [January 22, 2021, 2:07pm UTC](https://www.epiusers.help/t/dmt-null-value/74770/2 "2021-01-22T14:07:20Z")

</div>

If you go into Part Entry, and try to blank out the Country of Origin field, you get the following error:

![image](https://www.epiusers.help/uploads/default/original/3X/3/3/33005bf8dcda44de3e765c3c8bafec3ad0a3f231.png)

You can go into the Reporting-\>Country of Origin and delete that record, which then makes the Country Of Origin on the Part-\>Detail sheet “None Selected”

I think you can blank out the Schedule B Code field, but trying to do both is probably failing on every record because of the PartCOO.

You will probably have to run DMT twice.

1. **Update** _Part_ with SchedBCode blanked out.
2. **Delete** _Part Country Of Origin_ records (Company, PartNum, OrigCountry)

Try this in a test first.

---

<div class="post-metadata">

**Author:** ![psiebers](https://www.epiusers.help/user_avatar/www.epiusers.help/psiebers/32/8715_2.png) [@psiebers](https://www.epiusers.help/u/psiebers)\
**Post date:** [January 22, 2021, 2:17pm UTC](https://www.epiusers.help/t/dmt-null-value/74770/3 "2021-01-22T14:17:26Z")

</div>

I think you are right. Let men try this…

---

<div class="post-metadata">

**Author:** ![psiebers](https://www.epiusers.help/user_avatar/www.epiusers.help/psiebers/32/8715_2.png) [@psiebers](https://www.epiusers.help/u/psiebers)\
**Post date:** [January 22, 2021, 3:18pm UTC](https://www.epiusers.help/t/dmt-null-value/74770/4 "2021-01-22T15:18:46Z")

</div>

Doug FTW!