Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



Fw: [MAXIMO List] Hmmm, this is weird. Inventory balance and standard cost.

From: Incomm Solutions (2016-01-18 10:21)


If you're going by Average Cost, then the Standard Cost Adjustment has no financial significance. The other two are cancelling each other out, so I think you're good financially in terms of the transaction amounts. But the valuation of that item is a different thing... what was the current balance before the transactions? 
Shannon
Sent from my wonderful BlackBerry Z30 smartphone!
From: maximal@wanko.com [MAXIMO]
Sent: Monday, January 18, 2016 9:08 AM
To: MAXIMO@yahoogroups.com
Reply To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Hmmm, this is weird. Inventory balance and standard cost.
I had a user who wanted to convert his per-foot issue to per-box issue. For some reason, they would get boxes of chain in ten-foot length, then issue by the foot. Apparently they broke chain on demand at one point, but now they just issue the box, call it spent, then any leftover chain goes into a bin to be issued on demand with no transaction. This may make accounting crazy but it saves them time. I won't debate that.
So, what we did was changed to issue quantity to BOX, then changed the unit price to the box price, 26.90.
Inventory cost has this new value. Any subsequent issues will be at that price.
However, Inventory Transactions did this:
an average cost adjustment line was inserted for linecost 968.40 (taking each foot) for quantity 40
a current balance adjustment line was inserted for -968.40 for quantity 36
a standard cost adjustment line was inserted for 34.96 (should probably be 34.97) for quantity 4
So, I did something out of order, or Maximo did a calc all weird. Does anyone know what happened? Is there a way to reverse or settle this?
-C


From: maximal (2016-01-18 10:00)


---In MAXIMO@yahoogroups.com, <incomm@shaw.ca> wrote :
If you're going by Average Cost, then the Standard Cost Adjustment has no financial significance. The other two are cancelling each other out, so I think you're good financially in terms of the transaction amounts. But the valuation of that item is a different thing... what was the current balance before the transactions?
I think it was 40 (feet).

-C