Skip to main content
Solved

Historical data on weighted average part cost

  • Oct 9, 2020 7:22 PM UTC
  • 3 replies
  • 411 views

cperdue
Hero (Partner)
Forum|alt.badge.img+14

Is there a canned report that shows the historical weighted average unit cost of a part?  I can find cost on transactions or cost set history but not a log of unit cost changes as calculated by the system.

 

Thank you!

Best answer by Rcoubrou

@cperdue just FYI that we turned on history logging for the weighted average cost field and built a quick report to return the prev unit cost, new unit cost and current unit cost.    Not great solution but at least it’s something.  

View original

3 replies

Forum|alt.badge.img+12
  • Hero (Customer)
  • Nov 15, 2021 8:55 PM UTC

Hi @cperdue  Did you ever find a solution to this?  Aside from the monthly “inventory value per period” form ?   Thank you


cperdue
Hero (Partner)
Forum|alt.badge.img+14
  • Author
  • Hero (Partner)
  • Nov 17, 2021 5:47 PM UTC

@Rcoubrou  -  I was not able to find any resolution to this.  

 

Best-

Christy


Forum|alt.badge.img+12
  • Hero (Customer)
  • Answer
  • Jun 6, 2022 7:40 PM UTC

@cperdue just FYI that we turned on history logging for the weighted average cost field and built a quick report to return the prev unit cost, new unit cost and current unit cost.    Not great solution but at least it’s something.