ࡱ> b  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry F;_w"Workbook d{_VBA_PROJECT_CUR" Β_w;_wCtls  ZO\p Jill Heath Ba= ThisWorkbook=K8X@"1Arial1Arial1Arial1Arial1 Arial1 Arial1 Arial1 Arial1Arial1Arial1QTahoma1QTahoma1$Arial1Arial1QTahoma1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>141<Calibri1?Calibri1h8Cambria1Calibri1 Calibri1Arial1Arial1Arial1 Arial1 Arial1Arial1Arial1Arial1 Segoe UI"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) mm/dd/yy mm/dd/yyyy mmddyyyy0.00_);[Red]\(0.00\) #\-####$[$-409]dddd\,\ mmmm\ dd\,\ yyyy[$-409]mmm\-yy;@ mm/dd/yy;@ m/d/yy;@                                                                      ff + ) , *      P  P         `            a>  1    H/  @3   H3    ! ! ( (  " 1  !0 1"0 1 0 ( 0  0  ( l""@ @  h@@  h@  h@  h a   UU@ @  ! h@ " h@ " h # h  #x" @  H " 1 ! a  !x@ !x 1! 1!0  ( l # h@    "x  *x"@@   *x""@ @   )x""@ @   `@@  `@ !p@  `  @ $ @     h  @ @  !x   h   h@   @ @ $ h@  !@ @ $!x $ h  p  `  ` @  ` !p  `  1 !@ @ % h@ & l@ @  & @ @  & @ @    |   @@  p@  p @  1  1 t ' x ( x  L ||{}A} yyyy;_(*ef;_(@_) }A} yyyy;_(*ef;_(@_) }A} yyyy;_(*ef;_(@_) }A} yyyy;_(*ef;_(@_) }A} yyyy;_(*ef;_(@_) }A} yyyy;_(*ef ;_(@_) }A} yyyy;_(*L;_(@_) }A} yyyy;_(*L;_(@_) }A} yyyy;_(*L;_(@_) }A} yyyy;_(*L;_(@_) }A} yyyy;_(*L;_(@_) }A} yyyy;_(*L ;_(@_) }A} yyyy;_(*23;_(@_) }A} yyyy;_(*23;_(@_) }A} yyyy;_(*23;_(@_) }A} yyyy;_(*23;_(@_) }A}  yyyy;_(*23;_(@_) }A}! yyyy;_(*23 ;_(@_) }A}" yyyy;_(*;_(@_) }A}# yyyy;_(*;_(@_) }A}$ yyyy;_(*;_(@_) }A}% yyyy;_(*;_(@_) }A}& yyyy;_(*;_(@_) }A}' yyyy;_(* ;_(@_) }A}( yyyy;_(*;_(@_) }}) }yyyy;_(*;_(@_)    }}* yyyy;_(*;_(@_) ??? ??? ??? ???}-}/ yyyy;_(*}A}1 ayyyy;_(*;_(@_) }A}2 yyyy;_(*;_(@_) }A}3 yyyy;_(*?;_(@_) }A}4 yyyy;_(*23;_(@_) }-}5 yyyy;_(*}}7 ??vyyyy;_(*̙;_(@_)    }A}8 }yyyy;_(*;_(@_) }A}9 eyyyy;_(*;_(@_) }x}:yyyy;_(*;_(  }}; ???yyyy;_(*;_(??? ???  ??? ???}-}= yyyy;_(*}U}> yyyy;_(*;_( }-}? yyyy;_(*}(}Syyyy;_(*}(}Tyyyy;_(*}(}Uyyyy;_(*}(}Vyyyy;_(*}(}Wyyyy;_(*}(}Xyyyy;_(*}<}Y yyyy;_(*;_(}<}Z yyyy;_(*;_(}<}[ yyyy;_(*;_(}<}\ yyyy;_(*;_(}(}byyyy;_(*}(}cyyyy;_(*}(}dyyyy;_(*}<}h yyyy;_(*;_(}(}kyyyy;_(*}(}lyyyy;_(*}(}myyyy;_(*}(}nyyyy;_(*}(}s yyyy;_(*}(}{ yyyy;_(*}(}} yyyy;_(*}(}~ yyyy;_(*}<} yyyy;_(*;_(}(} ?yyyy;_(*}(} ?yyyy;_(*}(} ?yyyy;_(*}(}yyyy;_(*}(}yyyy;_(*}(}yyyy;_(*}<} yyyy;_(*;_(}<} yyyy;_(*;_( 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text %0 : Followed Hyperlink 1Good;Good  a%2 Heading 1G Heading 1 I}%O3 Heading 2G Heading 2 I}%?4 Heading 3G Heading 3 I}%235 Heading 49 Heading 4 I}%6( Hyperlink 7InputuInput ̙ ??v% 8 Linked CellK Linked Cell }% 9NeutralANeutral  e%"Normal :Noteb Note   ;OutputwOutput  ???%????????? ???<$Percent =Title1Title I}% >TotalMTotal %OO? Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight16`U\ Journal IU _xlfn.SINGLEBus_Unit:# Control_Total: " Copy_row;00 Descr_Hdr: FileName:  Jrnl_Date: Jrnl_ID:Ledger: lookup:   ;/  ;! Reversal_Cd: # Reversal_Date: Source: 5fFf0A@@  (/O- "[bShW*9F@=[bShW*9 50 xVMKTQ~QGu,QP[q M3TfdҦ]LHBҪ ZDEBD ? Zf. sMMsþ'2?T{HH RZ\“w\+{wGi6\G7f&mFP(SA]X^[LiVH|zv[KId]bЮg'(q0sg &XELviL3נ|C\ r6"eBqj=Z5JLDZ#pyVq}ӚjugǾZwy(bkTNVNqVʷjӨxi&U~aJjU\ +I<\ V1>:⓺Dبx<B<&fj}SzucD3=DGp.9V'/@~+(avʼn|dʙHqr.Opt= d~(^XX_qxlDoE jԩx|kxZ|a~F|-Eto' ,7'yBg b($/c Ʒl} Y~4"Y;ی:aMx|Bȟjpzxq[WEB_vQL$F"/̤4'p(gvF@=/̤4'p(gv Ģ-7xVMkSA=oD"ւ-QBA\h"* "2XmR -qхKAى w wg)([N4P%>G)[s@ 흉=k4I|Z׋4Wp9y֐Q#0YK0(RQ6g^ʺyFtFW* u?@A_n|<)jYYԅ<+=gg2vMυKN>&݉$YЙIJԧY/g cG,a[,\$&(t+R˯ITP|ɕ; taSsa9x[?_|_| w|goVu7!W6.z3r1wAxWРNnWKԼu|tS^"MC ,˵tV5MEϳIh;n%"FP81Sy\O&1j<ɪ7*x>UNK}I]vAqGػj&sv(޳9Bwt!ld䤯5#Q3"D*Amq^F@=D*Amq^ 1xVKkQfR4M(E*h/,C@pg/D-n)VZ27.E} Dt'A/d']qg!~߽s1s={3aq~x9 D|} 3!g.i{U[Ysq \irƘe;Z8؟=&bm% )SlZ伧 ,9t/h=ڞa*$; 2 S)F̤&g:Vg˴s6Ͷg_2>;X3P1ŕ89?03΂T48K<#hLD1(Ǟ wdn9OFXj뿁Ζx +C^Fd?%ۉϰ-Nqݜ?uMF$MkPEӛי{~hޣGok\!#Ro+JDY{z]"t *QwE{X" qO+ ~~'!D5sՍv=NlSH>"ٺۊ|ױWƧ"ȉ<&J &M5BNe tY>?#!mfKx=[Ԃu}ˆ ~umoLz^W/}ةLo;9iwk/_tV[,ac߬56YvYp1ϡAz 9ۮ7ެe ."Zk1~EȰ RӔ/x$( :7vʗsSj{"bF^x^xz?>~,ɸ7Gg_zy5^|?}V I򋧿>OQ>19ٵ<Ÿ8ߊaG@tOE*\ʻ/ yToN:"1Q(v; y4<$jbRa|PŻǴI Y3wJG݈8b2(<& QHT^w/B(`Z!94[Mc˴j`jG7;Q]o YC5*CocU 9 IQ/ RV+`%*;æWѼ9/#~7qZ$*cߓrUngN>%OOi Dh[BvoLJƌB6>p&>w O]>.ɲ,5,<ؾt&9 ԔEЇIIqhJ#f6kAS&2D)p3ӕ5teO`jvzEOG)9cshger-# ~fu-ԙՍh&9܊- 6 AлY3hX"M$#Fz6#b.w*lyhĭɾ̮]nR3+=,)'Kak.zi X 8Ka6!_ 5[ M܆< kW Ds/Z/j@&8?&5- C⫲K3Zw1K|D!`~J0A?Uֶy&,Xg1K#[y$[BTV)bBRvVt=낕@[\׶Dž8d4~_@`rx \kp*O69mY&ԧ HE]HKN!Vj%2BƣJԊ=" u\ӵC&Y0>g4&oN)j rihr"VTU,koy#ŬjQJpRk3܎Ws;ɢ!JT~u "֠ۀW_ Nq֙4)ڬuZˋw֒TvќXHegvtm,{2Da*20V=CoOQ2'@C8D.IrG[Ȥiࠆ)d͛|?&f9>b|w##(ɇ"C *_p=ce΂aenv*Wm瓗{varAˇ$IDpKs6* ʢG0egAnlCYt֏$Ysă)2|FS` uz'Xr*󠍒F`Bi m/Ҷj9Xrmox86tFo˜ b`>ASDbƟPK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 0_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!ÄA theme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK] `t]\IF ZO X45];cAiG!o-9EMRY  dMbP?_*+%&zG?'RQ?(= ףp=?))\(?M HP LJ300-400 color M351-M451 P,!C odXXLetter$DINU" D W SMTJ IUPH!xNQ hҥ!\&DhP.!D]TXZ -;X+]n K ;v33ձx &sf:\zכ%p-ņ,+Amv*w@YoQwksFKUrOQBYWp|^x˒Eqh4?qFV.l?hw6)%iC_`\ Qx>)ߔ|((_Dxy> Q O ֈ(q[OQ[x-]s`I3b3Xے +2(#XǓ;G3vX;~?>?U?i]~DDDDDDDDm} z<"ZXX(\? ףp= ?&4 U} } }  H} } } .H} t } } A} . F} F}  } . } . } E } .  source4hh 00           "STTUTcTVVVVVVV D CCC Y( VVVVdVVVVVVVV B B B B Y$ VVVVdVVVVVVVV ) 0 Z b.[\VdVVVVVVVV *  , W~ X}@[VVVVVVVV +  - h/zfilename$B}\[filename$B}B|ls]filename$B}B|\[filename$B}B|A&#interunit_billing_journal_form1.xlsVVVVV  1 k& "oppppqpppppppr s tu v)u w uu  0 uuuux y uu u wuuzuuuu x% { uu~ |@ u w uuzuuuu / y uu  u } ~u"  E!           ]"# R %p ` g l m m m m n m' m  m  m  m  m  m# m^ia_`e@ @IIAj^ia_`e@ AIIAj^./P?%L  L Bia_`e@ @IIAA^ia_`e@ AIIAAia_`e@ @IIAA^ia_`e@ AIIAA^ia_`e@ @IIAA^ia_`e@ AIIAA^ia_`e@ @IIAA^iG_`e@ AIIAA^iG_`e@ @IIAA^iG_`e@ AIIAA^iG_`e@ @IIAA^iG_`a@ AIIAA^iG_`e@ @IIAA^ iG_`a@ AIIAADK lDjNhp&rhh\4$$S..~K.KKKKKKKKKK !"#$%&'()*+,-./0123456789:;<=>? ^! iG_`e@ @IIAA!^"!iG_`a@! AIIAA"^#"iG_`a@" AIIAA#^$#iG_`a@# AIIAA$^%$iG_`a@$ AIIAA%^&%iG_`a@% AIIIA&^'&iG_`a@& AIIIA'^('iG_`a@' AIIIA(^)(iG_`a@( AIIIA)^*)iG_`a@) AIIIA*^+*iG_`a@* AIIIA+^,+iG_`a@+ AIIIA,^-,iG_`a@, AIIIA-^.-iG_`a@- AIIIA.^/.iG_`a@. AIIIA/^0/iG_`a@/ AIIIA0^10iG_`a@0 AIIIA1^21iG_`a@1 AIIIA2^32iG_`a@2 AIIIA3^(43iG_`a@3 AIIIA4^(54iG_`a@4 AIIIA5^(65iG_`a@5 AIIIA6^(76iG_`a@6 AIIIA7^(87iG_`a@7 AIIIA8^(98iG_`a@8 AIIIA9^(:9iG_`a@9 AIIIA:^(;:iG_`a@: AIIIA;^(<;iG_`a@; AIIIA<^(=<iG_`a@< AIIIA=^(>=iG_`a@= AIIIA>^(?>iG_`a@> AIIIA?^(@?iG_`a@? AIIIAD lKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_@^(A@iG_`a@@ AIIIAA^(BAiG_`a@A AIIIAB^(CBiG_`a@B AIIIAC^(DCiG_`a@C AIIIAD^(EDiG_`a@D AIIIAE^(FEiG_`a@E AIIIAF^(GFiG_`a@F AIIIAG^(HGiG_`a@G AIIIAH^(IHiG_`a@H AIIIAI^(JIiG_`a@I AIIIAJ^(KJiG_`a@J AIIIAK^(LKiG_`a@K AIIIAL^(MLiG_`a@L AIIIAM^(NMiG_`a@M AIIIAN^(ONiG_`a@N AIIIAO^(POiG_`a@O AIIIAP^(QPiG_`a@P AIIIAQ^(RQ/Q@%L  L BQiG_`a@Q AIIIAR^(SQRiG_`a@R AIIIAS^(TQSiG_`a@S AIIIAT^(UQTiG_`a@T AIIIAU^(VQUiG_`a@U AIIIAV^(WQViG_`a@V AIIIAW^(XQWiG_`a@W AIIIAX^(YQXiG_`a@X AIIIAY^(ZQYiG_`a@Y AIIIAZ^([QZiG_`a@Z AIIIA[^(\Q[iG_`a@[ AIIIA\^(]Q\iG_`a@\ AIIIA]^(^Q]iG_`a@] AIIIA^^(_Q^iG_`a@^ AIIIA_^(`Q_iG_`a@_ AIIIAD lKKKKKKKKKKKKKKKKK~KKKKKKKKKKKKK`abcdefghijklmnopqrstuvwxyz{|}~`^(aQ`iG_`a@` AIIIAa^(bQaiG_`a@a AIIIAb^(cQbiG_`a@b AIIIAc^(dQciG_`a@c AIIIAd^(eQdiG_`a@d AIIIAe^(WQeiG_`a@e AIIIAf^(gQfiG_`a@f AIIIAg^(hQgiG_`a@g AIIIAh^(iQhiG_`a@h AIIIAi^(jQiiG_`a@i AIIIAj^(kQjiG_`a@j AIIIAk^(lQkiG_`a@k AIIIAl^(mQliG_`a@l AIIIAm^(nQmiG_`a@m AIIIAn^(oQniG_`a@n AIIIAo^(pQoiG_`a@o AIIIAp^(qQpiG_`a@p AIIIAq^(rQqiG_`a@q AIIIAr^(sQriG_`a@r AIIIAs^(tQsiG_`a@s AIIIAt^(uQtiG_`a@t AIIIAu^(vQuiG_`a@u AIIIAv^(wQviG_`a@v AIIIAw^(xQwiG_`a@w AIIIAx^(yQxiG_`a@x AIIIAy^(zQyiG_`a@y AIIIAz^({QziG_`a@z AIIIA{^(|Q{iG_`a@{ AIIIA|^(}Q|iG_`a@| AIIIA}^(~Q}iG_`a@} AIIIA~^(Q~iG_`a@~ AIIIA^(QiG_`a@ AIIIAD lKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK^(QiG_`a@ AIIIA^(QiG_`a@ AIIIA^(QiG_`a@ AIIIA^(QiG_`a@ AIIIA^(QiG_`a@ AIIIA^(QiG_`a@ AIIIA^(QiG_`a@ AIIIA^(QiG_`a@ AIIIA^(QiG_`a@ AIIIA^(QiG_`a@ AIIIA^(QiG_`a@ AIIIA^(QiG_`a@ AIIIA^(QiG_`a@ AIIIA^(QiG_`a@ AIIIA^(QiG_`a@ AIIIA^(QiG_`a@ AIIIA^(QiG_`a@ AIIIA^(/@%L  L BiG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIAD lKKKKKKKKKKKKKKKKK~KKKKKKKKKKKKK^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(0iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIAD lKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(/@%L  L BiG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIAD lKKKKKKKKKKKKKKKKK~KKKKKKKKKKKKK^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iG_`a@ AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIAD lKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK     ^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^( iGK@aA AIIIA ^(  iGK@aA  AIIIA ^(  iGK@aA  AIIIA ^(  iGK@aA  AIIIA ^(  iGK@aA  AIIIA ^( iGK@aA  AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(f/P@%L  L BiGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^( iGK@aA AIIIAD lKKKKKKKKKKKKKKKKK~KKKKKKKKKKKKK !"#$%&'()*+,-./0123456789:;<=>? ^(! iGK@aA  AIIIA!^("!iGK@aA! AIIIA"^(#"iGK@aA" AIIIA#^($#iGK@aA# AIIIA$^(%$iGK@aA$ AIIIA%^(&%iGK@aA% AIIIA&^('&iGK@aA& AIIIA'^(('iGK@aA' AIIIA(^()(iGK@aA( AIIIA)^(*)iGK@aA) AIIIA*^(+*iGK@aA* AIIIA+^(,+iGK@aA+ AIIIA,^(-,iGK@aA, AIIIA-^(.-iGK@aA- AIIIA.^(/.iGK@aA. AIIIA/^(0/iGK@aA/ AIIIA0^(10iGK@aA0 AIIIA1^(21iGK@aA1 AIIIA2^(32iGK@aA2 AIIIA3^(43iGK@aA3 AIIIA4^(54iGK@aA4 AIIIA5^(65iGK@aA5 AIIIA6^(76iGK@aA6 AIIIA7^(87iGK@aA7 AIIIA8^(98iGK@aA8 AIIIA9^(:9iGK@aA9 AIIIA:^(;:iGK@aA: AIIIA;^(<;iGK@aA; AIIIA<^(=<iGK@aA< AIIIA=^(>=iGK@aA= AIIIA>^(?>iGK@aA> AIIIA?^(@?iGK@aA? AIIIAD lKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_@^(A@iGK@aA@ AIIIAA^(BAiGK@aAA AIIIAB^(CBiGK@aAB AIIIAC^(DCiGK@aAC AIIIAD^(EDiGK@aAD AIIIAE^(FEiGK@aAE AIIIAF^(GFiGK@aAF AIIIAG^(HGiGK@aAG AIIIAH^(IHiGK@aAH AIIIAI^(JIiGK@aAI AIIIAJ^(KJiGK@aAJ AIIIAK^(LKiGK@aAK AIIIAL^(MLiGK@aAL AIIIAM^(NMiGK@aAM AIIIAN^(ONiGK@aAN AIIIAO^(POiGK@aAO AIIIAP^(QPiGK@aAP AIIIAQ^(RQ/Q@%L  L BQiGK@aAQ AIIIAR^(SQRiGK@aAR AIIIAS^(TQSiGK@aAS AIIIAT^(UQTiGK@aAT AIIIAU^(VQUiGK@aAU AIIIAV^(WQViGK@aAV AIIIAW^(XQWiGK@aAW AIIIAX^(YQXiGK@aAX AIIIAY^(ZQYiGK@aAY AIIIAZ^([QZiGK@aAZ AIIIA[^(\Q[iGK@aA[ AIIIA\^(]Q\iGK@aA\ AIIIA]^(^Q]iGK@aA] AIIIA^^(_Q^iGK@aA^ AIIIA_^(`Q_iGK@aA_ AIIIAD lKKKKKKKKKKKKKKKKK~KKKKKKKKKKKKK`abcdefghijklmnopqrstuvwxyz{|}~`^(aQ`iGK@aA` AIIIAa^(bQaiGK@aAa AIIIAb^(cQbiGK@aAb AIIIAc^(dQciGK@aAc AIIIAd^(eQdiGK@aAd AIIIAe^(fQeiGK@aAe AIIIAf^(QfiGK@aAf AIIIAg^(QgiGK@aAg AIIIAh^(gQhiGK@aAh AIIIAi^(hQiiGK@aAi AIIIAj^(iQjiGK@aAj AIIIAk^(jQkiGK@aAk AIIIAl^(kQliGK@aAl AIIIAm^(lQmiGK@aAm AIIIAn^(mQniGK@aAn AIIIAo^(nQoiGK@aAo AIIIAp^(oQpiGK@aAp AIIIAq^(pQqiGK@aAq AIIIAr^(qQriGK@aAr AIIIAs^(rQsiGK@aAs AIIIAt^(sQtiGK@aAt AIIIAu^(tQuiGK@aAu AIIIAv^(uQviGK@aAv AIIIAw^(vQwiGK@aAw AIIIAx^(wQxiGK@aAx AIIIAy^(xQyiGK@aAy AIIIAz^(yQziGK@aAz AIIIA{^(zQ{iGK@aA{ AIIIA|^({Q|iGK@aA| AIIIA}^(|Q}iGK@aA} AIIIA~^(}Q~iGK@aA~ AIIIA^(~QiGK@aA AIIIAD lKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK^(QiGK@aA AIIIA^(QiGK@aA AIIIA^(QiGK@aA AIIIA^(QiGK@aA AIIIA^(QiGK@aA AIIIA^(QiGK@aA AIIIA^(QiGK@aA AIIIA^(QiGK@aA AIIIA^(QiGK@aA AIIIA^(QiGK@aA AIIIA^(QiGK@aA AIIIA^(QiGK@aA AIIIA^(QiGK@aA AIIIA^(QiGK@aA AIIIA^(QiGK@aA AIIIA^(QiGK@aA AIIIA^(QiGK@aA AIIIA^(/@%L  L BiGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIAD lKKKKKKKKKKKKKKKKK~KKKKKKKKKKKKK^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIAD lKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(/@%L  L BiGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIAD lKKKKKKKKKKKKKKKKK~KKKKKKKKKKKKK^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA AIIIA^(iGK@aA  !"#$%&'()*+,-./0123456789;<=>?2iw~̅ XPP?  H]4@ p>iЩFR;1 <Cannot exceed 30 characters.< =~~  <@2~̅ XPP?   =]4@ :4O3 <Auto computed per detail lines. No manual input. A zero indicates a balanced JE. All Journal Entries must be balanced except for Budgets. <  ~~  <9~̅ XPP? ]4@ %σ@  D<EA sequential line number is assigned automatically. No manual entry.< D@@~~  <0~̅ XPP? f]4@ 'ػbFEn* <SMCMP SMFND SMURS< o  ~~  <5~̅ XPP? Y3H]4@ Zm#{Kɔ1D 2<3Account number must be between 100000 and 999999. < J2,`~~   <:~̅ XPP? $]4 @ vq$I/{ 1 .</Fund code must be 5 characters, numeric only. < .,`~~ ! <p>~̅ XPP? ]4!@ -?%F|qsI (<)Dept must be 4 characters, numeric only < ( ~~ " <>~̅ XPP? ]4"@ 촩LwV!n0 1<2Program Code may be 3 or 5 characters, numeric. < :1T~~ # <0~̅ XPP?  ]4#@ ] HSp H<IAUX Project is 5 characters. PDC Project is 6 characters. Numeric only.< ( H ~~  <@~̅ XPP?  ]4@ k?H}$;*EZ <Cannot exceed 10 characters.< =  T`:~̅ X? J E\]4@ I)CF@PiejeA    7yK accounting@mailhost1.csusm.eduyK dmailto:accounting@mailhost1.csusm.eduyX;H,]ą'czLEnter Date Prepared Invalid DateFormat mm/dd/yyyy%Date must be in the format mm/dd/yyyyK Enter Journal Date Invalid DateFormat mm/dd/yyyy%Date must be in the format mm/dd/yyyy @ q(Invalid Project / Grant3 Project / Grant must be 5 characters, alphanumericd/11ZxInvalid Scenario#Scenario can be up to 10 charactersra , 11 |Header DescriptionDescription too longUEnter a description for this Journal Entry. The length must be 30 characters or less.2The Header Description is limited to 30 characters; & io S Journal ID%Leave as is. Journal ID must be NEXT.iofoT,Invalid ExtensionExtensions must be 5 numberso  Enter Business UnitValid Business Unit#Select a Busines Unit from the List-You must select a Business Unit from the List 2-}Invalid Project / Grant4 Project / Grant must be 10 characters, alphanumericst ct 00.tInvalid Project / Grant3 Project / Grant must be 5 characters, alphanumericsc//[( Invalid Dept(Department must be 5 characters, numericac a1mInvalid Account(Account must be between 100000 and 99999 j@ ~.A1_( Invalid Fund,Fund code must be 5 characters, alphanumericj1\(Invalid Program Code!Program Code must be 5 charactersc1Ux Invalid Class!Class must be 5 characters, alphactc/1Invalid Stat CodeNStatistics Code must be 3 characters. FTE is currently the only allowed value.FTEt1 jxDescription too long/TheLine Description is limited to 30 characterslyon1 Enter SourceInvalid or Missing SourceSelect a Source from the ListYou must enter a valid Source % `( Invalid Dept-Department must be 4 characters, numeric onlystu `( Invalid Dept-Department must be 4 characters, numeric onlystu _( Invalid Fund,Fund code must be 5 characters, numeric onlysuZ( Invalid Fund'Fund code must be 5 characters, numericnl[( Invalid Dept(Department must be 4 characters, numericlInvalid Project / Grant^ Project must be 5 characters for SMFND & SMURS or may be 6 characters for SMCMP, numeric only-W( Invalid Class#Class must be 5 characters, numericrsSM.),ss Sheet1ggD VBA|ߒ_w_wThisWorkbook8 Sheet1 :^Module1EME(SLSS<N0{00020819-0000-0000-C000-000000000046}`*@, .i0  4,BX I* xi  `N %0" "  ( T0 0"xbX  n0  2B   (08@ Px]o0A@2oPMthis procedure looks for the text file and if found alerts the user. The userx)then decides whetherr or not to delete itC:\Temp\JRNLUPLOAD.txt'* The file ** has been found. Do you want to delete it? $8 $8 $8 $8'6 6SPress YES if you want to delete it. Press NO if you want to keep it and add to it.'6 < > ':JRNLUPLOAD File'@ *$B 6 : @$D', , F *A@H * has been deleted. $8 $8 $8 J L File DeletedA@DkXkPoH+this function determines if the file exists] *$~'N N'Bd'BkiqAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2Option /licit Dim st@rfilen2 As Sng, Respon1o P59 Sub _Bef oreClU(C ancelBoolean)  Journal_Ref End 't procedure ls & the tex$t I aif ualertsuser. TAen @Uides wherr or n ot tole<2Open(G,CC:\\\JRNLUPLOAD.txt7(msgeC," & T& " has be@(fo2. Do youP wan '?AChr(13)B0FWA@ss YES @L.  NOkeep it\addLit.8StyvbYesNo + vbdIn@kma"Tit "I F I@q@exishts(X)snVE@MsgBhox(9,", Bka@ l %Kill4OEcO9g9deAJd." _& 780),1vbExC*B,OKOn ly, "( D )!jI ketlfunc~d `rmin d DmblC2G|F5`|X#!X68Dir ""l3 !aI !u_YXTgcx(cmd20Rows, 38, 0, MSForms, CommandButton)cmd100Rows, 39, 1, MSForms, CommandButton,cmdCreateFile, 49, 2, MSForms, CommandButtonME(SLSSsN0{00020820-0000-0000-C000-000000000046}H RX V Z ^ `%%*%*%*`` *\R8004*#5d " " ( "08@ "HPXhA@TohXA@XoPA@\o8A@`o aAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2Controlcmd20Rows, 38, 0, MSFormCommandButtLon !10!9, 1!eFile, 4#2# P Su b 0 _Click() Add End ?N, cAe_F@jA3@1ntJEournal EjyH?0JHH "Hd VBAP@rojectD@& = r ;] J < 9stdole>stdole( h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\System32\e2.tlb#OLE Automation0AEOfficEODficE E2DF8t O] s\S]  8PLx] h] ] ] (@Xp] ] ] 0H7this routine inserts 20 rows via a pushbutton ****` (lookup B@ !'d d B@'j j bCopy_Row B@ B@1:1 %%!B@H  B@ !(A1:B1 %%B@H ( B@A1:B1 %%B@H B@A1:B1 %%B@H j 'j ( d B@ (o8this routine inserts 100 rows via a pushbutton **** (lookup B@ !'d d B@'j je bCopy_Row B@ B@1:1 %%!B@H  B@ !(A1:B1 %%B@H ( B@A1:B1 %%B@H B@A1:B1 %%B@H j 'j ( d B@ (o8] $~'N N 'Bd'Bki Get filenameA@A@delete_ScenarioA@]]](]@]X dd$' mm$' yyyy$'   '_ strfilename = Application.GetSaveAsFilename ' ("C:\Temp\JRNLUPLOAD", "PeopleSoft Journal Upload (*.txt), *.txt", ' , "Save PeopleSoft Journal Upload File")  &! \JRNL Upload  .txtText (MS-DOS)(*.txt), *.txtSave Journal Upload File@ %' |k 'l $B dH k0:**** old version of get file ****0 Message = "Enter a File Name (Exclude Path)" Title = "Name of Text File"4 InFile = InputBox(Message, Title, "JRNLIMP.TXT")! If Len(Trim(InFile)) > 0 Then# InFile = "C:\Temp\" & InFile PostRow = 17# Open InFile For Output As #1 End If9**7*set up header values ***E$!$$$'t E$!$$$'v E$!$mmddyyyy$'x E$!$$$'z J$!$$$'| J$!$mmddyyyy$'~J$!$$$'FileName$' Descr_Hdr$!$'USD'(Jrnl_Class = Range("????") '**; Store Header values in proper position **** :OH t v x% z9 |: ~N Q Y w D l$$b lC$!$'t lD$!$' lE$!$$  2XTJGxMEhdhfh6hhh@hjh:hlhn hphrhthvHx hzh|h~hhhhhhhhhhhhhhhhhhh X T+Bh I `N \pY@ ````     x   `(   2  `  @` >("h p   ,0H*X  ( ( ,0 `p >x"     @,P*  ( (0Xh p, B "  (@H Php x      X hp x @ 6 &H :p ( *  *( X @h > * * 0H *x * 0 * 8 &P  x . B     $$@$h$$$$0P(p( D  L J` L6 8`H  P"`0h 08@ BH"     H">8 x    $ 0,@ p P" ( H.X . "  2@ 6x 6 (4H` Bh"  8 P p ,  8 *"H P` x., x] 0 F] H`x' lF$!$$' lG$!$$' lH$!$$' lI$!$$' lJ$!$$' lK$!$$'L l$!'M l$!' lN$!$$' lO$!$$'>**storing Line values in proper postion*** % C X L t z . F K P         l 'lF** when uploading the text file the App engine function ***C** does not read the last line. Add an empty line to ***F** the end of text file makes the function read all lines***&appends an empty line to the text fileV The file  has been created. $8 $8 $8 $8'6 6It has been saved'6 L > ': Text File'@ 6 : @A@Do Ithis routine checks that the reversal date is later than the journal datep Jrnl_Date$ Reversal_Date$  The Reversal Date must be later $8 $8 $8than the Journal Date. J L Date ConflictA@Dg k o <this routine checks for a balanced JE for non-Budget ledgersLedger$'z zBUDGETS Control_Total$5 &Please check your totals. This Journal $8 $8 $8Entry is not Balanced. J L Unbalanced Journal EntryA@DgX kP qH k@ o8 Bthis routine deletes the reversal date when reversal code is not D  Reversal_CD$5D()check reversal dates only if user definedA@d(for all other values (lookup B@ !'d d B@ Reversal_Date$B@H B@(delete reversal date ( d B@ (kxqpohIthis routine removes any formulas in the amounts and stat amounts columnsx M17$%!'M17$B@H   %$B@H B@   B@L17:L $B@H B@   B@ (oSheet1$B@  D16$%!'+select the area that contains the line data/the header does not need to be selected because0it is included in the rows to be repeated at the"top of each page in the page setupB17:N17 B17:N17$%$B@H B@ o<this routine deletes any scenarios when ledger is not Budget( (lookup B@ !'d d B@Ledger$'zCopy_row$!'r zBUDGETSJ17:J r$B@H B@kx ( d B@ (o 2this routine inserts the first 8 characters of the#filename into the Journal Reference (lookup B@ !'d d B@ !!$$Filename+ d B@ (oAttribute VB_Name = "Module1" Option Explicit Pub$ Current_Passwd As S!ng, "msg@Message tTitl RowAdde_Integer, hy %PPost0P+GetInputBoolean, InFi gintI)Bus_UnioJournal_ID Date, LedU(Revers^C +S:c(Trans_Ref_Num last_LongHeader_Desct@cy_Cod`Jrnl_Cs AccounGFun6DepProgra* rojecJ0Line.(LnA(Statistics6Sce narioG , MReR[AmE;D.o@z_ 'this rout- inse@rts 20ws via a Ppush@t* Sub 20ps() Apa.ScreenUpdngFalse GotoG3:="loo8kupA = Sel`-}.Valu ctiveSheet.Unprot1(! av= 1#`Do WhmF< 2d!:CopyXdc "Cell.Offset(-1, 0).s("1:1").Entire . I4 Shift:=xlDowng Hi`n 1W1@ange("A1:BmI"Cut(= }!D!=td@S0, 1_@-AF+ECLoop#+?A$QDra@wingObs :=TrurCo`nt|_pord:= ZǏnn E@`uU}10}e}` $}}nce}}>~>/>{< 10>rLIA,>DI.ve>>>$3>>1Q> 8)- /2׳#& /y>G >O~>QO1 >K &>=ק>p 3g rg>>D}>=>d>>`E>Prtivp @{f nex@s(stjrn)aT Dim XSbX3DirZIBf<> "T|he(hsHAEFJ*KIf  P0 _FlatQ'  remove@_formu @ Check_BalapGPdEte_%WD x #mydaFy!mym\h!oyear]vanrPz #= F at(Now, "dd"$Ms mm2y= my~& DosS` ' 8ASaveAs; $lr@ ("C:\Temp\JRNLUPLOAD" PeopleSoft  Upload (*.txt)|, r-A /%@ 0ӫ gq (Ixial@}`Workb.Path & "bu"q B#,ter0rText (MS-DOS)P2 ;8 k<1Ex@9 U l@A=U7a I)C Open strfilename For Apd As #1 Else$4Output hnd I f '* old version of get  <pMessage = "Enter a F N(Exclude Path)"2pTitl0#pText5!InC= In\Box(3, , "JRNLIMP. TXT"),If Len(Trim(!)) > 0 ThenY."C:\Temp\" &59PostRowl|17  '}E7 sdup headXvaluesgBus_Unit.UCase(@*matFCells(8PE")d.VA))@P.Journal_ID9DatvO10 mmddyoALedg7= -11E-Re-Cd-~JN<--EMS@Oc?] Trans_Ref_Num0Range\("Qd#HB?_DescLef t($Ar_HdBr, 30$:Currency_CoptUSDl-'Jrnl_CPlass?") ePQ StPore  Qi@n prop7ppositXCRP0rint`xab(1); "H"; T2%V#n7 GQc15; _C a3!cHC5C8 >7H :c8;59` 411H 1;Do Whot IsEmpty;]{bCzTC\'$Accou@0= RDPFu q(' Dep'F TProgra`g2G4jec|H1_8ISc riofXH}#StatisticsEr8K 8_Am{$@L"]MHeqCLFp&N , 2GpLineJOKZGspFing FpFaF* F"LFtd:6;yC22#4<1a.7025%8-14F a+zLL17Ae&T82#}2Q%!V34 4AVD8Yc#J dF/+ Loopb wP uploadthe t eng" funcrcFdonQr0pF @kt l. Add an `ty" to u_*reMgm= T~ 5 " q mustp "& _4 "BUDGETS"ف 5With trol_TotalP}cn PeyPle y%Bs.'? 9ry> L4= T vbExclamation + vbOKOnly, "Unbalanced Journal Entry" cEnd0( If .&With%Sub 'this routine deletes the reversdate whencode 7not D I CheckRe3C()v@ Range("0_CD"kIf .Value = "D" T6qw 'c.?Hs o if uhser\f`CompareD`bslse.'for all bor vLA pplic.ScreenUpFing\Fa,3Goto Refere@x:="@lookupvCurt_Passwd@SacCE.*A@veSheet.Unprotect ( W _AD"). ClearContentxs 'Ç bI "BUDGETS~ A1JJA>> j5a8h hht"ih#hQ@}O胳hA9erx2 first 8 char8act@34filrm4:;#)d_`(se ((OonI(((X"Fd")(UCase(LeXft( W Tb!p .Nam0h8)- loo`_VBA_PROJECT2dir\CPROJECTwmjVPROJECT l#tectfDrawingObjectsߺContents= Scenarioskpassword strfilenameeremove_formulasCCheck_for_BalanceeCheckReversalCode6mydaynmymonth%myyearSvardateNow%GetSaveAsFilenameInitialFileName&Path2 fileFilterUCase5 Trim@CellsIsEmpty  CompareDates;j ClearContents{Row PasteSpecialKxlValueso OperationyxlNone SkipBlanksұ Transpose WorksheetsActivate|PrintOut.Copies?Collatedelete_ScenarioVClearActiveWorkbook cmd20Rows cmd100Rows cmdCreateFile]l "$'Qc6ft Office 16.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\WINDOWS\system32D04C-5BFA-101B-BHDE5EAAC4 2Egram Files\C ommonMicrosoft Shared\OFFICE16\MSO.DLL#M 16.0 Ob LibraryKMSForms>SFrms3 D452EE1-E08F0A-8-02608C4D0BB4 SINDOWS\sSFM20L'B _&/;"1jIqAHq00}#0Bq# 50 A21556396-88EA-4347-B158-5E371DD 7@>76𲹳ٳٲٲdz𳾱泦08.0c8.