Receiving and Invoicing - Impact on Work Order Costs

Question

Good Afternoon Community. Please help me understand why Maximo is coming up with these work order costs. Here are the steps to replicate running 7.6.1.2 IFIX20220506-1004

1. Create a work order and approve the work order.
2. Create a PO and add a line, material or Item associate the work order, and approve the PO value 10,000.
3. Receive this item on the PO.
4. Return this item on the PO.
5. Revise the PO changing the line item costs, and approve the revision new value 5000.
6. Receive the item on the PO.
7. Create an invoice, select the PO, copy the PO line and change status to Paid.

On my work order I see 4 Material use transactions with these Issue types.
ISSUE: 10,000
RETURN: -10,000
ISSUE: 5,000
INVOICE: -5,000

View Work Order Costs shows 0.

Now consider these steps.

1. Create a work order and approve the work order.
2. Create a PO and add a line, material or Item associate the work order, and approve the PO value 10,000.
3. Receive this item on the PO.
4. Void Receipt of this item on the PO.
5. Revise the PO changing the line item costs, and approve the revision new value 5000.
6. Receive the item on the PO.
7. Create an invoice, select the PO, copy the PO line and change status to Paid.

On my work order I see 3 Material use transactions.
ISSUE: 10,000
VOIDRECEIPT: -10,000
ISSUE: 5,000

View Work Order Costs shows 5,000.

Why is Maximo calculating my costs as such. Why does Maximo create an extra INVOICE type material transaction for my work order that I will never receive, and therefore sets my work order costs to 0? What is Maximo expecting me to do with the extra $5000 from my first revision of the PO that I returned instead of voided? Is this an IBM bug or any type of Known Issue?

Thanks for your help.

Accepted Answer

Hi Eric,

In Step 7 for the first scenario, you said "Copy the PO Line". When you copy a PO Line rather than a specific Receipt, Maximo is deciding which Receipt should be matched. I'm assuming it picked the first Receipt for $10,000 and since the Invoice was for $5,000, it created an INVOICE MatUseTrans to adjust for the variance between the Received Cost and the Invoiced Cost. If you had picked all 3 Receipts (the 2 RECEIPT and the 1 RETURN) to match to the Invoice everything should have been fine. If you had picked the RECEIPT for $5,000, no additional INVOICE record but you would still have 2 unInvoiced Receipts left on the PO.

In the second scenario, you Voided the original Receipt which puts the MatRecTransID of the original Receipt in the ReceiptRef column on the VOIDRECEIPT record. The process that automatically matches the Invoice to a Receipt when a PO Line, rather than a Receipt, is copied ignores VOIDRECEIPT transactions as well as Receipts whose MatRecTransIDs are the ReceiptRef on a VOIDRECEIPT. Therefore, there was only 1 Receipt available to match and it was the one for $5,000.

I normally move the "PO Lines" tab on the "Copy from PO Lines" dialog to the far right so that the "Materials" tab shows by default.

Hope that helps.

Maximo Open Forum