Skip to main content

Hi, upon checking the inventory transaction history, I have 100qty in with unit cost 133.69190. However, the next 12qty out becomes 133.69167. And the subsequent issue out unit cost becomes 133.69000. I thought if based on FIFO, the issue out cost should also be 133.69190, but value turns out to be different in the screenshot. Anyone can advise how the system calculates the 133.69167 and 133.69000 if my inventory valuation method is FIFO? Thanks alot!

 

Hello @jechang 

Are the Warehouse Locations costed separately?  If not, Acumatica may assign the oldest cost in the warehouse, even if it’s in a different location.  I copied the help below; please see if this answers your question.

 


Hello @jechang 

Are the Warehouse Locations costed separately?  If not, Acumatica may assign the oldest cost in the warehouse, even if it’s in a different location.  I copied the help below; please see if this answers your question.

 

hi @laura01 , my settings for the warehouse locations are not costed separately. The oldest cost in the warehouse is actually 133.69190 for 100qty. but unsure why the subsequent issue out costing is 133.69167 and 133.69000. 


Hi @jechang 

What is the costing method of the Kit Assembly? It appears that is being factored into the costing of the item. 


Reply