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

Average Cost Changes

 2 Replies
 0 Subscribed to this topic
 2 Subscribed to this forum
Sort:
Author
Messages
Neil Allen
New Member
Posts: 0
New 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
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
0
liked by Members
Kat V
Veteran Member
Posts: 1020
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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.