Stop new part when part exists as xref

[WayneH (Wayne Haire)]

Hi,

I am trying to do a method directive that will send an exception message if the part being created already exists as a part cross reference, i.e. PartXRefInt table. I can’t seem to set a variable up to check to see if a cross reference exists.

Thank you

[Chris_Conn]

I vaguely recall @jkane doing this somewhat recently.

[jkane (John Kane)]

Here is the post.

Anyone Know How Customer Parts Get Auto Created on Sales Order

Not sure who is aware of this little feature, but when entering a Sales Order line if you enter a Customer Part Number, Epicor will automatically create the cross reference to your internal part number. Pretty nifty feature, but you cannot enter a Customer Part Number Description, it just takes your internal part number description. I traced the transaction. I entered the Customer Part Number and tabbed off. Checked the Xref and it was not created yet. Went back and clicked save. Checked the Xr…

[WayneH (Wayne Haire)]

Although this is very interesting, it does not help me out. The cross reference part I am trying to stop being created is not a customer part.

Example:
We have part BLT-B38 with a cross reference part FAN-4038B. Part FAN-4038B does not exist in the part table, nor do we want it to. If you are looking for a part and put in FAN-4038B, part BLT-B38 will automatically show up (which is perfect). What happens is someone enters a new part in Part Entry for FAN-4038B, the system lets this part be created, this is what I want to stop and issue exception for.

I am trying to do a method directive on part update, but don’t know how to set a variable or check a condition because PartXrefInt table is not available.

[jkane (John Kane)]

Ah, thanks for the expanded explanation.

I would do a Post-Processing BPM that checks for the x-ref part and returns an error and does not let them save.

[WayneH (Wayne Haire)]

OK, but how do I check for the xref part?

[jkane (John Kane)]

If the table is not part of the transaction, you will have to bring it in and then do a condition that checks for the part number that was entered equals one of the x ref parts.

[WayneH (Wayne Haire)]

And that is my issue, how do I bring in the PartXrefInt table into the transaction?

[jkane (John Kane)]

Sorry, can’t test on 10. But at the least you should be able to do a BO call in the BPM using the proposed part number as your filter and if you return a row then you could error it out.