Get PartMtl from PartNum and PartRev?

Epicor ERP 10
1

I have a PartNum, RevisionNum and a Company. What adapter can I use to grab the MtlNum?

2

JobMtlSearch

1 Like
3

Thank you sir. Easy as that. :blush:

4

Why can I find my record in ERP.PartMtl and not ERP.JobMtl?

5

JobMtl is not hierarchical. The JobMtl is related to the JobAsm record.

1 Like
6

I want to run this query via an adapter and get a result

select * from ERP.PartMtl
where Company = '01800000' AND PartNum = '01000028' AND RevisionNum = 'A'
7

Use a BAQ there is no adapter for just PartMtl

1 Like
8

Thank you. Guess it’s time to make my first haha

9

You should be using BAQ’s 99% of the time they are much faster and efficient than the adapters.

1 Like
10

Ahhhh. This I did not know.

:+1:

11

Unrelated to your issue I would HIGHLY HIGHLY Recommend a cursory reading o the ICE Tools and the Customization Guide. There are a LOT and I mean A LOT of ways to skin a cat in Epicor and these guides will expose you to all of them.

I promise it will make your life a thousand times easier.

2 Likes
12

@hkeric.wci hooked me up with it

13

It’s also in the help files, which it super helpful. The user guides have step by step walk throughs to get you through some of the basics. WITH PICTURES!! (unlike the rest of the regular help files)

1 Like