Another DMT Issue

Kinetic ERP
,
1

OK so i have another DMT issue this time loading Manufacturers Part details. When i did my last migration i used the Manufacturers Part DMT script using the below columns

image

This loaded the details fine

image
image1896×472 28.3 KB

Now i am getting errors using that script as follows -

“2026-03-05T09:27:46 DOWCORN 267771 1-2577 MfgID not found”

Now the Manufacturers have been setup and verified.

I have raised a support ticket and support have said i need to used the Qualified Manufacturer DMT to load the data but that doesnt contain half the information that i need to load. Surely i dont have to use 2 scripts now instead of 1 :face_with_peeking_eye:

2

Hi Daniel,

You need to do the “Qualified Manufacturer” DMT first, then do the “Manufacturer Part” DMT.

2 Likes
3

Hi Michael,
I have never done it that way, i have also just loaded a subset of the data i was trying to load, into another environment and it worked fine :person_facepalming:

Daniel

4

Qualified Manufacturer is a simple DMT. It’s easy enough to add to your script.

1 Like
5

Hi Michael,
Like i said, i just used the same script in my Pilot environment on Manufacturer Part and it worked fine. This is making me think it could be a DB issue possibly. :thinking:
I know EPICOR have done some strange things recently but making you run 2 DMT scripts instead of 1 to get the same data in, is that something they would do? :dumpster_fire:

Daniel

6

I have always done 2 DMTs for loading manufacturer parts. One for the manufacturer and one for the part. This makes sense because there are 2 tables involved. AprvMfg and PartXRefMfg

1 Like
7

We load the Manufacturer on a separate script granted, but the Cross Ref details are loaded via Manufacturer Part.

8

“Approved manufacturer” or “manufacturer”? Those are two separate tables.

1 Like
9

Totally agree.

This is what i just loaded into my Pilot environment using Manufacturer Part DMT

image
image538×119 4.2 KB

And here it is in Qualified Manufacturer.

image
image1915×500 26.1 KB

I have only used the Manufacturer Part DMT script to populate that data.

10

Did the manufacturer exist on the part before you loaded the DMT? Delete both the manufacturer part and approved manufacturer off the part and try again. I bet you will run into the MfgID not found error.

1 Like
11

No, it was a new part i created in that environment

image
image1902×878 86.1 KB

12

BTW i thought i would try and load the Qualified Manufacturer First and then Load the Part Details and it throws the same MfgID Not Found error.

1 Like
13

Support have just responded to my ticket and after testing they have found a bug in the Power Tools DMT. Bug reference is DMT-3711 :beetle:

2 Likes