Skip to main content
Solved

Understanding FIFO inventory valuation

  • 2 September 2022
  • 3 replies
  • 406 views

Forum|alt.badge.img

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!

 

Best answer by Kandy Beatty

Hi @jechang 

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

View original
Did this topic help you find an answer to your question?

3 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • September 2, 2022

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.

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • 17 replies
  • September 4, 2022
laura01 wrote:

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. 


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2161 replies
  • Answer
  • September 4, 2022

Hi @jechang 

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings