Visits from government agencies

Description	Value
Prepared By	IMAN Auditor
Date	04-01-2009
Reviewed By	G. Audit Supervisor
Review Date	02-20-2009
Audit Step	34
Audit Objective	Extract the rightmost two characters from each Invoice Number for customers in any city beginning with the name 'MAYAQ'
Data Source	c:\test\data\EWP.xls
Date Run	04-19-09 17:13:14
Table/WorkSheet	Trans$
Column	Invoice Number
Command	calc - Calculate a computed value
Parameters Used	(none)
First Parameter	right([Invoice Number],2) as [Right two digits of Invoice Number]
Where	city like 'MAYAQ%'
Second Parameter	(none)
SQL used	select right([Invoice Number],2) as [Right two digits of Invoice Number],* from [Trans$] where city like 'MAYAQ%'
Processing status	Normal process - 6 rows
Finding (Condition, Cause, Effect)
Conclusions
Recommendations
Discussed with
Management agrees?
Management comments
Auditor comments

Report Schedule

Right two digits of Invoice Number	Customer Number	Invoice Date	Invoice Number	Invoice Amount	Due Date	Terms Percent	Process Time	ID	Customer Number1	Customer Name	ADDRESS	CITY	STATE	Zip Code	Setup Time	Last TranTime	Credit Limit	Approver	Terms Days
56	11828	1/11/2008	45256	9551.29	2/22/2008	0.06	1/3/2008 10:28:23 AM	819	11828	EQUIPOS MEDICOS SULTANA	TOWN SQUARE, P O BOX 158	MAYAQUEZ	WY	00633	1/30/2005	1/1/2009 2:23:49 PM	15000	Joe	10
19	11828	1/10/2008	45219	9543.74	2/21/2008	0.06	1/7/2008 1:15:37 PM	819	11828	EQUIPOS MEDICOS SULTANA	TOWN SQUARE, P O BOX 158	MAYAQUEZ	WA	00633	1/30/2005	1/1/2009 2:23:49 PM	15000	JohnAK	10
62	11828	1/11/2008	45262	9552.48	2/22/2008	0.06	1/7/2008 11:55:02 AM	819	11828	EQUIPOS MEDICOS SULTANA	RURPA ROUTE 3, BOX 162K	MAYAQUEZ	NZ	00633	1/30/2005	1/1/2009 2:23:49 PM	15000	AC	10
39	11828	1/10/2008	45239	9547.79	2/21/2008	0.06	1/4/2008 12:46:37 PM	819	11828	EQUIPOS MEDICOS SULTANA	RURPA ROUTE 3, BOX 162K	MAYAQUEZ	NZ	00633	1/30/2005	1/1/2009 2:23:49 PM	15000	Unknown	10
39	11828	1/10/2008	45239	9547.78	2/21/2008	0.06	1/3/2008 8:40:44 AM	819	11828	EQUIPOS MEDICOS SULTANA	RURPA ROUTE 3, BOX 162K	MAYAQUEZ	NZ	00633	1/30/2005	1/1/2009 2:23:49 PM	15000	JohnAK	10
57	11828	1/11/2008	45257	9551.35	2/22/2008	0.06	1/9/2008 2:27:38 PM	819	11828	EQUIPOS MEDICOS SULTANA	RURPA ROUTE 17, STE 4	MAYAQUEZ	GA	00633	1/30/2005	1/1/2009 2:23:49 PM	15000	AC	10