DMT null value

Epicor ERP 10
,
1

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!

2

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

image

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.

3

I think you are right. Let men try this…

4

Doug FTW!