IC12 - Average Cost

Author
Messages
Bev Edwards
Veteran Member
Posts: 366
Veteran Member
    Where is the average cost in IC12 pulled from? I have several items where the price in PO25.6 does not match the IC12 Average cost figure.

    When the item is ordered (LUM) the average cost from IC12 is being pulled into the PO instead of the price from the Vendor Agreement. As a result, we are receiving price discrepancies.

    Bev
    JonA
    Veteran Member
    Posts: 1162
    Veteran Member
      Average unit cost is calculated for inventory items. It's recalculated every time there are receipts for an item.

      Current SOH Value + Receipt Value
      ----------------------------------------------
      Current SOH Qty + Receipt Qty

      Are you sure that you're seeing the average cost on the PO line? On PO01.4 the only choices for cost source are Contract Order, Catalogs & Quotes, Blanket Order, Last Cost, Last PO, and IC No Charge Flag. If you check the cost source on the PO line and it doesn't say Contract there may be several reasons-

      -your agreement participants aren't set up correctly
      -the vendor set in IC12.2 is not the same as the vendor for the agreement
      -the item/vendor cat is not setup on the agreement
      -the agreement/line is on hold
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      Bev Edwards
      Veteran Member
      Posts: 366
      Veteran Member
        The cost source on the PO line is "Last Cost". In PO01.4, Last Cost has a value of '2'. Contract is "1".

        Not sure then why this would pull last cost over Contract.
        Bev Edwards
        Veteran Member
        Posts: 366
        Veteran Member
          I noticed we have 2 IC12's. One for DISTR and one for LUM.

          The one for LUM shows 0.00 for Average Cost. The one for Distr shows the incorrect price (does not match the PO25.6 )

          See attached...
          Attachments
          Kat V
          Veteran Member
          Posts: 1020
          Veteran Member
            Average cost will also zero out when SOH hits zero. This is what I would guess the issue with LUM is. Distr is averaging over time and is likely pulling more old data and skewing the cost. To "reset" we create an IC24 and issue it all out and then IC24 and issue it all back in at the correct cost. The difference then sits on the over/short GL account. We do this whenever the difference between IC12 and PO25.6 is greater than 5%.

            IC47 will show you the cost at the time of transaction and should help you narrow down when it started going sideways.
            Michelle Wetzel
            Veteran Member
            Posts: 183
            Veteran Member
              Just to add to what Jon said - the average cost also fluctuates whenever an invoice is applied to the PO line.
              JonA
              Veteran Member
              Posts: 1162
              Veteran Member
                Right, if the invoice cost is different from the PO cost a cost adjustment (CA) will be applied. Thanks Michelle.

                So, the issue with the PO line showing last cost- Have you verified that the Ship-to on the PO line is a participant on the agreement? Either it has to be specifically identified or PO25.3 is completely blank (wide open- all locations are participants).
                Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
                Sheri
                Veteran Member
                Posts: 163
                Veteran Member
                  Does anyone have a report that can tell if an item's average cost has a 'significant' change ?
                  Kat V
                  Veteran Member
                  Posts: 1020
                  Veteran Member
                    I have a report in our BI report center that runs an SQL to tell you the difference between average cost and "true" cost. I can share this piece - kvila@mhs.net (our firewall won't let me add attachments here). If the difference/avg-cost > .1 (so when it's over 10%) it flags it as non-compliant.
                    Sheri
                    Veteran Member
                    Posts: 163
                    Veteran Member
                      Thanks Kat, I sent you an email, for the report.

                      Appreciate it!
                      Kat V
                      Veteran Member
                      Posts: 1020
                      Veteran Member
                        ... the post went away as I got here but RQC pulls price based on PO01.4 Cost Default Tab.

                        First it will ask if you want to pull Vendor then price or price then vendor (Which came first - the chicken or the egg? ) We have Vendor, Vendor Item, Cost - find the right part number and the cost should be easy to find on PO28.

                        I didn't get to see the screenshots - but if RQC UOM = PO25.6 UOM with our setup - it's pulling from PO25.6. If the UOMs don't match and the PO25.1 UOM Must Match is N (No) then Lawson is doing math on the PO25.6 pricing to calculate the cost in RQC's UOM.
                        Cory
                        New Member
                        Posts: 2
                        New Member

                          Greetings!  The above thread has been extremeely eye-opening.  However my team and I cannot figure out where the RQC Cost comes from and it is throwing off our departmental budgets.  RQC shows a cost that is not reflective of the Last Received Cost in IC12.  As a result our requesting locations are being charged a different amount than what they are supposed to be charged for items ordered.  We would be grateful for anyone's assistance.    

                          Cory
                          New Member
                          Posts: 2
                          New Member

                            Thank you Kat V. for your prompt reply from yesterday!

                            Kat V
                            Veteran Member
                            Posts: 1020
                            Veteran Member
                              Yeah - check out your PO01.4 and move Last Cost up the field a bit in test and see what happens.
                              ---