We have auditors asking us how we arrived at the issue price for an item. Using IC50, I can find where we issued the item, who we issued to, and at what price but how would I find the invoice or PO that specific item came on? We use FIFO btw.
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?