Maximo Open Forum

Hi Everyone, 

My team has created a custom Maximo application with POLINE as the Main Object. The goal is to show all the Purchase Order, Work Order and Invoice records side-by-side.

Even though I've been able to add table columns that successfully return these attributes by using the out-of-the-box relationships between the POLINE and the INVOICELINE tables, I have noticed that a PO with multiple invoices submitted against it will only display one invoice #. I'd like to show all the invoices submitted against each PO even if that means having multiple rows with the same PO #. Could anyone let me know if this is possible?

I am confident that the out of the box relationships I am using from the parent object, POLINE, with the child object, INVOICELINE, are correct because the relationship description states "Relationship to the InvoiceLine table, used to find all invoice line records for a given purchase order line."

I could build a new custom application with INVOICELINE as the main object. Since I want to show all the POs and WOs regardless if they have been invoiced against or not, I'd need to build a right outer join where clause that joins the INVOICELINE object with the POLINE object. 

Any assistance would be greatly appreciated.

When you reference a related attribute in a table column/textbox, Maximo will only fetch the first record that matches the criteria. In order to display multiple results, you would need to display it in a table underneath your record. 

If you want these on the list page where you can't display a child table, you should be able to create a view using the view select & view from capabilities like we do with the WMASSIGNMENT view. This will cause the POLINE to repeat if it exists in multiple invoice lines but should enable you to see all the results on the list tab.