Average Unit Cost Valuation

SOLVED

I was brought the question of why a dramatic change in the standard cost of an item that is in inventory did not create a journal entry to reflect the change in value. I noticed that the valuation methods on this particular product are setup as follows: under “Standard Valuations” section, Valuation = Cumulative AUC, Alt Default = Standard Cost, Receipt Value = Order Cost and Alt Default = Standard Cost.

The product in question was a newly created product and was placed into inventory via Misc receipt (for the first and only time) where it still remains. At the time the standard cost was incorrectly set to $22093 per EA instead of $22.93. After the misc receipt was posted, the person realized the issue with standard cost and went into change it to $22.93. No journal entry was created to adjust the value of the existing inventory. I have a theory as to WHY it didn’t create a journal entry but I would rather know for sure. If someone could please either validate or correct my theory, I would really appreciate it!

My Theory: Since it was the first time this product went into inventory, the alternative default of Standard Cost was used to generate the value of the product which was at $22093. Since there was a receipt (even though it was a misc receipt) and the valuation method is set to Average Unit Cost, the inventory is being valued at the same value of the product from the misc receipt. So a change to the standard cost would not post a JE to correct the value of the inventory because the value of the inventory is based off of the average receipt cost (since in this case there is only one), so the inventory will be valued at $22093. Does this make sense?

Also, as you can see the value is egregiously wrong. Because I am using AUC (and if my above statement is correct), will the value of this inventory be wrong for all time? How are you supposed to fix an issue like this when using AUC? 

  • 0

    Inventory / Utilities / Valuation / Value Change

    You can view the AUC (and change it, but I would try it in a test folder to see if it has the correct financial effect).  When you do a misc receipt it uses the cost entered (if the misc receipt screen code allows the user to do so), which is receipt value.  I am quite sure you can't change the cost in the misc receipt screen after its been created.   If you go the value change route, I would definitely read the function help before using it, theres also a KB article on it.

    If it were me, I would probably use a misc issue to get it out of stock, then re-receive it at the correct cost.

  • 0 in reply to RegularGuy

    I did read the function help for this (unfortunately) and it's actually part of the reason why I am now facing this confusion. I know that adjusting the value of the standard cost does not create a JE on an average cost item because it didn't in our production environment. I definitely cannot change the cost in the Misc receipt as it has already been posted. But I am curious, if I issue the stock out and then misc receive it again at the correct cost, won't the value of the inventory still be off? I only wonder because if it is using the average of my receipts (which i suppose it will), it will average 22093 with 22.93 and the value will still be crazy.

    It seems like a catch 22 to me as I logically cannot see a way to correct this!

    I suppose I will check the KB article and see if there is anything useful there... hopefully there will be something that defines the way AUC actually works and maybe how far back it considers transactions for the average.

  • 0 in reply to rotac

    I still don't know have a definitive answer on the JE generation situation i described above, but my guess is that my theory is probably correct. Though to RegularGuy's point I might as well test this on our dev environment and post my findings. Also, there is a knowledge base article on correcting AUC gone wrong. I figured I would post it here in case anyone else runs into that issue:

    Use the Value Change function to correct the Average cost.

    Open Stock, Utilities, Valuation, Value Change.

  • 0 in reply to rotac

    Actually there is still a huge problem here. I have adjusted the value in the Value Change function which will post a correcting JE but the the average cost still doesn't change! I assume that X3 will generate the AUC the next time I receive this product by referring to the last time i received it which will be incorrect! Plus it still states that the average cost is 22093 on the screen. Am I doomed to forevermore adjust the value of this every single time it is received!?

  • 0 in reply to rotac
    verified answer

    To correct you need to adjust the global amount as the one corrected was for FIFO method.

  • 0 in reply to ccohen

    You know, it's funny...it didn't allow me to change it the first time I tried but I just tried it again and it did. Thanks so much!