Maximo Open Forum

Hi everyone,

I have the following scenario:

Context:

In the purchase orders application, there's a field to select the vendor and another field below it to select an email from the vendor.

I need the email list to be filtered to show only emails from the selected vendor, but I also want the option to input a new email just for this purchase order (without adding it to the vendor's email list).

I created a table domain and assigned it to the "EMAILVNDD" field. I set the query with a relationship inside, and it worked as expected. However, there's an issue: I can't use a value that is not in the domain list because it says, "The value … is not valid for E-mail. Specify a valid value for E-mail." I tried removing the validation field from the lookup, but the same outcome occurred. I also tried setting the query to 1=1, which allows me to input a value even if it's not in the list but the results from the lookup are all emails from all vendors.

It's been a year since I last worked with Maximo, and I've forgotten some things. This might be a simple issue, but I can't think of a solution.

Thank you!

#Administration
#Assets

------------------------------
Victor G
acw
------------------------------

Let's go step by step. First of all.

In PO there is a contact data that only shows the contacts registered in the supplier. It does not list the email addresses. That will list the email of the contact registered in the supplier.

To display the contact email, you should:

In database, you need to create a new relationship in PO object. 

Relationship: A_PO_CONTACT

Child object: COMPCONTACT

Where clause: company=:vendor and orgid=:orgid and contact = :contact

Then, you can add a multipart text and its attributo to part2 define like A_PO_CONTACT.EMAIL. 

As a result, when you select the supplier's contact, you will be able to view their email.

Now, if you want to add a new field that is the contact email for the PO: 

- If it is a free text, you can register any text as email in each PO (You will have to add a new field for this because the extra fields I have seen are small)
- If it is a domain value, you cannot put a free text since it must previously exist as a domain value.
You cannot use both (that is what you want to do).

What you can do is create this  new attribute PO.POEMAILCONTACT associated with a new table "POEMAIL" where you will have 2 primary keys which would be the PO number and the email. This way you will register an email in each PO that will exist in that table (I don't know why you want to do that, but you could do it).

I say that I don't know why there is already an email table (EMAIL) that keeps track of each email, but not associated with PO.

But I insist, the only way you can record data and not free text, is to associate it with a table where it is recorded.

Regards!

------------------------------
Martin Fabra
ARSAT S.A. - Actively seeking employment
------------------------------