PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 04/07/2017 3:01 PM by  SCMaster-jk2
Tracing Issue Item Back to Invoice?
 8 Replies
Sort:
You are not authorized to post a reply.
Author Messages
SCMaster-jk2
SCM Analyst
Private
Veteran Member
(240 points)
Veteran Member
Posts:100


Send Message:

--
04/07/2017 10:25 AM

    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.

    David Williams
    Private
    Private
    Veteran Member
    (3022 points)
    Veteran Member
    Posts:1018


    Send Message:

    --
    04/07/2017 10:31 AM
    IC50 should also show PO receipts or any 'CA' cost adjustments.
    David Williams
    JimY
    Private
    Private
    Veteran Member
    (1089 points)
    Veteran Member
    Posts:389


    Send Message:

    --
    04/07/2017 10:31 AM
    Have you tried PO63.1?
    Michelle Wetzel
    Lawson Procurement Systems Specialist
    Carle Foundation Hospital
    Veteran Member
    (497 points)
    Veteran Member
    Posts:173


    Send Message:

    --
    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!
    SCMaster-jk2
    SCM Analyst
    Private
    Veteran Member
    (240 points)
    Veteran Member
    Posts:100


    Send Message:

    --
    04/07/2017 11:38 AM
    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?

    SCMaster-jk2
    SCM Analyst
    Private
    Veteran Member
    (240 points)
    Veteran Member
    Posts:100


    Send Message:

    --
    04/07/2017 11:42 AM
    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?

    Michelle Wetzel
    Lawson Procurement Systems Specialist
    Carle Foundation Hospital
    Veteran Member
    (497 points)
    Veteran Member
    Posts:173


    Send Message:

    --
    04/07/2017 11:50 AM
    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.
    David Williams
    Private
    Private
    Veteran Member
    (3022 points)
    Veteran Member
    Posts:1018


    Send Message:

    --
    04/07/2017 11:54 AM
    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.
    David Williams
    SCMaster-jk2
    SCM Analyst
    Private
    Veteran Member
    (240 points)
    Veteran Member
    Posts:100


    Send Message:

    --
    04/07/2017 3:01 PM
    I think you're right, David. Thanks everyone!
    You are not authorized to post a reply.