Wrong cost showing in IC12 drill down

 3 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Bev Edwards
Veteran Member
Posts: 366
Veteran Member
    How can I use the IC24 to change the cost information that is showing in the IC12 drill down?
    Kat V
    Veteran Member
    Posts: 1020
    Veteran Member
      If you adjust out all stock on hand and then bring back the correct counts with the correct cost, most of the cost information will reset.
      Scott Perrier
      Veteran Member
      Posts: 39
      Veteran Member
        You can use ic24.2 to adjust the inventory level down to zero for the cost show on the on the ic12. This should set allow your average cost to reset. Next, reapply the inventory at the correct cost which should now show as your average cost and last cost values. The last issue cost will not change until the next time the item is ordered.
        JonA
        Veteran Member
        Posts: 1163
        Veteran Member
          Simple answer is you adjust all stock on hand quantity out and then adjust it back in at the desired cost. But there may be some things to consider.

          Is the cost incorrect because the PO line was received at the wrong cost? If the invoice is matched at the correct cost a cost adjustment will be applied to that portion of the stock on hand. If the incorrect cost is caused by wrong PO cost and the invoice hasn't been processed yet, I would back out the receipt and change the cost on the PO line and re-receive.

          Another thing to consider is, have there been issues to departments at the wrong cost? If the difference is only a few bucks it's probably not worth it but you might want to credit the departments at the current (wrong) cost, adjust the receiver, correct the PO line cost, re-receive and re-issue to the departments (now at the correct cost).
          Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health