StepstoRunningRelatedPartyCheck
OpenupthemostrecentRelatedPartyExcelFile
L:\COMCON\Projects2011_2012\RelatedParty\2013
RunthequeryintheCOMMODSunrealizedaccrualstab
MakesurethecheckinColumnR1islessthan<100M
Ifthecheckisextremelylarge,there’sabreakineitherIntraorInter-deskrec.Research&escalateifneeded.
ColumnsSTU&Vshouldbecompletelydraggeddown
RunthequeryintheCOMMODSSuspenseforunrealtab
Thetabshouldbeblank
RunthequeryintheGLTransactionstab:
ColumnsAB,AC,AC&ADshouldbecompletelydraggeddown
SummingcolumnV&Wshouldbe0
RefreshthepivottableinGLTransactionsSummarytab
Thecolumnsshouldalsobezero.Specifically,account450860shouldoffsettheotheraccountbalancesineachcurrency.Ifitisn’tzero,thepivotmightnotbecapturingallthedatafromtheGLTransactionstab
IntheOnDemandErrorReportsTab:
OpenupOnDemand(obtainaccessby…)
ClickBAReport,changethereportdate,andreportIDshouldbetheIDinA4(BA946D0D).Runthereport,andcopy&pasteinthescreenshot
RepeattheaboveprocessforID(BA946DLD).
|
|
