text:
A sustainable approach starts at home: with safe workplaces, mutual respect and common values. Our company codes lay the groundwork of how Electrolux is to conduct its business sustainably and responsibly.Read more
Governance structure
The Electrolux Group is comprised of 148 companies with operations in more than 150 countries. The parent company of the Group is AB Electrolux, a public Swedish limited liability company. The company's shares are listed on Nasdaq Stockholm.
The governance of Electrolux is based on the Swedish Companies Act, the rule book for issuers at Nasdaq Stockholm and the Swedish Code of Corporate Governance (the "Code"), as well as other relevant Swedish and foreign laws and regulations.
Topics and categories
Read more within Governance structure
The AGM in 2014 re-elected PricewaterhouseCoopers AB (PwC) as the Group's external auditors for a four-year period, until the AGM in 2018. Authorized Public Accountant Peter Nyllinge is the auditor in charge of Electrolux.Read more
The Articles of Association of a Swedish limited liability company include certain rules governing the business activities of the company.Read more


text:
YORK PENNSYLVANIA COUNTY OF YORK COMPREHENSIVE ANNUAL FINANCIAL REPORT. For the year ended December PREPARED BY THE OFFICE OF THE CONTROLLER
- Ursula Collins
- 2 years ago
- Views:
1 UTY F YRK YRK PESYLVAIA PREHESIVE AUAL FIAIAL REPRT Fo the ye ended Decembe PREPARED BY THE FFIE F THE TRLLER RBERT P GREE TRLLER
3 UTY F YRK PESYLVAIA PREHESE AUAL FIAIAL REPRT FR THE YEAR EDED DEEBER ITRDUTRY SETI Lette oftnsmittl TABLE F TETS Pge o ounty ofyok gniztionl ht8 ounty ofyok fficils9 p ofyok ounty 10 etificte ofachievement fo Excellence in Finncil Repoting 1 l l FIAIAL SETI Independent Auditos Repot 13 ngement s Discussion nd Anlysis 17 Bsic Finncil Sttements 31 Sttement ofet Assets 32 Sttement ofactivities 33 Blnce Sheet Govenmentl Funds 34 Reconcilition ofthe Blnce Sheet of Govenmentl Funds to the Sttement of et Assets 35 Sttement ofrevenues Expenditues nd hnges in Fund Blnces Govenmentl Funds 36 Reconcilition ofthe Sttement of Revenues Expenditues nd hnges in Fund Blnces ofgovenmentl Funds to the Sttement ofactivities 37 Sttement of Fund et Assets Deficit Entepise Funds 38 Sttement of Revenues Expenses nd hnges in Fund et Assets Deficit Entepise Funds 39 Sttement of sh Flows Entepise Funds 40 Sttement offiduciy et Assets Fiduciy Funds 41 Sttementof hnges in Fiduciy et Assets Pension Tust Fund 42 ombining Sttement ofet Assets Discetely Pesented omponent Units 43 ombining Sttement ofactivities Discetely Pesented omponent Units 44 otes to Finncil Sttements 45 Requied Supplementy Infomtion 117 Schedule ofemploye ontibutions nd Funding Pogess 118 Benefits the thn Pensions 119 Schedule of Funding Pogess fo Postemployment Schedule ofrevenues Expenditues nd hnges in Fund Blnces Budget nd Actul Genel Fund 120 Schedule ofrevenues Expenditues nd hnges in Fund Blnces Budget nd Actul Yok Helthhoices ngement Fund 121 Schedule ofrevenues Expenditues nd hnges in Fund Blnces Budget nd Actul entl Helth entl Retdtion Fund 122 Schedule ofrevenues Expenditues nd hnges in Fund Blnces Budget nd Actul hilden nd Youth Fund 123
4 UTY F YRK PESYLVAIA PREHESIVE AUAL FIAIAL REPRT FR THE YEAR EDED DEEBER TABLE F TETS TIUED Pge o Schedule ofrevenues Expenditues nd hnges in Fund BlncesBudget nd Actul ommunity Development Block Gnt Fund124 otes to Requied Supplementy Infomtion125 the Supplementy Infomtion127 ombining nd Individul Fund Finncil Sttements nd Schedules128 ombining Blnce Sheet onmjo Govenmentl Funds 130 ombining Sttement of Revenues Expenditues nd hnges in Fund Blnces Deficit ounjo Govenmentl Funds 132 Schedule ofrevenues Expenditues nd hnges in Fund Blnces Budget nd Actul Liquid Fuels Fund 134 Schedule ofrevenues Expenditues nd hnges in Fund Blnces Budget nd Actul Domestic Reltions Fund 135 Schedule ofrevenues Expenditues nd hnges in Fund BlncesBudget nd Actul ompehensive Sevices to the Aged Fund136 Schedule ofrevenues Expenditues nd hnges in Fund Blnces Budget nd Actul Humn Sevices Fund 137 Schedule ofrevenues Expenditues nd hnges in Fund BlncesBudget nd Actul Dug nd Alcohol Fund 138 Schedule of Revenues Expenditues nd hnges in Fund Blnces Budget nd Actul Adms Helthhoices ngement Fund139 Schedule ofrevenues Expenditues nd hnges in Fund Blnces Budget nd Actul Judicil Assistnce Gnt Fund 140 Schedule ofrevenues Expenditues nd hnges in Fund BlncesBudget nd Actul En It Fund 141 Schedule ofrevenues Expenditues nd hnges in Fund Blnces Budget nd Actul Affodble Housing Fund 142 Schedule ofrevenues Expenditues nd hnges in Fund Blnces Budget nd Actul Wetheiztion Fund 143 Schedule ofrevenues Expenditues nd hnges in Fund Blnces Budget nd Actul Downtown Hnove Impovement Fund 144 Schedule ofrevenues Expenditues nd hnges in Fund Blnces Budget nd Actul ARRA Wetheiztion Fund 145 ombining Sttementof hnges in Assets nd Libilities Agency Funds146 ombining Sttement ofhnges in Assets nd Libilities Row ffices148 ombining Blnce Sheet Agency Funds 149 ii
5 UTY F YRK PESYLVAIA PREHESIVE AUAL FIAIAL REPRT FR THE YEAR EDED DEEBER TABLE F TETS TIUED Pm STATISTIAL SETI et Assets by omponent Lst Ten Yes 151 hnges in et Assets Lst Ten Yes 152 Govenmentl Activities Tx Revenues by Souce Lst Ten Yes ccul 154 Fund Blnces ofgovenmentl Funds Lst Ten Yes 155 hnges in Fund Blnces ofgovenmentl Funds Lst Ten Yes 156 Genel Govenmentl Expenditues by Function Lst Ten Yes 157 Genel Govenmentl Revenues by Souce Lst Ten Yes 158 Govenmentl Funds Tx Revenues by Souce Lst Ten Yes modified ccul 159 Popety Vlues Lst Ten Yes 160 Assessed nd Estimted Actul Vlue oftxble Popety Lst Ten Yes 161 Rel Estte illge Rtes Diect nd velpping Govenments Lst Ten Yes 162 Popety Tx Rtes Diect nd velpping Govenments Lst Ten Yes 163 Pincipl Popety Txpyes 165 Rel Estte Txes Levied nd ollected Lst Ten Yes 166 Rtio of utstnding Debt by Type Lst Ten Yes 167 Rtio ofgenel bligtion Debt to Assessed Vlue of Rel Estte nd Genel bligtion Debt Pe pit Lst Ten Yes 168 Diect nd velpping Govenmentl Activities Debt 169 omputtion of Legl Debt gin Lst Ten Yes 172 Demogphic nd Economic Sttistics Lst Ten Yes 174 Pincipl Employes 175 Employees by Function Pogm Lst Ten Yes 176 peting Indictos by Function Lst Ten Yes 177 pitl Asset Sttistics by Function Lst Ten Yes 181 iii
6 This pge intentionlly left blnk iv
7 ffice of ounty ontolle Robet P Geen ontolle Deboh K yes Deputy ontolle 28 Est ket Steet Room 232 Yok Pennsylvni Voice Fx ounty of Yok Pennsylvni June T THE ISSIERS F YRK UTY PESYLVAIA The ompehensive Annul Finncil Repot AFR egding the ounty of Yok Pennsylvni fo the fiscl ye ended Decembe is submitted heewith This AFR ws peped by the ounty ontolle s ffice Responsibility fo both the ccucy of the pesented dt nd the completeness nd finess of the pesenttion including ll disclosues ests with the ounty We believe the dt s pesented is ccute in ll mteil espects tht it is pesented in mnne designed to fily set foth the finncil position nd chnges in finncil position of the ounty s mesued by the finncil ctivity of its vious funds nd tht ll disclosues necessy to enble the ede to gin cle undestnding of the ounty s finncil ffis hve been included The ogniztion fom nd the contents of this AFR the ccompnying finncil sttements nd the sttisticl tbles wee peped in ccodnce with the stndds estblished by the Govenmentl Accounting Stndds Bod GASB the Govenment Finnce ffices Assocition GFA the Ameicn Institute of etified Public Accountnts AIPA ounty ode ofthe ommonwelth of Pennsylvni nd the ngement s discussion nd nlysis DAimmeditely follows the independent udito s epot nd povides ntive intoduction oveview nd nlysis of the bsic finncil sttements conjunction with it The D A is complement to this lette of tnsmittl nd should be ed in
8 Pofile of the Govenment This AFR includes ll funds of the ounty The ounty povides full nge of sevices These sevices include the cout system pison nusing home 911 emegency opetions cente nd humn sevice pogms onsistent with the guidnce contined in GASB 39 Detemining Whethe etin gniztions e omponent Units n mendment of GASB 14 The Repoting Entity the citei used by the ounty to evlute whethe dditionl entities should be included in the ounty s epoting entity s component units includes whethe the ounty cn impose its will on these entities nd whethe these entities bing the ounty finncil benefit o buden The component units included in the epoting entity e the Yok ounty Solid Wste nd Refuse Authoity YSWRA the Yok ounty Industil Development Authoity YIDA the Yok ounty Liby System YLS nd the Yok ounty Plnning ommission YP The ctivities ofthe Fie hiefs nd Fie Fightes Assocition ofyok ounty FFFAY the Histoicl Society of Yok ounty HSY the Yok ounty onvention nd Touist Bueu YTB the Yok ounty Emegency edicl Sevices Tining Institute YESTI the Yok ounty Industil Development opotion YID the Yok ounty onsevtion Distict YD the Yok ounty Ril Til Authoity YRTA the Penn Stte oopetive Extension Sevice PSES the Yok ounty Tnspottion Authoity YTA nd the Genel Authoity of Southcentl Pennsylvni GASP hve not met the finncil ccountbility citei of GASB 39 nd e ccodingly excluded fom this AFR the elted ogniztions tht hve been excluded e the Yok ounty Pivte Industy ouncil YPI the Yok ounty Hospitl Authoity YHA nd the Yok ounty Ai Tnspottion Authoity YATA The ounty ommissiones e esponsible fo ppointing the membes of the bod fo these ogniztions but the ounty s ccountbility extend beyond mking ppointments does not Locl economy jo industies locted within the govenment s boundies include infomtion nd pofessionl sevices wholesle nd etil tde mnufctuing fims eduction sevices nd helth ce A divesity of industy nd the poximity to Hisbug Bltimoe Wshington nd Phildelphi in the nothesten coido hs helped in dynmic economic gowth The loction ofyok ounty povides two bedoom communities ne community flls in the nothen egion nd tvels to Hisbug fo wok nd the southen egion community tvels to Bltimoe The ounty is seventh in the ommonwelth of Pennsylvni in new home constuction with theyok Hnove egion gowing t fst pce 2
9 As the tionl economy hs fllen into decline jobs hve become scce nd compny lyoffs hve incesed Although in the lst ye Yok ounty hs done bette thn most economies The ounty s unemployment te s of Decembe 2011 ws 71 decese of08 fom s unemployment te of79 The ommonwelth of Pennsylvni nd Decembe 2010 tionl unemployment tes fo Decembe 2011 wee76nd85espectively decesed fom 2010 Yok ounty ws 05 lowe thn the Stte tionl te which both nd 14 lowe thn the Jobs e impotnt but sly is lso lge fcto in whee fmilies will live A lge pt of Yok ounty s gowth is fom the Bltimoe e binging with it highe housing nd sevice costs Yok ounty slies e lowe thn the stte vege nd the diffeence in the popultion gowth te between the county nd the stte hs cused n even lge gp in slies ove the pst decde The ounty in the pst hs dded jobs to djust to the incese in popultion but fctos such s ising costs nd the lck of incese in slies detemines wht fmilies cn ffod whee they will live nd wok Long tem Finncil Plnning Unssigned fund blnce in the genel fund ws90 of totl genel fund evenues t Decembe The ounty dopted foml Fund Blnce Policy in 2011 to be complint with GASB Sttement o 54 Yok ounty is dedicted to mintining esonble fund blnce sufficient to mitigte cuent nd futue finncil isks nd to ensue stble tx tes The policy llows the ounty to effectively ect with existing esouces to emegency situtions nd unnticipted events It lso limits the size of tx nticiption notes mintins o impoves stong bond ting theeby educing futue inteest expense nd execises good fiscl mngement by pemitting the development of moe esponsible nd esponsive long tem finncil pln The ounty infomlly budgets to ppoximte bekeven evenues nd expenses on n nnul bsis nd to etin consistent mount of unssigned fund blnce fom ye to The ounty is not cuently plnning ny significnt inceses in opetions o mjo ye pojects othe thn those ledy in pogess Relevnt Finncil Policies Fo thee consecutive yes in ow nd 2011 budgety guidelines weeissued fo ll deptments so tht the ounty could keep the sme level ofsevice without incesing txes With the decline of the economy the ounty ofyok did not wnt to plce dditionl buden on the txpyes With the exclusion ofsly inceses ll wee deptments tsked with little o no inceses in deptmentl expenditues In 2011 the ounty ofyok dopted Debt ngement Policy The Debt ngement Policy consists of guidelines nd diectives pplicble to the ongoing finncing of cpitl expenditues nd tx nticiption boowings The objectives of the policy is to ssue tht the ounty incus debt only when ppopite nd with long tem pespective to minimize inteest tes nd issunce costs ssocited with the debt to minimize the length nd totl debt sevice cost ove 3
10 the life of debt issue nd to peseve finncing flexibility nd debt cpcity fo futue Bods of ommissiones jo Inititives Fmily Goup Decision king Fmily Goup Decision king is n evidence bsed ppoch tht gives uthoity to nd empowes fmilies by llowing them to dw on fmily expeiences knowledge nd esouces to cete nd implement plns tht povide fo the sfety pemnency nd well being of thei fmily Yok ounty hs been vey successful in utilizing this poven pctice to chieve pemnency ensue sfety nd educe tuncy t highe levels fo childen while ultimtely educing costs fo the county by In eliminting unnecessy plcements 2010 Yok ounty begn poviding this sevice diectly with even gete success Binging the sevice intenlly hs led to supeio qulity of sevice nd incesed ccessibility to the Humn Sevice gencies esulting in bette outcomes onflict Attoney Pnel In 2010 the Yok ounty out of ommon Ples unde the ledeship of then Pesident Judge Renn nd Judge Thompson implemented onflict Attoney Pnel in ode to educe the esclting cost ofthid pty contcted specil counsel fees The ounty ofyok ws incuing ove12 million of specil counsel fees nnully fo ttoneys who epesented indigent clients who could not be defended by the Public Defende s ffice due to conflict of inteest pnel is compised of eleven ttoneys ssigned to hndle ciminl nd juvenile delinquency cses nd two ttoneys to hndle mentl helth elted cses Pnel ttoneys e compensted t n nnul sly of nd espectively nd e ssigned fixed numbe of cses on n nnul bsis The implementtion of the onflict Attoney Pnel hs been instumentl in educing out ppointed thid pty ttoney fees by ppoximtely ye The Wok Relese Fcility The ounty of Yok hs long been ecognized fo its pogessive ltentive sentencing pogms designed to void inccetion fo non violent offendes ehbilitte inmtes nd educe ecidivism Among the moe effective pogms hs been the Pison Wok Relese pogm Inmtes who exhibit good behvio nd demonstte willingness to integte bck into the community e given the oppotunity to wok outside the pison envionment with ptneing businesses nd community ogniztions With cuent cpcity of 150 inmtes housed in minimum secuity fcility the Wok Relese pogm cnnot ccommodte ll those who wish to pticipte To expnd the pogm the ounty hs cquied sq foot popety djcent to the Pison fcility A 69 million enovtion poject is cuently undewy to econfigue the popety to house up to 300 wok elese inmtes in minimum housing ngement tht will lso fcilitte the necessy suppot nd dministtive functions 4
11 Yok ounty Tetment outs The Yok ounty Tetment outs stted with the implementtion of the Dug Tetment out in 1997 followed by the entl Helth Tetment in 2005 DU Tetment out in 2010 nd the Vetens Tetment out in 2012 As of Decembe clients hve gduted fom Yok ounty Tetment out Pogm In 2011 lone ove jil dys wee sved esulting in n ovell cost svings of to the ounty Seventy five pecent of the 2011 gdutes wee employed t the time of gdution Sixty one pecent of the gdutes pid in full thei costs nd estitution with the emining gdutes locked into pyment plns with the ounty ofyok The ecidivism te is 26 which is dmticlly less thn the ntionl vege lients e equied to hve thei high school diplom GED o bsic eding skills in ode to gdute Intngible benefits fo the gdutes include eunifiction with thei fmilies including thei childen nd becoming poductive positive membe of society The Dug Tetment out ws selected by the tionl Dug out Institute s one of ten tionl ento outs in the tion nd povides tining to couts which e stting such cout Vetens out Resulting fom ou mility opetions in Iq nd Afghnistn n estimted Vetens unde the ge of25 suffe fom substnce buse o mentl helth disode nd these dignoses hve incesed nely 40 pecent since 2004 Left unteted they cn diectly led to homelessness nd involvement in the ciminl justice system outs ound the county e epoting n incese in the numbe of Vetens they e seeing nd in esponse e ceting Vetens Tetment outs Vetens Tetment outs e hybid Dug nd entl Helth outs tht ecognize the unique mility cultue while ddessing distinct Veten issues such spost tumtic Stess Disode Tumtic Bin Injuy nd ility Sexul Tum The Vetens Tetment out seeks to divet eligible veten defendnts with substnce dependency nd o mentl illness tht e chged with ciminl offense to specilized ciminl cout docket Vetens e identified though sceening nd ssessments The vetens voluntily pticipte in judicilly supevised tetment pln tht tem ofcout stff veten helth ce pofessionls veten pee mentos Alcohol Dug helth ce pofessionls nd mentl helth pofessionls develop with the veten Upon successful completion of the pogm pending chges mybe educed o dopped depending on thei seveity DUI out Expnsion In ely 2011 the iminl Justice Advisoy Bod JAB t the equest of Pesident Judge Stephen Linebugh decided to mke the mngement of DUI cses pioity becuse they one epesent thid of ou ciminl cse lod The JAB fomed colition of stkeholdes including the ounty ommissiones out of ommon Ples Judges Distict out Judges out Administtion the lek of outs the Distict Attoney s ffice the Public Defende s ffice the Pobtion Deptment the Yok 5
12 ounty Pison Yok Adms Dug nd Alcohol the Sheiff s ffice the Yok ounty Police hiefs Assocition nd vious othe lw enfocement gencies JAB s eview ofthe poblem eveled tht ppoximtely 25 of offendes wee epet offendes A close look t these cses lso eveled n oppotunity to focus on impoving public sfety nd poviding these offendes with n oppotunity fo tetment All individuls stopped fo DUI e sceened nd if they e epet offendes they will be fitted with n lcohol monitoing bcelet within dys of thei stop The weing ofthis bcelet nd stying lcohol fee will be condition ofthei bil The pevious pocedue llowed defendnts to emin fee without estiction until they wee sentenced u expeience hs been tht most ofthese folks will cndidly dmit tht without the bcelet they would hve continued to dink nd dive With the new pogm ech individul is lso equied s condition of bil to obtin dug nd lcohol evlution nd comply with tetment Bnkuptcy Tustee Heings ofjustice in The Bnkuptcy Tustee Pogm ws estblished by the United Sttes Deptment the 1970 s fo the pupose of hving people who filed Bnkuptcy ppe befoe n ppointed Tustee to nswe questions egding thei finncil cicumstnces nd bility to py debt Those heings hve been conducted in the pst in the Yok ounty Judicil ente Jnuy e now being conducted in the Yok ounty Administtion ente nd since esidents who hve filed fo By conducting these heings loclly those Yok ounty Bnkuptcy s well s thei ttoneys e llowed to ttend the heing within Yok ounty insted ofhving to tvel to Hisbug to ppe t heing in the Fedel Building ot only is this significnt convenience fo the esidents ofyok ounty but it is moe cost effective nd efficient wy of hndling these heings The svings on gs is consideble All of this esults in bette sevice to the Yok ounty esidents who e ledy fcing significnt finncil hdships s most Bnkuptcies e cused by job loss illness nd divoce with the esulting foeclosues nd loss ofothe ssets Awds nd Acknowledgements The Govenment Finnce ffices Assocition GFA wded etificte of Achievement fo Excellence in Finncil Repoting to the ounty of Yok fo its compehensive nnul finncil epot AFR fo the fiscl ye ended Decembe This is the twentieth consecutive ye tht Yok ounty hs chieved this pestigious wd In ode to be wded etificte of Achievement the govenment hd to publish n esily edble nd efficiently ognized compehensive nnul finncil epot tht stisfied both genelly ccepted ccounting pinciples nd pplicble legl equiements A etificte ofachievement is vlid fo peiod of one ye only AFR continues to meet the etificte of Achievement Pogm s equiements submitting it to the GFA to detemine its eligibility fo nothe cetificte We believe tht ou cuent nd we e 6
13 The completion of this AFR epesents the twenty fist time Yok ounty hs peped such epot nd demonsttes commitment to continue the excellence in finncil epoting peviously ecognized It could not hve been completed in such no on compehensive mnne timely bsis without the input nd suppot fom numbe of people whom I wish to cknowledge nd expess my thnks nd ppecition to now Felici Dell Diecto of the Yok ounty Plnning ommission John Fedo Diecto hief Assesso of the Yok ounty Assessment ffice the Yok ounty school disticts nd locl municiplities nd especilly to Deboh yes Deputy ontolle nd ll the employees on my stff who hve contibuted on dily bsis to mking this epot possible Sinceely Robet P Geen ontolle 7
14 m f z U f c o ts m y 3 o yo i o o 8 Y p U m c Z i v f0 J V in o w fn y c 0 0 d ti U 0 Q d U w Z W Z W V W DD Z U Y ts w T 1 j d Q V i 7 Z e0 f0 7 U U Q o U in Q l U U Z ts p U U to Q w Q to T w t U m Z c v E m Q d U 2 7 m c e w y T p f4 Q d y L y U U d U U H
15 YRK UTY FFIIALS Decembe JUDIIARY URT F PLEAS PRESIDET JUDGE JUDGE JUDGE JUDGE JUDEG JUDGE JUDGE JUDGE JUDGE JUDGE JUDGE JUDGE JUDGE HRABLE STEPHE P LIEBAUGH HRABLE JSEPH ADAS HRABLE PEY L BLAKWELL HRABLE IHAEL E BRTER HRABLE JH H HRISTER HRABLE SHERYL A DREY HRABLE THAS H KELLEY VI HRABLE JH S KEEDY HRABLE ARIA USTI K HRABLE HARRY ESS HRABLE RIHARD K RE HRABLE GREGRY SYDER HRABLE JHW THPS JR ELETED UTY FFIIALS UTY ISSIER HAIRPERS UTY ISSIER UTY ISSIER UTY TRLLER UTY RER UTY TREASURER RERDER F DEEDS REGISTER F WILLS LERK F URTS PRTHTARY SHERIFF DISTRIT ATTREY STEVE HRISTER HRISTPHER B REILLY P DUGLAS HKE RBERT P GREE BARRY L BLSS BARBARA L BAIR RADI L REISIGER BRADLEY JABS DALD RSHELL JR PAELA S LEE RIHARD P KEUERLEBER III THAS L KEAREY 9
17 etificte of Achievement fo Excellence in Finncil Repoting Pesented to ounty of Yok Pennsylvni Fo its ompehensive Annul Finncil Repot fo the Fiscl Ye Ended Decembe A etificte of Achievement fo Excellence in Finncil Repoting is pesented by the Govenment Finnce ffices Assocition of the United Sttes nd nd to govenment units nd public employee etiement systems whose compehensive nnul finncil epots AFRs chieve the highest stndds in govenment ccounting nd finncil epoting e dn Ex uttit 11
18 This pge intentionlly left blnk 12
19 Zelenkofske Axelod LL IDEPEDET AUDITRS REPRT ounty ommissiones of Yok ounty Yok Pennsylvni We hve udited the ccompnying finncil sttements of the govenmentl ctivities the business type ctivities the ggegte discetely pesented component units ech mjo fund nd the ggegte emining fund infomtion of the UTY F YRK s of nd fo the ye ended Decembe which collectively compise the finncil sttements s listed in the tble of contents UTY F YRK s bsic These finncil sttements e the esponsibility of the UTY F YRK s mngement u esponsibility is to expess opinions on these finncil sttements bsed on ou udit We did not udit the discetely pesented component units finncil sttements fo the Yok ounty Solid Wste nd Refuse Authoity the Yok ounty Industil Development Authoity nd the Yok ounty Plnning ommission which epesent nd 894of the ssets net ssets nd evenues espectively of the ggegte discetely pesented component units Those finncil sttements wee udited by othe uditos whose epots theeon hve been funished to us nd ou opinion insof s it eltes to the mounts included fo those ggegte discetely pesented component units is bsed upon the epots of the othe uditos We conducted ou udit in ccodnce with uditing stndds genelly ccepted in the United Sttes of Ameic nd the stndds pplicble to finncil udits contined in Govenment Auditing Stndds issued by the omptolle Genel of the United Sttes The finncil sttements of the Yok ounty Solid Wste nd Refuse Authoity the Yok ounty Industil Development Authoity nd the Yok ounty Liby System wee not udited in ccodnce with Govenment Auditing Stndds Those stndds equie tht we pln nd pefom the udit to obtin esonble ssunce bout whethe the finncil sttements e fee of mteil missttement An udit includes exmining on test bsis evidence suppoting the mounts nd disclosues in the finncil sttements An udit lso includes ssessing the ccounting pinciples used nd significnt estimtes mde by mngement s well s evluting the ovell finncil sttement pesenttion We believe tht ou udit nd the epots of othe uditos povide esonble bsis fo ou opinions In ou opinion bsed on ou udit nd the epots of othe uditos the finncil sttements efeed to bove pesent fily in ll mteil espects the espective finncil position of the govenmentl ctivities the business type ctivities the ggegte discetely pesented component units ech mjo fund nd the ggegte emining fund infomtion of the UTY F YRK s of Decembe nd the espective chnges in finncil position nd whee pplicble csh flows theeoffo the ye then ended in confomity with ccounting pinciples genelly ccepted in the United Sttes ofameic Hisbug Lehigh Vlley Phildelphi Pittsbugh 830 Si Thoms out Suite West Hmilton Steet 2370 Yok Rod Suite A cknight E Dive Suite 3805 Hisbug PA Allentown PA Jmison PA Pittsbugh PA Fx Fx Fx Fx
20 Zelenkofske Axelod LL ounty ommissiones ounty of Yok Yok Pennsylvni As descibed in ote 1 povisions of Govenmentl Accounting to the finncil sttements in 2011 the UTY F YRK dopted the Stndds Bod s Sttement o 54 Fund Blnce Repoting nd Govenmentl Fund Type Definitions nd Sttement o 59 Finncil Instuments mnibus In ccodnce with Govenment Auditing Stndds we hve lso issued ou epot dted June on ou considetion ofthe UTY F YRK s intenl contol ove finncil epoting nd ou tests of its complince with cetin povisions of lws egultions contcts nd gnt geements nd othe mttes The pupose of tht epot is to descibe the scope of ou testing of intenl contol ove finncil epoting nd complince nd the esults of tht testing nd not to povide n opinion on the intenl contol ove finncil o on epoting complince Tht epot is n integl pt of n udit pefomed in ccodnce with Govenment Auditing Stndds nd should be consideed in ssessing the esults of ou udit Accounting pinciples genelly ccepted in the United Sttes of Ameic equie tht mngement s discussion nd nlysis schedule of employe contibutions nd funding pogess schedule of funding pogess fo postemployment benefits othe thn pensions nd budgety compison schedules on pges 17 though 29 pge 118 pge 119 nd pges 120 though 124 be pesented to supplement the bsic finncil sttements Such infomtion lthough not pt of the bsic finncil sttements is equied by the Govenmentl Accounting Stndds Bod who consides it to be n essentil pt of finncil epoting fo plcing the bsic finncil sttements in n ppopite opetionl economic o histoicl context We hve pplied cetin limited pocedues to the equied supplementy infomtion in ccodnce with uditing stndds genelly ccepted in the United Sttes of Ameic which consisted of inquies of mngement bout the methods of peping the infomtion nd comping the infomtion fo consistency with mngement sesponses to ou inquiies the bsic finncil sttements nd othe knowledge we obtined duing ou udit of the bsic finncil sttements We do not expess n opinion o povide ny ssunce on the infomtion becuse the limited pocedues do not povide us with sufficient evidence to expess n opinion o povide ny ssunce u udit ws conducted fo the pupose of foming opinions on the finncil sttements tht collectively compise the UTY F YRK s finncil sttements s whole The intoductoy section combining nd individul nonmjo fund finncil sttements nd budget nd ctul schedules nd sttisticl section e pesented fo the puposes of dditionl nlysis nd e not equied pt ofthe finncil sttements The combining nd individul nonmjo fund finncil sttements nd budget nd ctul schedules e the esponsibility of mngement nd wee deived fom nd elte diectly to the undelying ccounting nd othe ecods used to pepe the finncil sttements The infomtion hs been subjected to the uditing pocedues pplied in the udit ofthe finncil sttements nd cetin dditionl pocedues including 14
21 Zelenkofske Axelod LL ounty ommissiones ounty of Yok Yok Pennsylvni comping nd econciling such infomtion diectly to the undelying ccounting nd othe ecods used to pepe the finncil sttements o to the finncil sttements themselves nd othe dditionl pocedues in ccodnce with uditing stndds genelly ccepted in the United Sttes of Ameic In ou opinion the infomtion is fily stted in ll mteil espects in eltion to the finncil sttements s whole The intoductoy nd sttisticl sections hve not been subjected to the uditing pocedues pplied in the udit of the bsic finncil sttements nd ccodingly we do not expess n opinion o povide ny ssunce on them ZELEKFSKE AXELRD LL Hisbug Pennsylvni June
22 This pge intentionlly left blnk 16
23 ounty of Yok Pennsylvni ngement s Discussion nd Anlysis Intoduction The following discussion nd nlysis of the ounty ofyok s finncil sttements povides n oveview of the finncil pefomnce fo the fiscl ye ended Decembe It is ecommended tht it be ed in conjunction with the bsic finncil sttements nd the ccompnying notes to those sttements in ode to obtin thoough undestnding of the ounty ofyok s finncil condition s of Decembe etin eclssifictions wee mde to pio ye mounts to confom to the cuent ye pesenttion Finncil Highlights The ounty hd of govenmentl ctivities genel obligtion debt outstnding s of Decembe This epesents n incese of o16 fom the pevious ye The incese petins to debt issued of70 million tht ws offset by pincipl pyments of 40 million Business type ctivities genel obligtion debt decesed s esult of pincipl pyments in the mount of16 million As of Decembe the business type ctivities genel obligtion debt outstnding ws The ssets ofthe ounty s govenmentl ctivities exceeded its libilities s ofdecembe by net ssets f this mount thee ws deficit of unesticted net ssets of Yok ounty s totl pimy govenment net ssets decesed by 205 million et ssets ofthe govenmentl ctivities decesed by 21 million o million elted to the decese in the fi mket vlue ofinvestment deivtives 31 million fo the incese in the genel obligtions debt 30 million fo the nnul equied contibution tht ws not funded fo PEB benefits in the cuent ye nd06 million fo the unfunded nnul equied contibution AR to the pension pln The emining decese is futhe detiled on pge 21 of this D A The net ssets of the business to the type ctivities incesed by06 million o62 The incese ws due pimily eduction of genel obligtion debt nd libility fo wokes compenstion of 16 million nd06 million espectively offset by14 million nnul equied contibution tht wsnot funded fo PEB benefits in the cuent ye At the end of the fiscl ye Yok ounty s govenmentl funds epoted combined ending fund blnces of decese of in compison with the pio ye Appoximtely 341 of this totl mount is vilble fo spending t the govenment s discetion unssigned fund blnces within the boundies set foth in the govenmentl fund s pupose which is consistent with pio yes The mjoity of this decese is eflected in the Genel Fund o 128decese fom the pio ye esulting fom highe expenditues nd tnsfes out 17
Screentrade Car Insurance Policy Summary
Sceentde C Insunce Policy Summy This is summy of the policy nd does not contin the full tems nd conditions of the cove, which cn be found in the policy booklet nd schedule. It is impotnt tht you ed theMore information
Highest Pefomnce Lowest Pice PRODUCT COMPARISON GFI MilAchive vs Symntec Entepise Vult GFI Softwe www.gfi.com GFI MilAchive vs Symntec Entepise Vult GFI MilAchive 6 Symntec Entepise Vult Who we e GenelMore information
GFI MilAchive 6 vs H&S Exchnge@PAM GFI Softwe www.gfi.com GFI MilAchive 6 vs H&S Exchnge@PAM GFI MilAchive 6 H&S Exchnge@PAM Who we e Genel fetues Suppots Micosoft Exchnge 2000, 2003 & 2007 Suppots distibutedMore information
GFI MilAchive 6 vs EMC EmilXtende Achive Edition GFI Softwe www.gfi.com GFI MilAchive 6 vs EMC EmilXtende Achive Edition GFI MilAchive 6 EMC EmilXtende Achive Edition Who we e Genel fetues Suppots MicosoftMore information
2001 Attachment Sequence No. 118
Form Deprtment of the Tresury Internl Revenue Service Importnt: Return of U.S. Persons With Respect to Certin Foreign Prtnerships Attch to your tx return. See seprte instructions. Informtion furnishedMore information
Orbits and Kepler s Laws
Obits nd Keple s Lws This web pge intoduces some of the bsic ides of obitl dynmics. It stts by descibing the bsic foce due to gvity, then consides the ntue nd shpe of obits. The next section consides howMore information
GFI EventsMnge vs Netikus.net EventSenty GFI Softwe www.gfi.com GFI EventsMnge vs Netikus.net EventSenty GFI EventsMnge EventSenty Who we e Suppot fo MS SQL Seve Suppot fo MSDE / MS SQL Expess Suppot foMore information
GFI MilAchive 6 vs Wtefod Technologies MilMete Achive GFI Softwe www.gfi.com GFI MilAchive 6 vs Wtefod Technologies MilMete Achive Genel fetues Suppots Micosoft Exchnge 2000, 2003 & 2007 Suppots distibutedMore information
GFI MilEssentils & GFI MilSecuity vs Bcud Spm Fiewll GFI Softwe www.gfi.com GFIMilEssentils & GFI MilSecuity vs Bcud Spm Fiewll GFI MilEssentils 12 & GFI MilSecuity 10 Bcud Spm Fiewll Who we e IntegtesMore information
tools for Web data extraction
HTML-we tools fo Web dt extction Thesis pesenttion 1 Student: Xvie Azg Supeviso: Andes Tho Tble of contents Intoduction Dt Extction Pocess Dt Extction Tools Relized tests Futue Wok 2 Intoduction We e goingMore information
Housing as a Commodity
Housing Issues nd Policy, Ubn Studies Pogmme, CUHK URSP300 Housing s Commodity by D Edwd CY Yiu Associte Pofesso Dept of Geogphy nd Resouce Mngement, Chinese Univesity of Hong Kong Expected Outcomes WhtMore information
(1) continuity equation: 0. momentum equation: u v g (2) u x. 1 a
Comment on The effect of vible viscosity on mied convection het tnsfe long veticl moving sufce by M. Ali [Intentionl Jounl of Theml Sciences, 006, Vol. 45, pp. 60-69] Asteios Pntoktos Associte PofessoMore information
for Student Service Members and Veterans in Indiana
Apil 2009 The Highe Eduction Lndscpe fo Student Sevice Membes nd Vetens in Indin Mtin Stenbeg, Shelley McDemid Wdswoth, Jo Vughn, nd Ryn Clson Mility Fmily Resech Institute t Pudue Univesity Suppot LenMore information
GFI MilEssentils & GFI MilSecuity vs Tend Mico ScnMil Suite fo Micosoft Exchnge GFI Softwe www.gfi.com GFI MilEssentils & GFI MilSecuity vs Tend Mico ScnMil Suite fo Micosoft Exchnge Exchnge Seve 2000/2003More information
by K.-H. Rutsch*, P.J. Viljoen*, and H. Steyn* The need for systematic project portfolio selection
An investigtion into the cuent pctice of poject potfolio selection in esech nd development division of the South Aficn minels nd enegy industy by K.-H. Rutsch*, P.J. Viljoen*, nd H. Steyn* J o u n l SynopsisMore information
Health insurance exchanges What to expect in 2014
Helth insurnce exchnges Wht to expect in 2014 33096CAEENABC 02/13 The bsics of exchnges As prt of the Affordble Cre Act (ACA or helth cre reform lw), strting in 2014 ALL Americns must hve minimum mountMore information
Summary: Vectors. This theorem is used to find any points (or position vectors) on a given line (direction vector). Two ways RT can be applied:
Summ: Vectos ) Rtio Theoem (RT) This theoem is used to find n points (o position vectos) on given line (diection vecto). Two ws RT cn e pplied: Cse : If the point lies BETWEEN two known position vectosMore information
Health insurance marketplace What to expect in 2014
Helth insurnce mrketplce Wht to expect in 2014 33096VAEENBVA 06/13 The bsics of the mrketplce As prt of the Affordble Cre Act (ACA or helth cre reform lw), strting in 2014 ALL Americns must hve minimumMore information
N V V L. R a L I. Transformer Equation Notes
Tnsfome Eqution otes This file conts moe etile eivtion of the tnsfome equtions thn the notes o the expeiment 3 wite-up. t will help you to unestn wht ssumptions wee neee while eivg the iel tnsfome equtionsMore information
Random Variables and Distribution Functions
Topic 7 Rndom Vibles nd Distibution Functions 7.1 Intoduction Fom the univese of possible infomtion, we sk question. To ddess this question, we might collect quntittive dt nd ognize it, fo emple, usingMore information
Pre-Approval Application
Pre-Approvl Appliction In tody s rel estte mrket, Pre-Approved mortgge provides you the buyer with powerful tool in the home purchse process! Once you hve received your Pre-Approvl, you cn shop for yourMore information
Math 1105: Calculus II (Math/Sci majors) MWF 11am / 12pm, Campion 235 Written homework 5
Mth 5: Clculus II Mth/Sci mjos) MWF m / pm, Cmpion 35 Witten homewok 5 6.6, p. 458 3,33), 6.7, p. 467 8,3), 6.875), 7.58,6,6), 7.44,48) Fo pctice not to tun in): 6.6, p. 458,8,,3,4), 6.7, p. 467 4,6,8),More information
A Simple Method for Generating Rational Triangles
A Simple Method fo Geneting Rtionl Tingles Konstntine Zelto Deptment Of Mthemtics College Of Ats And Sciences Mil Stop 94 Univesity Of Toledo Toledo,OH 43606-3390 U.S.A. Intoduction The pupose of thisMore information
GFI MilEssentils & GFI MilSecuity vs Symntec Bightmil 6 & Anti Vius GFI Softwe www.gfi.com GFI MilEssentils & GFI MilSecuity vs Symntec Bightmil 6 & Anti Vius GFI MilEssentils & GFI MilSecuity BightmilMore information
Health insurance exchanges What to expect in 2014
Helth insurnce exchnges Wht to expect in 2014 33096CAEENABC 11/12 The bsics of exchnges As prt of the Affordble Cre Act (ACA or helth cre reform lw), strting in 2014 ALL Americns must hve minimum mountMore information
INITIAL MARGIN CALCULATION ON DERIVATIVE MARKETS OPTION VALUATION FORMULAS Vesion:.0 Date: June 0 Disclaime This document is solely intended as infomation fo cleaing membes and othes who ae inteested inMore information
Fatigue knowledge a new lever in safety management
text:templte Jounl 1/20/11 12:43 PM Pge 1 Ftigue knowledge new leve in sfety mngement by W.J. Theon* nd G.M.J. vn Heeden J o u n l Synopsis The pupose of the ppe is to give n intoduction to the conceptMore information
ClearPeaks Customer Care Guide. Business as Usual (BaU) Services Peace of mind for your BI Investment
ClerPeks Customer Cre Guide Business s Usul (BU) Services Pece of mind for your BI Investment ClerPeks Customer Cre Business s Usul Services Tble of Contents 1. Overview...3 Benefits of Choosing ClerPeksMore information
Corporate Compliance vs. Enterprise-Wide Risk Management
Corporte Complince vs. Enterprise-Wide Risk Mngement Brent Sunders, Prtner (973) 236-4682 November 2002 Agend Corporte Complince Progrms? Wht is Enterprise-Wide Risk Mngement? Key Differences Why WillMore information
Active & Retiree Plan: Trustees of the Milwaukee Roofers Health Fund Coverage Period: 06/01/2015-05/31/2016 Summary of Benefits and Coverage:
Summry of Benefits nd Coverge: Wht this Pln Covers & Wht it Costs Coverge for: Single & Fmily Pln Type: NPOS This is only summry. If you wnt more detil bout your coverge nd costs, you cn get the completeMore information
Anthem Blue Cross Life and Health Insurance Company University of Southern California Custom Premier PPO 800/20%/20%
Anthem Blue Cross Life nd Helth Insurnce Compny University of Southern Cliforni Custom Premier 800/20%/20% Summry of Benefits nd Coverge: Wht this Pln Covers & Wht it Costs Coverge Period: 01/01/2015-12/31/2015More information
Implementation and Evaluation of Transparent Fault-Tolerant Web Service with Kernel-Level Support
Poceedings of the IEEE Intentionl Confeence on Compute Communictions nd Netwoks Mimi, Floid, pp. 63-68, Octobe 2002. Implementtion nd Evlution of Tnspent Fult-Tolent Web Sevice with Kenel-Level SuppotMore information
Adaptive Control of a Production and Maintenance System with Unknown Deterioration and Obsolescence Rates
Int J of Mthemtic Sciences nd Appictions, Vo, No 3, Septembe Copyight Mind Rede Pubictions wwwjounshubcom Adptive Conto of Poduction nd Mintennce System with Unknown Deteiotion nd Obsoescence Rtes FwzyMore information
Ridgewood South Natural Areas Priority Evaluation. Background Report
Ridgewood South Nturl Ares Priority Evlution Bckground Report September 2013 Ridgewood South Nturl Ares Priority Evlution Bckground Report Ridgewood South Nturl Ares Priority Evlution Bckground ReportMore information
Laplace s Equation on a Disc
LECTURE 15 Lplce s Eqution on Disc Lst time we solved the Diichlet poblem fo Lplce s eqution on ectngul egion. Tody we ll look t the coesponding Diichlet poblem fo disc. Thus, we conside disc of dius 1More information
Continuous Compounding and Annualization
Continuous Compounding and Annualization Philip A. Viton Januay 11, 2006 Contents 1 Intoduction 1 2 Continuous Compounding 2 3 Pesent Value with Continuous Compounding 4 4 Annualization 5 5 A Special PoblemMore information
SOEPpapers on Multidisciplinary Panel Data Research
Deutsches Institut fü Witschftsfoschung www.diw.de SOEPppes on Multidiscipliny Pnel Dt Resech 136 Thoms Conelissen John S. Heywood Uwe Jijhn S, Pefomnce Py, Risk Attitudes nd Job Stisfction Belin, OctobeMore information
Chapter 3 Savings, Present Value and Ricardian Equivalence
Chapte 3 Savings, Pesent Value and Ricadian Equivalence Chapte Oveview In the pevious chapte we studied the decision of households to supply hous to the labo maket. This decision was a static decision,More information
JaERM Software-as-a-Solution Package
JERM Softwre-s--Solution Pckge Enterprise Risk Mngement ( ERM ) Public listed compnies nd orgnistions providing finncil services re required by Monetry Authority of Singpore ( MAS ) nd/or Singpore StockMore information
9:6.4 Sample Questions/Requests for Managing Underwriter Candidates
9:6.4 INITIAL PUBLIC OFFERINGS 9:6.4 Sample Questions/Requests fo Managing Undewite Candidates Recent IPO Expeience Please povide a list of all completed o withdawn IPOs in which you fim has paticipatedMore information
Move, Inc. 2010 Citi EMT Conference January 5, 2010
Move, Inc. 2010 Citi EMT Conference Jnury 5, 2010 Sfe Hrbor Sttement 2 This presenttion my contin forwrd-looking sttements, including informtion bout mngement s view of Move s future expecttions, plnsMore information
Humana Critical Illness/Cancer
Humn Criticl Illness/Cncer Criticl illness/cncer voluntry coverges py benefits however you wnt With our criticl illness nd cncer plns, you'll receive benefit fter serious illness or condition such s hertMore information
In-stope bolting for a safer working environment
text:templte Jounl 2/3/10 9:34 AM Pge 47 In-stope bolting fo sfe woking envionment by P. Henning* nd P. Feei* J o u n l Synopsis Rock fll ccidents continue to be the min cuse of ftl nd seious injuies inMore information
DlNBVRGH + Sickness Absence Monitoring Report. Executive of the Council. Purpose of report
DlNBVRGH + + THE CITY OF EDINBURGH COUNCIL Sickness Absence Monitoring Report Executive of the Council 8fh My 4 I.I...3 Purpose of report This report quntifies the mount of working time lost s result ofMore information
Yer STATUS OF LAND-BASED WIND ENERGY Deutsche WindGurd GmbH - Oldenburger Strße 65-26316 Vrel - Germny +49 (4451)/9515 - email@example.com - www.windgurd.com Annul Added Cpcity [MW] Cumultive Cpcity [MW]More information
Things to Remember. r Complete all of the sections on the Retirement Benefit Options form that apply to your request.
Retiement Benefit 1 Things to Remembe Complete all of the sections on the Retiement Benefit fom that apply to you equest. If this is an initial equest, and not a change in a cuent distibution, emembe toMore information
Instructions to help you complete your enrollment form for HPHC's Medicare Supplemental Plan
Instuctions to help you complete you enollment fom fo HPHC's Medicae Supplemental Plan Thank you fo applying fo membeship to HPHC s Medicae Supplement plan. Pio to submitting you enollment fom fo pocessing,More information
883 Brochure A5 GENE ss vernis.indd 1-2
ess x a eu / u e a. p o.eu c e / :/ http EURAXESS Reseaches in Motion is the gateway to attactive eseach caees in Euope and to a pool of wold-class eseach talent. By suppoting the mobility of eseaches,More information
Curvature. (Com S 477/577 Notes) Yan-Bin Jia. Oct 8, 2015
Cuvtue Com S 477/577 Notes Yn-Bin Ji Oct 8, 205 We wnt to find mesue of how cuved cuve is. Since this cuvtue should depend only on the shpe of the cuve, it should not be chnged when the cuve is epmetized.More information
Software Engineering and Development
I T H E A 67 Softwae Engineeing and Development SOFTWARE DEVELOPMENT PROCESS DYNAMICS MODELING AS STATE MACHINE Leonid Lyubchyk, Vasyl Soloshchuk Abstact: Softwae development pocess modeling is gainingMore information
Long Term Financial Planning
Long Term Finncil Plnning Overview of New Pltform City of Knss City, Missouri 2013 2018 Long term finncil plnning combines finncil forecsting with finncil strtegizing to identify future chllenges nd opportunitiesMore information
Vendor Rating for Service Desk Selection
Vendor Presented By DATE Using the scores of 0, 1, 2, or 3, plese rte the vendor's presenttion on how well they demonstrted the functionl requirements in the res below. Also consider how efficient nd functionlMore information
r (1+cos(θ)) sin(θ) C θ 2 r cos θ 2
icles xmple 66: Rounding one ssume we hve cone of ngle θ, nd we ound it off with cuve of dius, how f wy fom the cone does the ound stt? nd wht is the chod length? (1+cos(θ)) sin(θ) θ 2 cos θ 2 xmple 67:More information
Your duty, however, does not require disclosure of matter:
Your Duty of Disclosure Before you enter into contrct of generl insurnce with n insurer, you hve duty, under the Insurnce Contrcts Act 1984 (Cth), to disclose to the insurer every mtter tht you know, orMore information
Innovative concepts in underground materials handling
Innovtive concepts in undegound mteils hndling by M. Fuchs* J o u n l Synopsis Thee is still dive woldwide to impove on existing methods of mining. The demnd is fo mining volumes to be incesed while theMore information
Circles and Tangents with Geometry Expressions
icles nd Tngents with eomety xpessions IRLS N TNNTS WITH OMTRY XPRSSIONS... INTROUTION... 2 icle common tngents... 3 xmple : Loction of intesection of common tngents... 4 xmple 2: yclic Tpezium definedMore information
Small Business Networking
Why Network is n Essentil Productivity Tool for Any Smll Business TechAdvisory.org SME Reports sponsored by Effective technology is essentil for smll businesses looking to increse their productivity. ComputerMore information
Faithful Comptroller s Handbook
Faithful Comptolle s Handbook Faithful Comptolle s Handbook Selection of Faithful Comptolle The Laws govening the Fouth Degee povide that the faithful comptolle be elected, along with the othe officesMore information
Intro to Circle Geometry By Raymond Cheong
Into to Cicle Geomety By Rymond Cheong Mny poblems involving cicles cn be solved by constucting ight tingles then using the Pythgoen Theoem. The min chllenge is identifying whee to constuct the ight tingle.More information
Office of Family Assistance. Evaluation Resource Guide for Responsible Fatherhood Programs
Office of Family Assistance Evaluation Resouce Guide fo Responsible Fathehood Pogams Contents Intoduction........................................................ 4 Backgound..........................................................More information
The strategic and tactical value of a 3D geotechnical model for mining optimization, Anglo Platinum, Sandsloot open pit
The sttegic nd tcticl vlue of 3D geotechnicl model fo mining optimiztion, Anglo Pltinum, Sndsloot open pit by A. Bye* J o u n l Synopsis Sndsloot open pit is situted on the nothen limb of the BushveldMore information
Utilization of Smoking Cessation Benefits in Medicaid Managed Care, 2009-2013
Utiliztion of Smoking Cesstion Benefits in Medicid Mnged Cre, 2009-2013 Office of Qulity nd Ptient Sfety New York Stte Deprtment of Helth Jnury 2015 Introduction According to the New York Stte Tocco ControlMore information
Enterprise Risk Management Software Buyer s Guide
Enterprise Risk Mngement Softwre Buyer s Guide 1. Wht is Enterprise Risk Mngement? 2. Gols of n ERM Progrm 3. Why Implement ERM 4. Steps to Implementing Successful ERM Progrm 5. Key Performnce IndictorsMore information
Exam in physics, El-grunder (Electromagnetism), 2014-03-26, kl 9.00-15.00
Umeå Univesitet, Fysik 1 Vitly Bychkov Em in physics, El-gunde (Electomgnetism, 14--6, kl 9.-15. Hjälpmedel: Students my use ny book(s. Mino notes in the books e lso llowed. Students my not use thei lectueMore information
c. Values in statements are broken down by fiscal years; many projects are
Lecture 18: Finncil Mngement (Continued)/Csh Flow CEE 498 Construction Project Mngement L Schedules A. Schedule.of Contrcts Completed See Attchment # 1 ll. 1. Revenues Erned 2. Cost of Revenues 3. GrossMore information
est using the formula I = Prt, where I is the interest earned, P is the principal, r is the interest rate, and t is the time in years.
9.2 Inteest Objectives 1. Undestand the simple inteest fomula. 2. Use the compound inteest fomula to find futue value. 3. Solve the compound inteest fomula fo diffeent unknowns, such as the pesent value,More information
Section 3.3: Geometric Sequences and Series
ectio 3.3: Geometic equeces d eies Geometic equeces Let s stt out with defiitio: geometic sequece: sequece i which the ext tem is foud by multiplyig the pevious tem by costt (the commo tio ) Hee e someMore information
STATE OF MONTANA Developomental Disabilities Program Comprehensive Evaluation Hi-Line Home Programs, Inc Adult Services
Dtes of Review: FY '09 Evluttor(s): S. Crpenter DESK REVIEW: Accredittion: Acredittion is no longer required by the stte contrct. Significnt Events from the Agency: Developomentl Disbilities Progrm ComprehensiveMore information
The impact of migration on the provision. of UK public services (SRG.10.039.4) Final Report. December 2011
The impact of migation on the povision of UK public sevices (SRG.10.039.4) Final Repot Decembe 2011 The obustness The obustness of the analysis of the is analysis the esponsibility is the esponsibilityMore information
FDIC Study of Bank Overdraft Programs
FDIC Study of Bnk Overdrft Progrms Federl Deposit Insurnce Corportion November 2008 Executive Summry In 2006, the Federl Deposit Insurnce Corportion (FDIC) initited two-prt study to gther empiricl dt onMore information
Instructions to help you complete your enrollment form for the HPHC Medicare Supplement Plan
THIS ENROLLMENT FORM IS IN SECTIONS. PLEASE REMOVE THIS TAB TO SEPARATE THE SECTIONS BEFORE YOU BEGIN. Maine Instuctions to help you complete you enollment fom fo the HPHC Medicae Supplement Plan ThankMore information
Complaint form. In order to complete this complaint form you will need the following information to hand:
Complint form Welcome to our Airline complints form. To proceed with your complint plese follow the 6 steps below nd provide ll of the informtion reuested. Plese note: this is the complint form pplicbleMore information
PROPERTY AND CASUALTY INSURANCE. Effects of the Nonadmitted and Reinsurance Reform Act of 2010
United Sttes Government Accountbility Office Report to Congressionl Committees Jnury 2014 PROPERTY AND CASUALTY INSURANCE Effects of the Nondmitted nd Reinsurnce Reform Act of 2010 GAO-14-136 Jnury 2014More information
DOCTORAL DEGREE PROGRAM Application Fo Admission National Mose Cente fo Adult Leaning Cental Illinois: Benedictine Univesity at Spingfield 1500 Noth 5th Steet, Spingfield, IL 62702 Phone: (217) 718-5002More information
Pay over time with low monthly payments. Types of Promotional Options that may be available: *, ** See Page 10 for details
With CreCredit... Strt cre immeditely Py over time with low monthly pyments For yourself nd your fmily Types of Promotionl Options tht my be vilble: Not ll enrolled helthcre prctices offer ll specil finncingMore information
S a l e s Ta x, U s e Ta x, I n c o m e Ta x W i t h h o l d i n g a n d M i c h i g a n B u s i n e s s Ta x E s t i m a t e s
78 (Rev. 8-08) S l e s T x, U s e T x, I n c o m e T x W i t h h o l d i n g n d M i c h i g n B u s i n e s s T x E s t i m t e s Forms nd Instructions Cll (517) 636-4730 or visit Tresury s Web site tMore information
Effects of Sleep Hygiene Education on Subjective Sleep Quality and Academic Performance l
e A þ t ý m Effects of Sleep Hygiene Eduction on Subjective Sleep Qulity nd Acdemic Pefomnce l n i j i O O i g in Uyku Hijyen Eğitiminin Subjektif Uyku Klitesi ve Akdemik Pefomnsı Üzeine Etkilei h c sMore information
Characteristics of an effective selfdirected work team in the gold-mining industry
Chcteistics of n effective selfdiected wok tem in the gold-mining industy by A. Nel* nd J. Pien* J o u n l Synopsis The gold mining industy in South Afic stnds to benefit much fom the implementtion ofMore information
(Ch. 22.5) 2. What is the magnitude (in pc) of a point charge whose electric field 50 cm away has a magnitude of 2V/m?
Em I Solutions PHY049 Summe 0 (Ch..5). Two smll, positively chged sphees hve combined chge of 50 μc. If ech sphee is epelled fom the othe by n electosttic foce of N when the sphees e.0 m pt, wht is theMore information
UNITED STATES DEPARTMENT OF AGRICULTURE Washington, D.C. 20250. ACTION BY: All Divisions and Offices. FGIS Directive 2510.
UNITED STATES DEPARTMENT OF AGRICULTURE Wshington, D.C. 20250 ACTION BY: All Divisions nd Offices FGIS Directive 2510.1 12-11-73 FEDERAL TORT CLAIMS I PURPOSE This Instruction: A Sets forth the bsic provisionsMore information
Firstmark Credit Union Commercial Loan Department
Fistmak Cedit Union Commecial Loan Depatment Thank you fo consideing Fistmak Cedit Union as a tusted souce to meet the needs of you business. Fistmak Cedit Union offes a wide aay of business loans andMore information
MAGNETIC FIELD AROUND CURRENT-CARRYING WIRES. point in space due to the current in a small segment ds. a for field around long wire
MAGNETC FELD AROUND CURRENT-CARRYNG WRES How will we tckle this? Pln: 1 st : Will look t contibution d to the totl mgnetic field t some point in spce due to the cuent in smll segment of wie iot-svt LwMore information
WORLD COUNCIL OF CREDIT UNIONS TOOLKIT SERIES Number 4 PEARLS MONITORING SYSTEM by: Dvid C. Richrdson World Council of Credit Unions October 2002 2001 The World Council of Credit Unions The World CouncilMore information
Department of Health & Human Services (DHHS) Centers for Medicare & Medicaid Services (CMS) Transmittal 1151 Date: November 16, 2012
nul ysem ub 100-20 One-Time Noificion Depmen of elh & umn evices (D) enes fo edice & edicid evices () Tnsmil 1151 De: Novembe 16, 2012 hnge eques 8124 UBJT: Use of Q6 odifie fo Locum Tenens by ovidingMore information
Small Business Cloud Services
Smll Business Cloud Services Summry. We re thick in the midst of historic se-chnge in computing. Like the emergence of personl computers, grphicl user interfces, nd mobile devices, the cloud is lredy profoundlyMore information
04-12-85 PAINTER, 3423 Summay of Duties : Does skilled wok in pepaing sufaces and in mixing, matching, and applying paint and elated mateials by bush, olle, o spay equipment to machiney, equipment, funitue,More information
DOCTORATE DEGREE PROGRAMS Application Fo Admission 2015-2016 5700 College Road, Lisle, Illinois 60532 Enollment Cente Phone: (630) 829-6300 Outside Illinois: (888) 829-6363 FAX: (630) 829-6301 Email: firstname.lastname@example.com information
Highe Education Cente fo Alcohol and Othe Dug Abuse and Violence Pevention Education Development Cente, Inc. 55 Chapel Steet Newton, MA 02458-1060 COMPLYING WITH THE DRUG-FREE SCHOOLS AND CAMPUSES REGULATIONSMore information
Recognition Scheme Forensic Science Content Within Educational Programmes
Recognition Scheme Forensic Science Content Within Eductionl Progrmmes one Introduction The Chrtered Society of Forensic Sciences (CSoFS) hs been ccrediting the forensic content of full degree coursesMore information
Small Business Networking
Why network is n essentil productivity tool for ny smll business Effective technology is essentil for smll businesses looking to increse the productivity of their people nd processes. Introducing technologyMore information
Lump-Sum Distributions at Job Change, p. 2
Jnury 2009 Vol. 30, No. 1 Lump-Sum Distributions t Job Chnge, p. 2 E X E C U T I V E S U M M A R Y Lump-Sum Distributions t Job Chnge GROWING NUMBER OF WORKERS FACED WITH ASSET DECISIONS AT JOB CHANGE:More information
E-Commerce Comparison
www.syroxemedi.co.uk E-Commerce Comprison We pride ourselves in creting innovtive inspired websites tht re designed to sell. Developed over mny yers, our solutions re robust nd relible in opertion, flexibleMore information
Personal Saving Rate (S Households /Y) SAVING AND INVESTMENT. Federal Surplus or Deficit (-) Total Private Saving Rate (S Private /Y) 12/18/2009
1 Pesonal Saving Rate (S Households /Y) 2 SAVING AND INVESTMENT 16.0 14.0 12.0 10.0 80 8.0 6.0 4.0 2.0 0.0-2.0-4.0 1959 1961 1967 1969 1975 1977 1983 1985 1991 1993 1999 2001 2007 2009 Pivate Saving RateMore information
Polynomial Functions. Polynomial functions in one variable can be written in expanded form as ( )
Polynomil Functions Polynomil functions in one vrible cn be written in expnded form s n n 1 n 2 2 f x = x + x + x + + x + x+ n n 1 n 2 2 1 0 Exmples of polynomils in expnded form re nd 3 8 7 4 = 5 4 +More information
VoIP for the Small Business
Reducing your telecommunictions costs VoIP (Voice over Internet Protocol) offers low cost lterntive to expensive trditionl phone services nd is rpidly becoming the communictions system of choice for smllMore information
GESTÃO FINANCEIRA II PROBLEM SET 1 - SOLUTIONS (FROM BERK AND DEMARZO S CORPORATE FINANCE ) LICENCIATURA UNDERGRADUATE COURSE 1 ST SEMESTER 2010-2011 Chapte 1 The Copoation 1-13. What is the diffeenceMore information
SECTION 5-4 Trigonometric Functions
Tigonometic Functions 78. Engineeing. In Polem 77, though wht ngle in dins will the ck wheel tun if the font wheel tuns though dins? The c length on cicle is esy to compute if the coesponding centl ngleMore information
Converting knowledge Into Practice
Conveting knowledge Into Pactice Boke Nightmae srs Tend Ride By Vladimi Ribakov Ceato of Pips Caie 20 of June 2010 2 0 1 0 C o p y i g h t s V l a d i m i R i b a k o v 1 Disclaime and Risk Wanings TadingMore information
The Supply of Loanable Funds: A Comment on the Misconception and Its Implications
JOURNL OF ECONOMICS ND FINNCE EDUCTION Volume 7 Numbe 2 Winte 2008 39 The Supply of Loanable Funds: Comment on the Misconception and Its Implications. Wahhab Khandke and mena Khandke* STRCT Recently Fields-HatMore information
LEGISLTIVE UDGET SYSTEM UDGET COMPRISON ORKSHEET Page 1 of 24 Program ID: JUD101 Structure #: 010101000000 COURTS OF PPEL JUDICIRY SEQ # EXPLNTION FIRST FY SECOND FY EXPLNTION 79.00 6,429,114 79.00 6,429,114More information

subset: commoncrawl


text:
SUFFOLK, Va. (WAVY) – In celebration of Black History Month, we're highlighting different stories from folks right here in Hampton Roads.
Our first feature is on Dennis Edwards. He's a Virginia native, born and raised in Suffolk. His career in television allowed him to cover many major breaking news stories.
After 38 years, he's back home, putting pen to paper as an Editorial Page Columnist for the Suffolk News Herald and is this week's "I Am Hampton Roads."
We want to give a special thank you to the Shooting Star Gallery in Suffolk for letting us use their location for the interview. You can always find Dennis' articles online: http://www.suffolknewsherald.com.


text:
Why does Tom Simson act in the capacity of a devoted slave to Mr. Oakhurst in "The Outcasts of Poker Flat"?
- print Print
- list Cite
Tom Simson is a "guileless youth," a young man whose name can be interpreted as the son of a simple man. He does not realize the severity of the predicament in which the outcasts are placed, and he gladly joins the others, thinking that there is safety in numbers. More importantly, Tom has met up with John Oakhurst before. Oakhurst had won all of Tom's money--$40--in a card game, but Oakhurst, ever the happy-go-lucky and kind gentleman, returned Tom's money to him.
After the game was finished, Mr. Oakhurst drew the youthful speculator behind the door and thus addressed him: "Tommy, you're a good little man, but you can't gamble worth a cent. Don't try it over again." He then handed him his money back, pushed him gently from the room, and so made a devoted slave of Tom Simson.
Tom has not forgotten Oakhurst's kindness, and he is more than willing to trust the gambler with his life and that of his young love, Piney Woods.


text:
I've used the Dynamics Developer Toolkit since it was first released by MCS for CRM4! I love the functionality it brings however the latest version is still in beta, it isn't supported on VS2017 and there isn't a date when it's likely to be either (yes, you can hack it to make it work but that's not the point J).
Rather than using an add-in Visual Studio project type, I've been attracted by the VS Code style simple project approach and so I decided to create a 'no-frills' alternative that uses a simple json config file (and that can be used in VS2017).
Let's assume you have a project in the following structure:
| |-html
| | |-HtmlPage.htm
| |-js
| | |-Somefile.js
| |-MyPlugin.cs
| |-MyWorkflowActivity.cs
On both the Plugin and Workflows project, Run the following from the Nuget Console:
Import-Package spkl
This will add the spkl to the packages folder and the metadata CrmPluginConfigurationAttribute.cs that is used to mark up your classes so that spkl can deploy them. Some simple batch files are also included that you can use to get started.
If you already have plugins deployed, you can run the following command line in the context of the Plugins folder:
spkl instrument
This will prompt you for a Dynamics Connection, and then search for any deployed plugins and their matching .cs file. If the MyPlugin.cs plugin is already deployed it might end up with the following Attribute metadata:
"name,address1_line1", "Create Step",1,IsolationModeEnum.Sandbox,
Description ="Description",
UnSecureConfiguration = "Some config")]
A spkl.json file will be created in the project directly similar to:
"plugins": [
"solution": "Test",
"assemblypath": "bin\\Debug"
If you now build your plugins, you can then run the following to deploy
spkl plugins
You can run instrument for the workflow project using the same technique which will result in code similar to the following being added to your workflow activity classes:
"WorkflowActivity", "FriendlyName","Description",
"Group Name",IsolationModeEnum.Sandbox)]
…and then run the following to deploy:
spkl workflow
To get any currently deployed webresources matched to your project files you can run the following from the Webresource project folder:
spkl get-webresources /s:new
Where new is the solution prefix you've used
This will create a spkl.json similar to the following:
"webresources": [
"root": "",
"files": [
"uniquename": "new_/js/somefile.js",
"file": "js\\somefile.js",
"description": ""
"uniquename": "new_/html/HtmlPage.htm",
"file": "html\\HtmlPage.htm",
"description": ""
You can then deploy using:
spkl webresources
For Debug/Release builds you can define multiple profiles that can be triggered using the /p:<profilename> parameter.
"plugins": [
"profile": "default,debug",
"assemblypath": "bin\\Debug"
"profile": "release",
"solution": "Test",
"assemblypath": " bin\\Release"
The default profile will be used if no /p: parameter is supplied. You can specify a profile using:
spkl plugins /p:release
If you have multiple plugins in a single deployment folder and you just want to deploy one, you can explicitly provide the path rather than using the folder search. E.g.
"plugins": [
"assemblypath": "bin\\Debug\MyPlugin.dll"
If you'd like to automatically add the items deployed to a solution after deployment you can use:
"webresources": [
"root": "",
"solution": "Test",
Perhaps you want to have a single spkl.json rather than multiple ones per project. You can simply add them all together:
"webresources": […],
"plugins": […]
Since the spkl.json configuration files are searched from the current folder, you can deploy multiple plugins/webresources using a single spkl call from a root folder.
I'll be updating the github documentation page as things move forwards.
In previous articles in this series we've talked about the differences between Server Side Sync and the old List Component. Since I published the first articles, a new MSDN article on the topic has been posted which I thought would be good to signpost folks to => Important considerations for server-based SharePoint integration.
One of the topics that has come up recently for people using Server Side Sync to SharePoint is the 5000 item limit of Document Libraries which has led to a bit of panic amongst some so I thought I'd dispel the rumours!
1) You can see how many items you have in a Document Library by opening the site in SharePoint and selecting 'Site Content' from the left hand navigation menu. The number of items will show below the Document Library name – this includes documents and folders.
2) If you have more than 5000 items you can still use Server Side Integration with SharePoint provided that you only use the default sort order of the document view in CRM.The default sort is by Location Ascending. You can change this to sort Descending but if you change the sort to any other column you will receive the error "Throttling limit is exceeded by the operation"
3) If you have a record with only 2 documents in the associated document locations folder you will still not be able to sort by any other column other than Location if the root Document Library has more than 5000 items overall.
3) If the user clicks on 'Open SharePoint' then they will be able to do all the sorting they need since the limitation is not experienced by the native SharePoint interface – only the CRM document lists.
I find that this sort limitation is not an issue because I encourage users to use SharePoint freely due to its rich interface. Don't try and hide SharePoint from them because it's important to understand the way in which documents are stored and the additional features that SharePoint has to offer. The documents view in CRM is simply to be used as a quick reference for documents associated with the CRM Record.
Hope this helps!
Speed up your HTML web resources by caching metadata such as localised field labels and options sets.
If you've developed an HTML web resource for Dynamics CRM that includes field labels, option sets or any other element that is stored in the Dynamics CRM metadata then you'll know about the delay each time the your UI is rendered whilst information is downloaded from the server. You could of course hard code this information in your JavaScript but you'd suffer higher maintenance costs especially when supporting multiple languages.
The SparkleXRM Metadata Server allows dynamic expressions to be included in JavaScript Web Resources that are evaluated on the server and then cached on the client side.
var fieldLabel = <@contact.fullname.DisplayName@>;
This will output and cache the following on the client (for an LCID of 1033):
var fieldLabel = "Full Name";
Learn more about the SparkleXRM Metadata Server!
The Dynamics CRM Async Server is a great mechanism to host integrations to external systems without affecting the responsiveness of the user interface. Once such example is calling SharePoint as I describe in my series – SharePoint Integration Reloaded.
A draw back of this approach (compared to using an integration technology such as BizTalk) is that any exceptions thrown during the integration will simply fail the workflow job with no retries. You might already know that the Async Server does in fact have a retry mechanism built in as described by this excellent post from the archives - http://blogs.msdn.com/b/crm/archive/2009/03/25/when-do-asynchronous-jobs-fail-suspend-or-retry.aspx. As you'll see from this article there are some built in exceptions where CRM will automatically retry a number of times as defined by the 'AsyncMaximumRetries' deployment property. The interval between these retries is defined by the 'AsyncRetryBackoffRate' property.
So how can we make use of this retry mechanism with our custom code?
There is an undocumented and unsupported way of using this retry mechanism in your custom workflow activities. I first used this technique back in the CRM 4.0 days and I'm pleased to report that it still works with CRM 2015!
Although unsupported, the worst that could happen is that the workflow would stop retrying in future version of Dynamics CRM and revert to simply reporting the exception. However it still wouldn't be a good idea to rely on this functionality for mission critical operations.
So…plz show me the codez…
catch (Exception ex)
// TODO: Rollback any non-transactional operations
OrganizationServiceFault fault = new OrganizationServiceFault();
fault.ErrorCode = -2147204346; // This will cause the Async Server to retry
fault.Message = ex.ToString();
var networkException = new FaultException(fault);
throw networkException;
When an exception is thrown by your custom workflow activity you'll see the workflow enter into a 'Waiting' state and the 'Postpone until' attribute will be set to the time when the retry will take place. Once the maximum number of retries has been performed, it will enter the 'Failed' status.
You can use this technique to ensure that any temporary integration failures such as service connectivity issues will be dealt with by a graceful retry loop. It only remains to ensure that you before throwing the exception you rollback any operations performed already by your code (such as creating records) so that your retries will not create duplicate records.
When publishing your Ribbon Workbench solution you may receive the following error:
"SecLib::RetrievePrivilegeForUser failed - no roles are assigned to user."
"SecLib::RetrievePrivilegeForUser failed - no roles are assigned to user."
The first step in diagnosing these issues is to try and export the same solution using the CRM solutions area and then immediately re-import to see what error is shown. This is exactly what the Ribbon Workbench does behind the scenes.
When doing this you might see:
Upon Downloading the Log File you'll see that the error occurs on a 'Process' and the same error message is shown as reported by the Ribbon Workbench. The User ID is also given which can be used in a URL similar to the following to find the user record causing the issue.
https://<orgname>.crm.dynamics.com/userdefined/edit.aspx?etc=8&id=%7b<User GUID>%7d
https://<orgname>.crm.dynamics.com/userdefined/edit.aspx?etc=8&id=%7b<User GUID>%7d
You will most likely discover that this user has been disabled or has no roles assigned – this could be that they have left the company or changed job role. You will need to find any Workflows or Dialogs that are assigned to them and re-assign to yourself before you can import the solution.
In most cases, you should not include Dialogs or Workflows in the solution that is loaded by the Ribbon Workbench since this only slows the download/upload publish process down. There is one exception to this – and that is Business Rules. Business Rules are associated with their particular entity and cannot be excluded from the solution. Oddly like Workflows and Dialogs they also are owned by a user but it is not shown in the user interface – nor is there an option to re-assign. There is a handy option on a user record that allows you to 'Reassign Records'
You would think that this would reassign any Business Rules but unfortunately you'll get the following error:
"Published workflow definition must have non null activation id."
"Published workflow definition must have non null activation id."
The only way to reassign these Business Rules is to perform an advanced find for Processes of Type 'Definition' and Category 'Business Rule'
The results can then be reassigned to yourself using the 'Assign' button on the results grid.
I recently answered a question on this error on the Community forms and coincidently I've just come up against exactly the same issue!
When importing a solution you receive the error 'There was an error calculating dependencies for this component' and on downloading the log you see the full message similar to:
The dependent component Attribute (Id=transactioncurrencyid) does not exist. Failure trying to associate it with Workflow (Id=<GUID>) as a dependency. Missing dependency lookup type = AttributeNameLookup.
The dependent component Attribute (Id=transactioncurrencyid) does not exist. Failure trying to associate it with Workflow (Id=<GUID>) as a dependency. Missing dependency lookup type = AttributeNameLookup.
Although this message can appear for other attributes, this post is specifically to do with the transactioncurrencyid attribute being referenced.
When you add a money field to an entity CRM automatically adds a N:1 relationship to the currency entity to hold the currency that the value is stored against. The foreign key attribute is always named transactioncurrencyid.
In this increasingly 'agile' software development world attributes are added and remove fairly regularly during the development phase. If a money field is added to an entity and then removed, the transactioncurrencyid attribute is not removed. Because the relationship automatically created by the system it is not created when deploying to another environment via a solution import because there are no money fields. This leads to your development environment having the additional relationship. This wouldn't cause a problem apart from that when you create a workflow with a 'create' or 'update' step, the currency field is usually pre-populated with the default currency. Consequently when you try to import this workflow into another organization that does not have the currency relationship you will see this error.
The solution is to either delete the transactioncurrencyid field from your development environmentm and from the workflow create/update steps or simply add a dummy currency field to your target environment in order to create the relationship to currency.
I still find the streamlined user experience offered by the Command Bar a welcome change from the CRM2011 Ribbon. The sub-grid command bar is the only possible exception with the loss of the ability to add custom sub-grid buttons. There are only at most two buttons on a sub grid – 'Add' and 'Open Associated Sub-Grid'The user must click on the 'Open associated sub-grid' button to show the full associated view and the full command bar with custom buttons. I say 'possible exception' because in fact there are still the same number of clicks involved (users had to click on the sub grid to show the contextual ribbon before) but it does feel as though we should have the ability to add buttons to the sub-grid command bar. I can think of some good reasons why this design decision may have been made (performance for one!) – but this post details what you CAN do to the sub-grid command bar.
Because the 'Open associated sub-grid' button is a bit of a mouthful, I'll refer to it from now on as the 'cream cracker' because it kind of looks like one and is equally a bit of a mouth full! (Thanks goes to my friends at the British Red Cross who first named it this way!)
We have established that you cannot add buttons to the form sub grid, but both the 'Add New' and 'Cream cracker' buttons are customisable in terms of their command and visibility (but you cannot change the image or the tool tip text).
To hide the sub grid buttons you have the following options:
The first hurdle is to determine which button needs to be customised. The sub grid 'Add New' button calls a different command depending on the nature of the relationship.
If you have a foreign-key attribute on your child entity that is marked as Field Requirement = 'Optional' then the Add New button will be the AddExistingStandard since it allows you to search for an existing record first. If the Field Requirement = 'Business required' then the button will be AddNewStandard
Once you've identified the right button, you can then open the ribbon workbench and click Customize Command and add the Value Rule as described by my user voice article.
Although we cannot add new buttons (did I mention that?!) we can change the command actions that either of those two buttons call. Since we can't customise the button, the only option here is to customise the command and change its behaviour in a very similar way to adding custom enable rules.
Once such use of this technique is to replace the standard add new button with a custom dialog.
You will find that when the form is loaded and the sub grid is refreshed for the first time the EnableRules are evaluated. If however the conditions for the EnableRules change (e.g. a value changes on the parent form) the sub grid command bar will not automatically refresh to reflect the new state. Upon adding or deleting rows in the sub grid the command bar is refreshed – but this isn't much use in this case.
The main form command bar can be refreshed using Xrm.Page.ui.refreshRibbon() however this will not refresh sub grid command bars. Instead, we can add an onchange event to the fields that are used in our ValueRule and call:
This will refresh the sub grids and re-evaluate any of the EnableRules however it will also save any other dirty attributes and so should be used with caution if you do not have auto-save enabled.
Perhaps in the future there will be more possibilities but for now that about sums up the possibilities for customising the sub grid command bar.
In Part 1 and Part 2 of this series we have discussed how the new server-to-server integration with SharePoint works under the covers. In this post I'll show you how to integrate with SharePoint directly from a sandboxed workflow activty/plugin rather than relying on the out of the box integration.
Using the standard integration, a new folder will be created for each record underneath the default site. In some solutions you'll find that you want to modify this behaviour so that folders are created in a custom location. You may for example want to have an opportunity folder created under a site that is specific to a particular client rather than all under the same site.
The challenge with integrating with SharePoint using a CRM Online Workflow Activity/Plugin is that you can't reference the SharePoint Assemblies which authenticating and calling the SharePoint web service somewhat harder. Thanks goes to fellow Dynamics CRM MVP Rhett for his blog that provided a starting point for this sample - https://bingsoft.wordpress.com/2013/06/19/crm-online-to-sharepoint-online-integration-using-rest-and-adfs/. The sample code in this post shows how to create a folder in SharePoint and then associate it with a Document Location. The authentication with SharePoint works via ADFS and since the out of the box integration uses a trust between CRM and SharePoint that is not accessible from a sandbox (even if you try and ILMerge it!) we have to provide a username and password that will act as our privileged user that can create folders in SharePoint. I have left a function where you can add your own credentials or implement a method to retrieve from a secure entity in CRM that only administrators have access to. Look in the code for the 'GetSecureConfigValue' function.
The sample contains a custom workflow activity that works in a CRM online 2013/2015 sandbox accepting the following parameters:
Calling the workflow activity might look like:
The workflow activity is deployed using the Developer Toolkit for Dynamics CRM and performs the following:
You could choose to run the workflow in Real Time or asynchronously on create of a record – the down side of real time is that it will increase the time that the record takes to save.
Check out the code in MSDN Samples- you'll need to do a Nuget package restore to pick up the referenced assemblies.
View/Download Code
That's all for now – have a Happy New Year!
Part 1 of in this series described how SharePoint Server to Server SharePoint integration (new to CRM2013 SP1) works from the client interface perspective. In this post I'd like to share a bit more how this all works from the server side.
When this feature was introduced my first question was about authentication. Having created a fair number of solutions that integrated SharePoint with Dynamics CRM on the server side I knew that this is a tricky area. Since this feature is only available for CRM Online to SharePoint Online where they are in the same tenant it makes authentication slightly simpler because there is already an existing trust in place between the two servers which allows Dynamics CRM to authenticate with SharePoint and act as the calling user. The HTTP request that comes from the client is inspected by the integration component and the UPN is used to authenticate with SharePoint as the same user rather than the service account. This is acting on behalf of the user is critical because when documents are created, checked in/out or queried, it must be performed under the account of the user and not the system account. Perhaps even more important, when CRM queries for documents it will only return those that the user has access to as configured in SharePoint.
If this feature is made available for On Prem customers I would expect that a configuration would have to be made available to provide the user's SharePoint username and password to use when performing server side operations.
The new SharePoint sub grid that is rendered by CRM actually uses exactly the same query mechanism as any other entity – but rather than the query being sent to the CRM Database, it is handled by the SharePoint query handler. If you fire up Advanced Find, you'll see a new Entity named 'Documents' but if you query against this entity you will get the error:
The error is given by the SharePoint FetchXml conversion to CAML only works if a specific regarding object is provided – this means that you can only return records for a specific folder, rather than all documents in all document locations. When the refresh button is clicked on the client sub-grid there is FetchXml similar to the following executed:
<fetch distinct="false" no-lock="true" mapping="logical" page="1" count="50" returntotalrecordcount="true" >
<entity name="sharepointdocument" >
<attribute name="documentid" />
<attribute name="fullname" />
<attribute name="relativelocation" />
<attribute name="sharepointcreatedon" />
<attribute name="ischeckedout" />
<attribute name="filetype" />
<attribute name="fullname" />
<attribute name="modified" />
<attribute name="sharepointmodifiedby" />
<attribute name="relativelocation" />
<attribute name="documentid" />
<attribute name="modified" />
<attribute name="fullname" />
<attribute name="title" />
<attribute name="author" />
<attribute name="sharepointcreatedon" />
<attribute name="sharepointmodifiedby" />
<attribute name="sharepointdocumentid" />
<attribute name="filetype" />
<attribute name="readurl" />
<attribute name="editurl" />
<attribute name="ischeckedout" />
<attribute name="absoluteurl" />
<filter type="and" >
<condition attribute="regardingobjecttypecode" operator="eq" value="1" />
<condition attribute="regardingobjectid" operator="eq" value="{1EF22CCD-9F19-E411-811D-6C3BE5A87DF0}" />
<order attribute="relativelocation" descending="false" />
The interesting part here is that we can add filters not only by regarding object but we could also add our own filters for name or document type. Initially I was confused because running this Fetch query in the Xrm Toolbox FetchXml tester gave no results but as it turns out this uses the ExecuteFetchRequest rather than RetrieveMultiple and this new SharePoint integration is only implemented on the latter.
This new server to server functionality is exposed by a set of internal messages that are not documented in the SDK but by using Fiddler (the tool that give you super powers!), you can see these messages being called from the client when operation such as Check In/Check Out are called. Here is a list of these internal messages:
Message Name
Returns a list of document names from SharePoint for a specific document location. This query is converted into SharePoint CAML on the server and supports basic filter criteria and sorting.
Creates a new document location and matching SharePoint folder and is called when the documents sub grid is first shown with no document locations configured.
FileName – Name of the file to create including extension (e.g. NewDocument.docx)
RegardingObjectId – Guid of the record that the document location belongs to
RegardingObjectTypeCode – Object type code of the record the document location belongs to
LocationId – The ID of the document location to add the new document to (in case there are multiple)
This performs the check in/out operation on a specific document in SharePoint.
Entity – The document to check in/out with the 'documentid' property populated with the List Id in SharePoint.
Creates a new documents location in CRM and the corresponding SharePoint folder.
FolderName – the name to give to the SharePoint folder
Now before you get excited you can't use these requests on the server because you will get a 'The request <Request Name> cannot be invoked from the Sandbox.' (Yes, I did try!) This is expected since the sandbox does not have access to the HTTP context that contains the information about the calling user and so the authentication with SharePoint cannot take place.
I proved this using a Custom Workflow Activity that tried to call 'CreateFolder' and you see the following error.
These requests can however be called easily from JavaScript which opens up some interesting possibilities (if a little unsupported because these messages are not actually documented the SDK at the moment):
I hope you've found this interesting - Next time I'll show you how to get around the sandbox limitation to perform server side operation on SharePoint from a CRM Plugin or Workflow Activity.
After having an interesting debate on the CRM Community forums about the performance of Early verses Late Bound entities my friend Guido Preite pointed me at a good blog post on this subject by James Wood named 'CRM 2011 Early Binding vs Late Binding Performance'. I have always been an advocate of Early Bound types but it is true that the SDK still states in the 'Best Practices for Developing with Microsoft Dynamics CRM'
"…use of the Entity class results in slightly better performance than the early-bound entity types"
"…use of the Entity class results in slightly better performance than the early-bound entity types"
However it also states that that the disadvantages of using the late-bound Entity types is:
"…you cannot verify entity and attribute names at compile time"
"…you cannot verify entity and attribute names at compile time"
I've seen many bugs introduced into code from the use of late bound types because typos can easily be introduced into the strings that are used to determine the entity and attribute logical names. Due to the productivity gains that come with Early Bound types I always recommend their use if the schema of your entities is known at compile time. There are times when this is not true or you are creating code that must run in a configurable way on many different entities or attributes in which case the late bound entity type is the only choice.
So what about performance?
So addressing each of these points in turn:
Although before CRM2011 there were serialization costs in using early bound types because they were serialised as part of the web service call, with CRM2011/2013 the early bound types just inherit from the Entity class and the early bound attribute properties simple set/get values from the underlying Attribute collection. The serialization when making SDK calls is effectively the same for both early and late. The main difference is due to the extra work that the OrganizationService Proxy has to do when converting the Early Bound type to the Entity type and then back against when it's received from the server. This is done using Reflection to first search for the Early bound classes and then by searching the classes for the one that matches the logical name received. This obviously will have a cost but it seems to be work that is done once per Service Channel and then cached to avoid any further cost.
James' tests are interesting but perhaps a bit misleading because the initial cost of this additional work is included in his overall speed calculations. This is probably why the overall percentage cost of early binding goes down as the number of records increases.
To remove this initial cost from the equation I adapted his code to introduce a warmup time. In tests I couldn't categorically show that either Late Bound or Early Bound had any performance difference once the OrganizationService was 'warmed up' with all reflection done and cached. In fact sometimes the test showed that early bound was quicker which leads me to believe that the main influencing factor is somewhere else like Database or Server performance. To make the results easier to interpret I have simply shown the average operation time after the warmup period. I also separated out the tests so that the Early Bound types were not compiled and picked in the Late Bound tests.
Each test was a warm up of creating 400 records and a run of creating 500 records.
Whilst it is true that using Early Bound classes incurs some cost of additional 'plumbing' – assuming that you are caching the WCF Service Channels (which the Microsoft.Xrm.Client.Services.OrganizationService does for you) because the difference in speed is so small (< there really is no reason not to use the Early Bound classes unless you have performance related issues and want to eliminate this as the cause.
If you are interesting, here is the code I used (based on James' code)
static void Main(string[] args)
int warmupCount = 400;
int runCount = 500;
CrmConnection connection = new CrmConnection("Xrm");
var service = new OrganizationService(connection);
CreateAccounts("Early Bound Test", warmupCount, runCount, () =>
Account a = new Account();
a.Name = "Test Early Vs Late";
CreateAccounts("Late Bound Test", warmupCount, runCount, () =>
Entity e = new Entity("account");
e["name"] = "Test Early Vs Late";
static void CreateAccounts(String name, int warmup, int runs, Action action)
Console.WriteLine("\n" + name);
// Warm Up
for (int i = 1; i <= warmup; i++)
if (i % 10 == 0)
Console.Write("\r{0:P0} Warmup ", (((decimal)i / warmup) ));
// Run Test
double runningTotal = 0;
Stopwatch stopwatch = new Stopwatch();
for (int i = 1; i <= runs; i++)
runningTotal += stopwatch.ElapsedMilliseconds;
double runningAverage = runningTotal / i;
if (i % 10 == 0)
Console.Write("\r{0:P0} {1:N1}ms ", (((decimal)i / runs)), runningAverage);
Develop 1 Limited are a Microsoft Partner with experience in the Financial Services, Insurance and Local Government sectors. We specialise in Microsoft Dynamics CRM solutions with bespoke integration to line of business applications.
Powered by
BlogEngine.NET 184.108.40.206 | (c) Develop 1 Limited