{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions-LoadedToMPathways","Data","Errors","Print View","Local Variables","ErrorCodes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":22,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions-LoadedToMPathways","index":0,"n_rows":80,"n_cols":10,"rows_kept":80,"cut":false,"hidden":false,"merged":[[2,1,2,9],[5,3,5,9],[6,3,8,9],[9,2,10,2],[9,3,10,9],[11,4,11,8],[3,1,3,9],[12,4,12,8],[13,1,15,1],[13,4,14,8],[13,9,14,9],[15,4,15,8],[16,1,17,1],[16,4,21,8],[22,3,24,3],[22,4,24,8],[25,3,26,3],[25,4,26,8],[25,9,27,9],[27,3,28,3],[27,4,28,8],[29,3,31,3],[29,4,31,8],[32,3,32,9],[33,3,35,9],[37,4,37,8],[38,4,41,8],[41,1,42,1],[42,3,45,3],[42,4,45,8],[42,9,45,9],[43,1,45,1],[46,3,47,3],[46,4,47,8],[46,9,47,9],[48,4,50,8],[51,4,55,8],[56,4,58,8],[59,4,61,8],[59,9,61,9],[62,4,62,8],[63,3,64,3],[63,4,64,8],[63,9,64,9],[65,4,66,8],[65,9,66,9],[67,3,67,9],[77,1,78,1],[77,3,77,10],[79,1,81,1],[79,3,81,9],[68,1,70,1],[68,3,69,9],[71,1,72,1],[72,3,76,9],[73,1,76,1]]}
[]
[]
[null,"Journal Upload Procedures:"]
[null,"(Dept uploads JE in M-Pathways)"]
[]
[null,"Step 1",null,"~Open the Excel upload loader file located on Financial Operations website at http://www.finops.umich.edu/FormsReports/Forms/jrnlload.xlt"]
[null,null,null,"~When prompted select ' Enable Macros', this will enable you to use the features of the template for creating a load file (*.dat file type)."]
[]
[]
[null,"Step 2",null,"~Begin the journal by completing the Journal Header information on the first available row in the Excel upload template (Row 3).  Please note that the grayed area should not be filled. "]
[]
[null,null,null,"Column Name","Field Instructions",null,null,null,null,"Sample Content"]
[null,null,null,"Record Type:      (H)  ","This field tells the loader program that the row contains either header information (H) or line information (L).  For the header, we populate the field with the letter 'H'.",null,null,null,null,"H"]
[null,"Required fields are in bold",null,null," Enter 'NEXT' which tells M-Pathways to assign the next available number as the Journal ID.",null,null,null,null,"NEXT"]
[null,null,null,"Journal ID"]
[null,null,null,"Journal Date","The date of the journal transaction in MM/DD/CCYY format. This date should be for the current open period.",null,null,null,null,"2008-02-08"]
[null,null,null,null,"A code used to identify the source of the Journal Entry.  Your department should have a source assigned to it (i.e. MED for Medical School).  Using the correct source will help identify which school prepared a certain Journal Entry.  "]
[]
[null,null,null,"Source",null,null,null,null,null,"MED"]
[]
[]
[]
[null,null,null,"Transaction Reference Number","A 10 character alphanumeric value representing a user defined reference to the transaction. "]
[null,null,null,null,null,null,null,null,null,"PCARD"]
[]
[null,null,null,"Journal Description","A description of the journal transaction.  This line allows 254 characters.  ",null,null,null,null,"Tsf Lab Supplies to correct transposition error."]
[]
[]
[]
[null,null,null,"Journal Requester Uniqname","This is the uniqname of the person that requested the journal entry and can answer questions regarding this Journal."]
[null,null,null,null,null,null,null,null,null,"mmmi"]
[]
[]
[null,null,null,"~Continue to the next available row in the Excel upload template (Row 4).  For each line of the journal  entry, you have to place a 'L' for line in column A and complete a new row according to the field instructions below. Please note that the gray area should not be filled."]
[null,"Step 3"]
[]
[]
[null,null,null,"Column Name","Field Instructions",null,null,null,null,"Sample Content"]
[null,null,null,null,"This field tells the loader program that the row contains either header information (H) or line information (L).  For each line, populate the field with the letter 'L'."]
[null,null,null,"Record Type:"]
[null,null,null,"(L)"]
[null,null,null,null,null,null,null,null,null,"L"]
[null,null,null,"Account","A code used to record and summarize financial transactions such as assets, liabilities, fund balances, revenues, expenses, statistics or budget accounts.",null,null,null,null,616650]
[null,"Required fields are in bold"]
[]
[]
[null,null,null,"Fund Code","A code used to identify the source of funds and intended use of the funds.",null,null,null,null,52000]
[]
[null,null,null,null,"A code that identifies each academic or administrative unit that has programmatic, operational and fiscal (including budgetary) responsibility."]
[null,null,null,"Department",null,null,null,null,null,688180]
[]
[null,null,null,null,"A code identifying a group of related activities, cost centers, revenue centers, responsibility centers and academic programs.  These activities may occur within a single department or across multiple departments."]
[]
[null,null,null,"Program Code",null,null,null,null,null,13321]
[]
[]
[null,null,null,null,"A code used to group related activities directed towards the accomplishment of a set of common identifiable objectives or purposes."]
[null,null,null,"Class",null,null,null,null,null,92320]
[]
[null,null,null,null,"A code used to accumulate financial information on a set of activities over a limited time span.  Used for contracts and grants, construction projects and unit-defined projects.",null,null,null,null,"C459157"]
[null,null,null,"Project/Grant"]
[]
[null,null,null,"Monetary Amount","The dollar amount associated with a financial transaction or chart of account balance.",null,null,null,null,7404.35]
[null,null,null,"Journal Line Reference","A 10 character alpha numeric reference for a journal line assigned by a user.",null,null,null,null,"P1234567"]
[]
[null,null,null,null,"A textual description of the journal line. Cannot be more than 30 characters.",null,null,null,null,"Tsf PCD1234567 12/07"]
[null,null,null,"Line Description"]
[]
[null,"Step 4 - Multiple Journals",null,"~For Multiple Journals, simply start the next journal under the previous one by placing a 'H' and following it with the 'L' s for the lines you have. There is no limit to how many Journals you have on one file."]
[]
[]
[]
[null,null,null,"After completing the journal line rows, export the journal information into a data file (.dat file type).  Select the Developer tab and select the macros option.  From there, run the ExportDatFile macro.  A standard \"Save As\" dialog box will appear allowing you to specify location and file name to use when creating the file.  Select a location where you will keep your journal data file and name your file something short, easy to remember, and free from special characters or punctuation marks.  Note:  If you do not see the Developer tab do the following: \n\nFor Windows, select File > Options > Customize Ribbon. Under the Customize the Ribbon section, select Main Tabs and check the Developer check box.  \n\nFor Mac, select Excel > Preferences... > Ribbon > check the Developer check box. "]
[null,"Step 5"]
[]
[]
[]
[null,"Step 6",null,"Load the .dat file into M-Pathways.  See Uploading a Journal Entry Data File into M-Pathways v 8.8 job aid in My Linc."]
[]
[null,"Step 7-            Print Option",null,"~To generate a printable view of a selected upload, simply click on the H cell of the journal you wish to print and from the Journal Uploads drop-down menu, select 'Print'.  For upload files that have multiple Journal IDs, you will need to do this step for each journal desired to be printed."]

