9.05.701 DMT Import Error

Yahoo Archive
1
The Error relates to an invalid TaxCatID
Unfortunately in DMT we have to utilise the business objects errors and these often use the label values for fields.

Are you specifying a valid entry for this column?
If the issue still persists please provide your Epicor Version, DMT Version or drop this to support and they will help resolve.

Thanks,

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Joshua Giese
Sent: 28 May 2013 19:56
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: 9.05.701 DMT Import Error



For DMT errors I usually recommend hiring a translator. lol !

Joshua Giese

CTO

920.437.6400 Ext. 337

Site ID: 27450-E905700B2-SQL64

----- Original Message -----

From: "Michael" <mkgross69@...<mailto:mkgross69%40gmail.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Tuesday, May 28, 2013 1:53:23 PM
Subject: [Vantage] Re: 9.05.701 DMT Import Error

Kim,

Same problem here a couple of times. Category ID is referring to either Part Class (DMT Column=ClassID) or Product Group (DMT column=ProdCode).

I can't remember which for sure, but I'm pretty sure it's one of those. It's been a few months since my pre-go-live DMTs had errors.

Can't hurt to check those.

Mike

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> , "faepigrl" <faepigrl@...<mailto:faepigrl@...>> wrote:
>
> I am importing PART table using the DMT. I am getting an error on almost all my records with a message of: Category ID refereneces invalid value.
>
> I don't have a column called Category ID and don't see one in the DMT as a valid column.
>
> Does anyone have any ideas?
>
> Thanks Kim
>

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
2
I am importing PART table using the DMT. I am getting an error on almost all my records with a message of: Category ID refereneces invalid value.

I don't have a column called Category ID and don't see one in the DMT as a valid column.

Does anyone have any ideas?

Thanks Kim
3
Check that your columns are spelled correctly.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of faepigrl
Sent: Tuesday, May 28, 2013 11:07 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 9.05.701 DMT Import Error



I am importing PART table using the DMT. I am getting an error on almost all my records with a message of: Category ID refereneces invalid value.

I don't have a column called Category ID and don't see one in the DMT as a valid column.

Does anyone have any ideas?

Thanks Kim



[Non-text portions of this message have been removed]
4
BPM? do you have any enabled?


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Tue, May 28, 2013 at 2:06 PM, faepigrl <faepigrl@...> wrote:

> **
>
>
> I am importing PART table using the DMT. I am getting an error on almost
> all my records with a message of: Category ID refereneces invalid value.
>
> I don't have a column called Category ID and don't see one in the DMT as a
> valid column.
>
> Does anyone have any ideas?
>
> Thanks Kim
>
>
>


[Non-text portions of this message have been removed]
5
I don't have any BPM's set up yet.



________________________________
From: Jose Gomez <jose@...>
To: Vantage <vantage@yahoogroups.com>
Sent: Tuesday, May 28, 2013 2:09 PM
Subject: Re: [Vantage] 9.05.701 DMT Import Error


BPM? do you have any enabled?


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com/
<http://www.linkedin.com/in/josecgomez>Â <http://www.facebook.com/josegomez>
 <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
 <http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
 <http://www.usdoingstuff.com/>

*Quis custodiet ipsos custodes?*


On Tue, May 28, 2013 at 2:06 PM, faepigrl <faepigrl@...> wrote:

> **
>
>
> I am importing PART table using the DMT. I am getting an error on almost
> all my records with a message of: Category ID refereneces invalid value.
>
> I don't have a column called Category ID and don't see one in the DMT as a
> valid column.
>
> Does anyone have any ideas?
>
> Thanks Kim
>
>Â
>


[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo!Groups Links



[Non-text portions of this message have been removed]
6
Ok, it wasn't a spelling but thanks for making me check it because I went through each column with different eyes and found my error. Still don't understand the message but at least it is working now.
Â
Thanks


________________________________
From: Miguel Santillan <msantillan@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Tuesday, May 28, 2013 2:09 PM
Subject: RE: [Vantage] 9.05.701 DMT Import Error


Â

Check that your columns are spelled correctly.

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of faepigrl
Sent: Tuesday, May 28, 2013 11:07 AM
To: mailto:vantage%40yahoogroups.com
Subject: [Vantage] 9.05.701 DMT Import Error

I am importing PART table using the DMT. I am getting an error on almost all my records with a message of: Category ID refereneces invalid value.

I don't have a column called Category ID and don't see one in the DMT as a valid column.

Does anyone have any ideas?

Thanks Kim

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
7
Kim,

Same problem here a couple of times. Category ID is referring to either Part Class (DMT Column=ClassID) or Product Group (DMT column=ProdCode).

I can't remember which for sure, but I'm pretty sure it's one of those. It's been a few months since my pre-go-live DMTs had errors.

Can't hurt to check those.


Mike


--- In vantage@yahoogroups.com, "faepigrl" <faepigrl@...> wrote:
>
> I am importing PART table using the DMT. I am getting an error on almost all my records with a message of: Category ID refereneces invalid value.
>
> I don't have a column called Category ID and don't see one in the DMT as a valid column.
>
> Does anyone have any ideas?
>
> Thanks Kim
>
8
For DMT errors I usually recommend hiring a translator. lol !



Joshua Giese

CTO

920.437.6400 Ext. 337

Site ID: 27450-E905700B2-SQL64

----- Original Message -----

From: "Michael" <mkgross69@...>
To: vantage@yahoogroups.com
Sent: Tuesday, May 28, 2013 1:53:23 PM
Subject: [Vantage] Re: 9.05.701 DMT Import Error



Kim,

Same problem here a couple of times. Category ID is referring to either Part Class (DMT Column=ClassID) or Product Group (DMT column=ProdCode).

I can't remember which for sure, but I'm pretty sure it's one of those. It's been a few months since my pre-go-live DMTs had errors.

Can't hurt to check those.

Mike

--- In vantage@yahoogroups.com , "faepigrl" <faepigrl@...> wrote:
>
> I am importing PART table using the DMT. I am getting an error on almost all my records with a message of: Category ID refereneces invalid value.
>
> I don't have a column called Category ID and don't see one in the DMT as a valid column.
>
> Does anyone have any ideas?
>
> Thanks Kim
>





[Non-text portions of this message have been removed]
9
>any ideas?
Could it could be something to do with memos?
Memo and MemoCat tables contain a CategoryID field.



--- In vantage@yahoogroups.com, "faepigrl" <faepigrl@...> wrote:
>
> I am importing PART table using the DMT. I am getting an error on almost all my records with a message of: Category ID refereneces invalid value.
>
> I don't have a column called Category ID and don't see one in the DMT as a valid column.
>
> Does anyone have any ideas?
>
> Thanks Kim
>