There is a relationship from PO to POLINE called "COMPPOLINE" that only returns PO Lines whose RECEIPTSCOMPLETE field is unflagged. To use the ad-hoc reporting capability with Maximo, you'll need to build an Object Structure that utilizes this relationship to the POLINE table from PO. Then you can create ad-hoc queries that show only PO Lines that are not fully received.
Alternatively you can create the same logic in a custom BIRT report.
Hope this helps,
------------------------------
Alex Walter
A3J Group, LLC
------------------------------
Original Message:
Sent: 03-02-2022 10:41
From: Gina Ordaz
Subject: Back Order Reports
Jason
It' a very simple query which may be the problem. The query is: ((upper(receipts) = 'NONE' or upper(receipts) = 'PARTIAL') and historyflag = 0 and siteid = 'IMPJER')
It might just be in my head that I can't resolve this but, I don't see a way to query only the lines on a PO that receipts are not complete. I'm assuming that this would have to be done in BIRT reporting where only what pulls to the report is the lines where the quantity ordered does not match the quantity received. In my report, I do not want to include those items where the order quantity has been fulfilled.
I might be making this more complicated than it really is.
Thanks,
Gina Ordaz
Procurement Manager | Idaho Milk Products
Office 208-644-2889 | Cell 208-490-6198 |Email gordaz@idahomilk.us
Original Message:
Sent: 3/2/2022 10:32:00 AM
From: Jason Verly
Subject: RE: Back Order Reports
Can you share the query you used to find the PO's?
------------------------------
Jason Verly
Agropur
Original Message:
Sent: 02-25-2022 14:08
From: Gina Ordaz
Subject: Back Order Reports
Jason
I've been able to extract the proper information to Excel but not to exclude those line items that have been filled. Maybe I'm missing something in your email answer. This is certainly a learning curve for me.
Thanks,
Gina Ordaz
Procurement Manager | Idaho Milk Products
Office 208-644-2889 | Cell 208-490-6198 |Email gordaz@idahomilk.us
Original Message:
Sent: 2/23/2022 11:24:00 AM
From: Jason Verly
Subject: RE: Back Order Reports
------------------------------
Jason Verly
Agropur
Original Message:
Sent: 02-21-2022 09:26
From: Jason Verly
Subject: Back Order Reports
Hi Gina,
Do you know if your Maximo administrator has take any steps to expand the fields you can select in a QBR/Ad-Hoc Purchasing report? Out of the box, Maximo will just have a single report option for main Purchase Order (PO table) fields. A common task by either a Maximo admin or Report Developer would be to extend the report structure to other fields.
(I can't upload an image for some reason to show an example of an updated report structure)
------------------------------
Jason Verly
Agropur
Original Message:
Sent: 02-18-2022 12:42
From: Gina Ordaz
Subject: Back Order Reports
Jason
I'm needing to see the actual PO lines that are not complete.
Thanks,
Gina Ordaz
Procurement Manager | Idaho Milk Products
Office 208-644-2889 | Cell 208-490-6198 |Email gordaz@idahomilk.us
Original Message:
Sent: 2/18/2022 12:13:00 PM
From: Jason Verly
Subject: RE: Back Order Reports
Hi Gina,
Do you need to see the actual PO lines that are not complete or just a list of PO's that have an incomplete line?
------------------------------
Jason Verly
Agropur
Original Message:
Sent: 02-17-2022 12:05
From: Gina Ordaz
Subject: Back Order Reports
I'm looking for a back order/open PO report that reports only the lines on the PO that have not been completed. Is this only done through using BIRT? Does anyone have a report like this?
#Reporting
------------------------------
Gina Ordaz
Idaho Milk Products
------------------------------