{"sheet":"Data","index":1,"n_rows":5,"n_cols":17,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,1,0,6],[0,7,0,16]]}
[null,"HEADER(S)",null,null,null,null,null,"LINE(S)"]
["Record Type \n(H or L)","Journal ID","Journal Date","Source","Transaction Reference Number","Journal Description","Journal Requester Uniqname","Account","Fund","Department","Program","Class","Project/Grant","Monetary Amount","Journal Line Reference","Line Description","Stat Amount"]
["H","NEXT","2024-07-01"]
["L",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["L",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Errors","index":2,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"Validation Results",null,null,null,{"$f":"NOW()","v":"2024-08-27T11:43:48.670"}]
[null,"Error Code","Error Description","Error Type","Cell Value","Cell Address"]

{"sheet":"Print View","index":3,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[[10,4,11,14],[12,2,12,14]]}
[]
[null,"Control Record:"]
[null,null,null,null,"Journal Lines:",null,null,null,null,null,null,null,null,"Journal Author:","mbumby"]
[null,null,null,null,null,null,null,null,"Total Debits",null,"Total Credits"]
[null,"Header:"]
[]
[null,null,"Journal ID:",null,null,null,null,"Journal Date:",null,null,"Source:",null,null,"Authorization:"]
[]
[null,null,"Transaction Reference:"]
[]
[null,null,"Description:"]
[]
[null,null,"This document represents a draft version of the journal entry.  For a final, posted version of this journal entry, obtain a printed version from M-Pathways or the Datawarehouse."]
[null,"Lines:"]
[null,null,null,"Account","Fund","DeptID","Program","Class","Project/Grant",null,"Monetary Amount","Journal Line Reference","Line Description",null,"Stat Amount"]

{"sheet":"Local Variables","index":4,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["User Information:"]
["Uniqname:","dhovey"]
["Phone Number:","647-3499"]
[]
[]
["File Information:"]
["Import File Location:","\\\\its-users.m.storage.umich.edu\\its-users\\HomeFolders\\jeffgree\\Desktop\\BCjournal_upload.dat"]
[]
["Control Debits",{"$f":"SUMIF(JournalAmounts, \">0\")","v":0}]
["Control Credits",{"$f":"SUMIF(JournalAmounts, \"<0\")","v":0}]
["Header Count",{"$f":"COUNTIF(Data!$A$3:$A$65536,\"H\")","v":1}]
["Line Count",{"$f":"COUNTIF(Data!$A$3:$A$65536,\"L\")","v":2}]

{"sheet":"ErrorCodes","index":5,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Error Code","Error Description","ErrorType","Tip"]
[100,"Invalid Journal ID","Critical","A valid Journal ID is 10 characters in length or 'NEXT'"]
[110,"Invalid Journal Date","Critical","Enter a valid date in MM/DD/CCYY format"]
[120,"Excess Field Length","Warning","Field length exceeds maximum allowed"]
[130,"Journal Unbalanced","Critical","Journal debits must equal journal credits"]
[140,"Journal ID and Journal Date Duplicated","Critical","Journal id and date must be a unique combination"]
[150,"Journal Description is required","Critical","Enter a complete description of the journal entry"]
[160,"Journal Unbalanced","Warning","Journal debits do not equal journal credits"]
[200,"Invalid Field Length","Critical","Account value must be 6 numeric characters or 'SHR'"]
[210,"Invalid Field Length","Critical","Fund Code value must be 5 numeric characters"]
[220,"Invalid Field Length","Critical","Department value must be equal to 6 characters"]
[230,"Invalid Field Length","Critical","Program Code value must be 5 characters in length"]
[240,"Invalid Field Length","Critical","Class value must be 5 character in length"]
[250,"Invalid Field Length","Critical","Project/Grant must be between 7 and 15 characters"]
[260,"Invalid Monetary Amount","Critical","Monetary Amount must be a valid numeric amount"]
[270,"Invalid Monetary Amount","Critical","If Account is 'SHR', Monetary Amount must be $0"]
[280,"Invalid Statistics Amount","Critical","If Acct is 'SHR', Stat Amt must be valid numeric amt"]
[290,"Invalid Field Length","Critical","Source must be 2 or 3 characters in length"]
[300,"Invalid Fund/Project Combination","Critical","Fund Codes 20000 and 25000 require a valid P/G"]
[310,"Invalid Field Length","Critical","Transaction Reference Number has a max length of 8"]
[320,"Invalid Field Length","Critical","Journal Authorizer (uniqname) has a max length of 8"]
[330,"Invalid Field Length","Warning","Journal Line Reference has a max length of 10."]
[340,"Invalid Monetary Amount","Critical","If not Stat acct, Monetary Amount may not be $0"]
[350,"Invalid Monetary Amount","Critical","If not Stat acct, Stat Amount must be $0 or blank"]
[360,"Journal Authorizer Missing","Critical","Enter a valid University Uniqname of the Journal's Authorizer"]
[370,"Invalid Monetary Amount","Critical","You may only have 2 digits after the decimal point."]
[380,"Invalid (Zero) Monetary Amount","Critical","The monetary amount on a journal line may not be zero."]
[400,"Invalid Selection","Critical","Type must be either 'H' or 'L'"]