Solved

Historical data on weighted average part cost

  • 9 October 2020
  • 3 replies
  • 292 views
cperdue
Rank
Userlevel 6
Badge +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!

icon

Best answer by Rcoubrou 6 June 2022, 21:40

View original
Best- Christy

3 replies

R
Rank
Userlevel 4
Badge +9

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

cperdue
Rank
Userlevel 6
Badge +14

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

 

Best-

Christy

Best- Christy
R
Rank
Userlevel 4
Badge +9

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

Reply


Terms & ConditionsCookie settings