{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["_information","_GL07_55","transactions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"_information","index":0,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[{"$nulls":5},"NOTES"]
[]
[null,"1)","The worksheet with the data must be called \"transactions\""]
[]
[null,"2)","The Text highlighted in \"Red\" shows the fields that can be changed."]
[]
[null,"3)","The fields with text in \"Black\" should not be changed."]
[]
[null,"4)","You are free to add columns within the data section if required."]
[]
[null,"5)","The \"cur_amount\" and \"Amount\" fields must exist within the data section."]
[]
[null,"6)","To create the reversals the user will need to run the macro by selecting the \"Reversals\" button within the menu."]
[]
[null,"7)","The \"Reversals\" function can be re-run, each time it will delete the created worksheet called \"reversals\"."]
[]
[null,null,"Therefore the user can amend the transaction worksheet as required, then re-run the \"Reversals\" to create the accrual postings for "]
[null,null,"the following period."]
[]
[null,"8)","Once the \"Reversals\" has been executed the following is performed:-"]
[]
[null,null,"a)","A new worksheet is created based on the original worksheet called \"transactions\" but with the opposite values"]
[]
[null,null,"b)","A new output file name is setup within the filename section with \"rev\" appended to the original file name"]
[]
[null,null,"c)","The next period is automatically setup for the accrual postings"]

{"sheet":"_GL07_55","index":1,"n_rows":67,"n_cols":7,"rows_kept":67,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Field Name","Width","Mandatory","Right Justify","Format","Multiplier"]
["batch_id",25,"",""]
["interface",25]
["voucher_type",25,"",""]
["trans_type",2,"",""]
["client",25,"",""]
["account",25,"",""]
["dim_1",25,"",""]
["dim_2",25,"",""]
["dim_3",25,"",""]
["dim_4",25,"",""]
["dim_5",25,"",""]
["dim_6",25,"",""]
["dim_7",25,"",""]
["tax_code",25,"",""]
["tax_system",25]
["currency",25,"",""]
["dc_flag",2]
["cur_amount",20,"","Y","0","100"]
["amount",20,"","Y","0","100"]
["number_1",11,"","Y","0"]
["value_1",20,"","Y","0","100"]
["value_2",20,null,"Y","0","100"]
["value_3",20,null,"Y","0","100"]
["description",255,"",""]
["trans_date",8,"","","yyyymmdd"]
["voucher_date",8,"","","yyyymmdd"]
["voucher_no",15,"",""]
["period",6,"",""]
["tax_id",1]
["ext_inv_ref",100,"",""]
["ext_ref",255]
["due_date",8,"","","yyyymmdd"]
["disc_date",8,"","","yyyymmdd"]
["discount",20,"","Y","0"]
["commitment",25,"",""]
["order_id",15,"",""]
["kid",27,"",""]
["pay_transfer",2,"","",null,null," "]
["status",1,"",""]
["apar_type",1,"",""]
["apar_id",25," ",""]
["pay_flag",1]
["voucher_ref",15]
["sequence_ref",9]
["intrule_id",25]
["factor_short",25]
["responsible",25]
["apar_name",255,"",""]
["address",160,"",""]
["province",40]
["place",40,"",""]
["bank_account",35,"",""]
["pay_method",2,"",""]
["vat_reg_no",25,"",""]
["zip_code",15,"",""]
["curr_licence",3]
["account2",25]
["base_amount",20,null,"Y","0"]
["base_curr",20,null,"Y","0"]
["pay_temp_id",4]
["allocation_key",2]
["period_no",2]
["clearing_code",13]
["swift",11]
["arrive_id",15]
["bank_acc_type",2]

{"sheet":"transactions","index":2,"n_rows":72,"n_cols":19,"rows_kept":72,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["type","GL07_55","Agresso Format 55"]
["filename","Y:\\journal.txt"]
[]
["*","Field Name","Defaults"]
["default","batch_id","999999"," "]
["default","interface","BI"]
["default","voucher_type","AA"]
["default","trans_type","GL"]
["default","client","P1"]
["default","account"]
["default","dim_1"," "]
["default","dim_2"," "]
["default","dim_3"]
["default","dim_4"]
["default","dim_5"]
["default","dim_6"]
["default","dim_7"]
["default","tax_code","0"]
["default","tax_system","NA"]
["default","currency","GBP"]
["default","dc_flag"]
["default","cur_amount"]
["default","amount"]
["default","number_1"]
["default","value_1"]
["default","value_2"]
["default","value_3"]
["default","description"]
["default","trans_date"]
["default","voucher_date"]
["default","voucher_no"]
["default","period"]
["default","tax_id"]
["default","ext_inv_ref"]
["default","ext_ref"]
["default","due_date"]
["default","disc_date"]
["default","discount"]
["default","commitment"]
["default","order_id"]
["default","kid"," "]
["default","pay_transfer"]
["default","status","N"]
["default","apar_type"," "]
["default","apar_id"]
["default","pay_flag"]
["default","voucher_ref"]
["default","sequence_ref"]
["default","intrule_id"]
["default","factor_short"]
["default","responsible"]
["default","apar_name"]
["default","address"]
["default","province"]
["default","place"]
["default","bank_account"]
["default","pay_method"]
["default","vat_reg_no"]
["default","zip_code"]
["default","curr_licence"]
["default","account2"]
["default","base_amount"]
["default","base_curr"]
["default","pay_temp_id"]
["default","allocation_key"]
["default","period_no"]
["default","clearing_code"]
["default","swift"]
["default","arrive_id"]
["default","bank_acc_type"]
[]
["columns","account","dim_2","dim_3","dim_4","dim_5","dim_6","dim_7","cur_amount","amount","description",{"$nulls":4}," ",null,null," "]