Skip to main content
Solved

Historical data on weighted average part cost

  • October 9, 2020
  • 3 replies
  • 369 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.  

3 replies

Forum|alt.badge.img+11
  • Hero (Customer)
  • 133 replies
  • November 15, 2021

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)
  • 440 replies
  • November 17, 2021

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

 

Best-

Christy


Forum|alt.badge.img+11
  • Hero (Customer)
  • 133 replies
  • Answer
  • June 6, 2022

@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.