• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Enterprise Resource Planning & Manufacturing Lawson S3 Procurement

Average Cost Changes

 2 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Me
Veteran Member Send Private Message
Posts: 96
Veteran Member
5/13/2019 9:26 PM
I'm looking for a way to track changes in average cost by creating a custom SQL report.  I'm not seeing that it's hitting the audit table which is where I was hoping to pull these changes from.  I really just need to identify when the average cost changes significantly.  Am I missing it somewhere?
JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
5/14/2019 12:07 PM
That's a tough one. I don't believe the system tracks average cost over time. At least I've not seen this. I think you'd have to pull this on a daily basis and put each day's item average costs into one database and run your average cost change report out of there.
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
Kat V
Veteran Member Send Private Message
Posts: 1020
Veteran Member
5/16/2019 4:27 PM
Agreeing with Jon. Average cost is an ongoing calculation. It's not a field anywhere that is changed so it's not really audited and we've never really seen the advantage in trying. We have sqls that monitor when the average cost vs true cost get too far afield from each other and the billing looks at a sql that calculates true cost.