Visits from government agencies

Description	Value
Prepared By	IMAN Auditor
Date	04-14-2009
Reviewed By	G. Audit Supervisor
Review Date	02-19-2009
Audit Step	12
Audit Objective	Summarize invoice amounts billed by approver
Data Source	c:\test\data\EWP.xls
Date Run	04-19-09 17:12:53
Table/WorkSheet	Trans$
Column	invoice amount
Command	summary - Summarize amounts
Parameters Used	[approver]
First Parameter	(none)
Where	(none)
Second Parameter	(none)
SQL used	select sum([invoice amount]) as [Total], avg([invoice amount]) as [Average], min([invoice amount]) as [Minimum], max([invoice amount]) as [Maximum], count([invoice amount]) as [Count], stdev([invoice amount]) as [Standard Deviation], [approver] from [Trans$] group by [approver] ;
Processing status	Normal process - 11 rows
Finding (Condition, Cause, Effect)
Conclusions
Recommendations
Discussed with
Management agrees?
Management comments
Auditor comments

Report Schedule