Who's On?

	Membership:
	Latest: Isabella Harris
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5245

	People Online:
	Visitors: 376
	Members: 0
	Total: 376

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

Average Cost Changes

2 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

Veteran Member

Posts: 96

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

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.

Kat V

Veteran Member

Posts: 1020

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.