ࡱ> b  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry F`l?!Workbook {_VBA_PROJECT_CUR" >`l?Ctls  ZO\p Jill Heath Ba= ThisWorkbook=K8X@"1Arial1Arial1Arial1Arial1 Arial1 Arial1 Arial1 Arial1Arial1Arial1QTahoma1QTahoma1$Arial1Arial1QTahoma1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>141<Calibri1?Calibri1h8Cambria1Calibri1 Calibri1Arial1Arial1Arial1 Arial1 Arial1Arial1Arial1Arial"$"#,##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 ||8L}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`q\ Journal IU _xlfn.SINGLEBus_Unit:# Control_Total: " Copy_row;00 Descr_Hdr: FileName:  Jrnl_Date: Jrnl_ID:Ledger: lookup:   ;/  ;! Reversal_Cd: # Reversal_Date: Source: 5f6f ?>@  (.O $">+M7k@=>+M7k l$xVKkSAM&iXME(  hGM4KFW_7.UeAW* ҍsrΜ993so yLC <} <죾dzX`p ^5zӅWC0N0!ѓGhZCwarJ.yN%10(A 佴QMg Z~qRp,g %sX(WG"nYvRV.駈2;"bc٨6o,d9:m"qRNrZCŧV:r&ICDZK$N|_kov\Gz5tVX.K7Zu_DV:Owsˡs65};KkޯCUGDHTI~L ƳI QB'FAP?5e2 4eY$7E7}XgUBْq_^jԹ-%~\ZafM$S5zm,^^t7D7F5x>= +ݵZ3E+ Q&-#^DX‚Kq^oGs R#ao|ruc|}&.&J?'C"f7c=#:@=f7c=#: i!xVKq~f#DD1=Xx%"C*k%X1:I+IQ:tN߱V=̾S}y7[2aHfq ޹+;m8-!y*&ix׽(޾tb ԥ4#=NţA+IV}~EI ƵÒk;lOҟqD!CI] yV*r_As rpNs{{2h#zXkݳT*<#!~3\ un-g\yFC}s C#{~}߱,o`vn65)u\T}['/4[ ﯶ0z}t}pS_0@!Yȶ+9+t3GNήY"9 |b 3o@6ëf:5_k7duh!դ0A7cbO?)vO4%G⩸4x_6 V5uVoKb+ Bii7cU/O1B_Gg$ QD"8O ugqrtj@= O ugqrtj :d-rxVKkQMkIAPEJ}ucU bA\hS!j)Mn…*TPŕPBq/pWŭT7\ 2={f8%Bn pH>?8Cz>+4m1_kMx8`*.Ξk ݡ HR y D3y=JA# {ŕbH]<Ւw8GM.YV)Eaa(zr=2jNG~#NVVLx0sꑣG6yS _a* 5W(U( $~_5[Ί4 ;W̕ 7.ljU2Jy.Qa`GP{?z/rlV.+ [хnh#lOR kuժQ7I$"Epyr=_kd!Uy Bcʪ%:;";Cˬu XnX}jȦ7WoH\T'N kT4*ՐM W'NVCDګ%ǩa{M7*t =NVr.9N ۫Τ(4*߇ 8}XW{Un85l]yCG\>Q=S7}Ƭ$4m5_w"Y_+RD/Y̡ȉl22w(43uolNfOϖp۵p?]BJY>a }f!=Ey[)fгH?.}beE'R5[e6]<^-wRtS^"O&ɒ+V+k4A +> 'Q 15O$fnQS,Ѿ]Dw{Q\wji]ՇYh*&srC9)BL wxΎh&fB}R?#=3  @@  ~42File: Business Unit Date Prepared Journal DateJournal Description Email to:LineAcctFundDeptPrgmBus UnitClassScenario Stat CodeStat AmtLine Description Journal IDNEXTLedgerACTUALSSource Reversal Code Reversal DateBDNMonetary Amountsource Reversal Cd Ledger Grpbuwork area for data validationangelControl Total Reference#CFS Inter Unit Journal Entry UploadJournal Reference Version 1.0Project / GrantCal State San MarcosSMCMPSMFNDSMURSX??X???accounting@mailhost1.csusm.edu IUINT Rev.2/19/21:GL LsL[M MgANNncc6 PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭Vȉ<&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] +2q ZO X4՚0X6^< d!-B:jFRQZ  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} m } } A} $ F} F}  } $ } $ } I } $  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.+ IU Journal Upload template_021921.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# m5^D  Bia_`e@ @IIAj^ia_`e@ AIIAj^./P?%L  L Bia_`e@ @IIAA^ia_`e@ AIIAA^ia_`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@ AIIAAD lDjNhp&rhh\4$$Se.~KKKKKKKKKKKK !"#$%&'()*+,-./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^QeiG_`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  !"#$%&'()*+,-./012345678:;<=>?2iwiЩFR;1 <Cannot exceed 30 characters.< =~~  <8 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. <  ~~  < XPP? ]4@ %σ@  D<EA sequential line number is assigned automatically. No manual entry.< D@@~~  < XPP? i]4@ 'ػbFEn* <SMCMP SMFND SMURS< o  ~~  <h XPP? X/K]4@ Zm#{Kɔ1D 2<3Account number must be between 100000 and 999999. < "2,`~~   <X XPP? ]4 @ vq$I/{ 1 .</Fund code must be 5 characters, numeric only. < .,`~~ ! < 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~~ # <آ 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.< =  T8 X? I HZ]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 ? ?ThisWorkbook Sheet1 9Module1DME (SLSS<N0{00020819-0000-0000-C000-000000000046}`$2D@& A- (pi*  .,< I$ 0i  `Hh%`0hh" "  ( T0 0"xbX  n0  2B   (08@ Px]00A@,oPMthis 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? $2 $2 $2 $2'0 0SPress YES if you want to delete it. Press NO if you want to keep it and add to it.'0 6 8 '4JRNLUPLOAD File': $$< 0 4 :$>'& & @ $A@B $ has been deleted. $2 $2 $2 D F File DeletedA@>kXkPoH+this function determines if the file exists]P $$~'H H'<d'<kiqAttribute 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 !uYmXTgcx(cmd20Rows, 38, 0, MSForms, CommandButton)cmd100Rows, 39, 1, MSForms, CommandButton,cmdCreateFile, 49, 2, MSForms, CommandButtonME(SLSSsN0{00020820-0000-0000-C000-000000000046} L@ P T X(% %*h0 %*` %*88 *\R8004*#5d " " ( "08@ "HPXhA@Noh@A@RoPA@Vo8A@Zo 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@0* pHd VBAProject4@j = r ;] J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\SysW OW64\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files (x86)\Common \Microsoft Shared\OFFICE16\MSO.DLL#P 16 .0 Ob LibraryNMSFo@rms>SFrmHs3D452EE1-E08F1A-8-026 rows via a pushbutton ****` (lookup B@ !'^ ^ B@'d d bCopy_Row B@ B@1:1 %%!B@H  B@ !(A1:B1 %%B@H ( B@A1:B1 %%B@H B@A1:B1 %%B@H d 'd ( ^ B@ (o8this routine inserts 100 rows via a pushbutton **** (lookup B@ !'^ ^ B@'d de bCopy_Row B@ B@1:1 %%!B@H  B@ !(A1:B1 %%B@H ( B@A1:B1 %%B@H B@A1:B1 %%B@H d 'd ( ^ B@ (o8]@ $~'H H '<d'<kiX Get filenameA@A@delete_ScenarioA@]]]]] 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 'f $< 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$!$$$'n E$!$$$'p E$!$mmddyyyy$'r E$!$$$'t J$!$$$'v J$!$mmddyyyy$'xJ$!$$$'zFileName$'| Descr_Hdr$!$'USD'(Jrnl_Class = Range("????") '**; Store Header values in proper position **** :OH n p1XTJGxMEh^grh`x8h0fthboth:mXhdh4hfhh hjhlhnhpHr hthvhxhzh|h~hhhhhhhhhhhhhhhh R N+<X  I `H VY@ ```` P      ZP    , ( `  @` >("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] 089] H`x-63] 1_C]  8Pbr] h] ] ] (@Xp] ] ] 0H7this routine inserts 20 r% t9 v: xN zQ |Y w D f$$b fC$!$'n fD$!$' fE$!$$' fF$!$$' fG$!$$' fH$!$$' fI$!$$' fJ$!$$' fK$!$$'L f$!'M f$!' fN$!$$' fO$!$$'>**storing Line values in proper postion*** % C X L n t . F K P         f 'fF** 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. $2 $2 $2 $2'0 0It has been saved'0 F 8 '4 Text File': 0 4 :A@>o Ithis routine checks that the reversal date is later than the journal date Jrnl_Date$ Reversal_Date$  The Reversal Date must be later $2 $2 $2than the Journal Date. D F Date ConflictA@>g k o <this routine checks for a balanced JE for non-Budget ledgersPLedger$'t tBUDGETS Control_Total$5 &Please check your totals. This Journal $2 $2 $2Entry is not Balanced. D F Unbalanced Journal EntryA@>gX 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@ !'^ ^ B@ Reversal_Date$B@H B@(delete reversal date ( ^ B@ (kxqpohIthis routine removes any formulas in the amounts and stat amounts columns 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 BudgetP (lookup B@ !'^ ^ B@Ledger$'tCopy_row$!'l tBUDGETSJ17:J l$B@H B@kx ( ^ B@ (o 2this routine inserts the first 8 characters of the#filename into the Journal Reference (lookup B@ !'^ ^ B@ !!$$Filename+ ^ 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_PROJECTVdirYDPROJECTwmgVPROJECT i+  CutCopyModePasteProtectfDrawingObjectsߺ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!K ]6ysWOW64\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{E32A0AEA-6B37-435B-949A08C4 D0BB4TINDOWSTFM260L'B @a&/;"1lrAAr00}#0r#G 50 AE32A0AEA-6B37-435B-949A-46E3C5@D057856Users\jheath\AppData\Local\Temp\Excel8.0cB8.exddU=#.E .`M BXTBThisWorkbookGTim"Wokbok 2 (HB1Bm XB,fT"""+sS@heet1G SŠeat1 awm2 s g "Wodule#WouAn2D[ @NJG!bXTThisWorkbook01621f81e6ThisWorkbookThisWorkbookSheet1Sheet1Module1Module1K Sheet1gsMID="{ECD9A93C-A1A5-45D4-B67E-55EC18C9CBD1}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Module=Module1 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="8785A833A83D2B412B412B412B41" DPB="0E0C21BC2FC4B7C5B7C5B7" GC="9597BA41C6C9C7C9C736" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 &H00000002={00020818-0000-0000-C000-000000000046};Excel8.0;&H00000000 [Workspace] ThisWorkbook=66, 66, 1330, 810, Sheet1=66, 66, 680, 514, Module1=154, 154, 1222, 832, Oh+'00 X`x   (JRNLUPLOAD FileMichael Holder@Journal Upload workbook for Peoplesoft 8.4 Actuals and Budget Jill HeathMicrosoft Excel@^w@@w}>foreCloseCancel JournSummaryInformation( r`DocumentSummaryInformation8xCompObjla  ,*\G{000204EF-0000-0000-C000-000000000046}#4.2#9#C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL#Visual Basic For Applications&*\G{00020813-0000-0000-C000-000000000046}#1.9#0#C:\Program Files (x86)\Microsoft Office\Root\Office16\EXCEL.EXE#Microsoft Excel 16.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\SysWOW64\stdole2.tlb#OLE Automation4*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.8#0#C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\MSO.DLL#Microsoft Office 16.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\WINDOWS\SysWOW64\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{E32A0AEA-6B37-435B-949A-46E3C5D05785}#2.0#0#C:\Users\jheath\AppData\Local\Temp\Excel8.0\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M  ;]XTThisWorkbook01621f81e6!ThisWorkbookf"m Sheet106621f81e6K Sheet1gsModule103621f81e6\Module1JG01P0n# Js߇dm@E }c LAz049^GotoExcel+VBAWin16~Win32Win64xMacVBA6#VBA7# VBAProjectstdole`OfficeuMSFormsC ThisWorkbook| _Evaluate strfilename2FResponseWorkbook_BeforeCloseCancel Journal_Ref Workbook_OpenmsgQChrK~StylepvbYesNo vbInformationnTitle~ fileexistsMsgBoxRvbYesa?Kill vbExclamationvbOKOnlyXoSheet1cmd100Rows_ClickK Add100RowsPcmd20Rows_ClickG Add20RowsIcmdCreateFile_Clickxcreate_FlatFilecmdPrintJE_ClickPrintJournalEntryModule1bCurrent_PasswdPasswdBMessageRowAdded PostRow/GetInputeInFile}intI\Bus_Unit~ Journal_ID) Journal_DateLedgerO  Reversal_Cdj Reversal_Dateq Journal_Source Trans_Ref_Numrlast_RowYp Header_Desc' Currency_Codec Jrnl_ClassAccount Fund[0DeptOProgramHClassProject- Line_DescC Jrnl_Ln_RefwStatistics_CodeScenario ReferenceeAmountiStatistic_Amount Application*ScreenUpdating!  SelectionZValueK ActiveSheet%N Unprotect?Copyƿ ActiveCellOffsetRowsU EntireRowInsertrShiftxlDown0DHidden]Range ՜.+,D՜.+, PXx  Sonoma State University  Journal IU Bus_UnitControl_Total Copy_row Descr_Hdr FileName Jrnl_DateJrnl_IDLedgerlookup'Journal IU'!Print_Area'Journal IU'!Print_Titles Reversal_CdReversal_DateSource  Worksheets Named Ranges(X` _PID_HLINKS_NewReviewCycleA=&mailto:accounting@mailhost1.csusm.edu F Microsoft Excel 2003 WorksheetBiff8Excel.Sheet.89q