Tracing Issue Item Back to Invoice?

IC50 should also show PO receipts or any 'CA' cost adjustments.

Have you tried PO63.1?

I can't speak to the FIFO part (we use average costing) but you can get the PO number from IC50. When it shows the PO transaction code, look document number. Plug that number into the receiver number on PO30 and it will bring up the PO number (you can also drill down to it but PO30 is faster). With the PO, you can go to PO64 and see the invoice number for that line, drill into the PO number to see it or use the req to payment widget. Good luck!

Posted By David Williams on 04/07/2017 10:31 AM IC50 should also show PO receipts or any 'CA' cost adjustments.

But let's say I have an item issued on 3/1/2017 for 2500 eaches. There's a PO receipt for 2/28/17. How do I know the items I issued came on that PO receipt?

Posted By Michelle Wetzel on 04/07/2017 10:35 AM I can't speak to the FIFO part (we use average costing) but you can get the PO number from IC50. When it shows the PO transaction code, look document number. Plug that number into the receiver number on PO30 and it will bring up the PO number (you can also drill down to it but PO30 is faster). With the PO, you can go to PO64 and see the invoice number for that line, drill into the PO number to see it or use the req to payment widget. Good luck!

That sort of works but the problem is, as I mentioned above, how do I know the items I issued out came in from that exact PO?

You could maybe look at the quantity on hand at the time the PO was received and extrapolate from there. Sorry - I'm not going to be much help on this part of it. This is why we use average costing instead of FIFO or LIFO.

You want to know how to tie a particular item issue to the PO it came in on? It would take some digging but PO64 might help. If you're using FIFO then it seems it's just a matter of matching the issue cost back to the PO receipts based upon the current SOH. So, if you have 80 on hand and have received 3 PO's of 30, you can pretty much figure out which PO the item ties back to - the first of the 3.

I think you're right, David. Thanks everyone!