{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Overview","AR Invoice Form","Grid Sample","misc"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":24,"comments":0,"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":"Overview","index":0,"n_rows":97,"n_cols":8,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"version: 2023-12-10"]
[]
[null,"Accounts Receivable - 3-2 Receivable Invoices/Credits"]
[]
[null,"The following template should be used to import AR invoices into Sage 100 Contractor.  "]
[]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header"]
[null,"Header","Field","Reference","Data Type","Tab","Example","Description"]
[null,"COL1","filetype","Required","String (5)","Import","ARINV","(File Type Code)"]
[null,"COL2","linetype","Required","String (1)","Import","H","(Line Type Code)"]
[null,"COL3","invnum","Required","String (20)","Header",null,"Invoice No"]
[null,"COL4","jobnum","Required **","Numeric","Header",null,"Job Number"]
[null,"COL5","dscrpt","Required","String (50)","Header",null,"Invoice Description"]
[null,"COL6","invdte","Required","Date","Header",null,"Invoice Date"]
[null,"COL7","duedte","Required","Date","Header",null,"Due Date"]
[null,"COL8","dscdte","Required","Date","Header",null,"Discount Date"]
[null,"COL9","status","Required **","Numeric","Header","1-Open, 2-Review, 3-Dispute","Status"]
[null,"COL10","invtyp","Required **","Numeric","Header","1-Contract, 2-Memo","Invoice Type"]
[null,"COL11","phsnum","**","Numeric","Header",null,"Phase No"]
[null,"COL12","taxdst","**","Numeric","Header",null,"Tax District"]
[null,"COL13","pchord",null,"String (20)","Header",null,"Client PO#"]
[null,"COL14","refnum",null,"String (20)","Header",null,"Reference #"]
[null,"COL15","usrdf1",null,"String (50)","Header",null,"User Def1"]
[null,"COL16","usrdf2",null,"String (50)","Header",null,"User Def2"]
[null,"COL17","dscavl",null,"Numeric (10,2)","Header",null,"Discount Avail"]
[null,"COL18","retain",null,"Numeric (10,2)","Header",null,"Retention"]
[null,"COL19","hotlst",null,"Numeric","Header","1=Yes; 0=No","Hot List"]
[null,"COL20","ntetxt",null,"Text","Header",null,"Notes"]
[null,"COL21","postprd","(1)","Date",null,null,"Posting Period"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[null,"COL: a placeholder must be provided for each column even if no value is provided"]
[null,"(1) If posting period is left blank then the Invoice Date will be used as the posting period"]
[]
[null,"Details"]
[null,"COL1","filetype","Required","String (5)","Import","ARINV","(File Type Code)"]
[null,"COL2","linetype","Required","String (1)","Import","D","(Line Type Code)"]
[null,"COL3","invnum","Required","String (20)","Header","(Same as header)","Invoice No"]
[null,"COL4","invjobnum","Required **","Numeric","Header","(Same as header)","Job No"]
[null,"COL5","dscrpt","Required","String (75)","Detail",null,"Line Description"]
[null,"COL6","prtnum",null,"bigint","Detail",null,"Part #"]
[null,"COL7","untdsc",null,"String (10)","Detail",null,"Unit Desc"]
[null,"COL8","linqty",null,"Numeric (12,4)","Detail",null,"Qty"]
[null,"COL9","linprc","(1)","Numeric (15,6)","Detail",null,"Unit Price"]
[null,"COL10","taxabl","**","String (1)","Detail","Y=Yes; N=No","Taxable"]
[null,"COL11","lgract","Required **","Numeric","Detail",null,"Account"]
[null,"COL12","subact","**","Numeric","Detail",null,"Sub-Account"]
[null,"COL13","cstcde","**","Numeric (15,3)","Detail",null,"Cost Code"]
[null,"COL14","usrdf1",null,"String (50)","Detail",null,"User Def 1"]
[null,"COL15","ntetxt",null,"Text","Detail",null,"Notes"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[null,"COL: a placeholder must be provided for each column even if no value is provided"]
[null,"(1) Price may not be a negative value. If the line amount is negative you must make the \"Quantity\" negative"]
[]
[null,"Job Cost Details (Required if a \"WIP Asset\" or \"Direct Expense\" account is used and the net sum of these accounts is not zero)"]
[null,"COL1","filetype","Required","String (5)","Import","ARINV","(File Type Code)"]
[null,"COL2","linetype","Required","String (1)","Import","J","(Line Type Code)"]
[null,"COL3","invnum","Required","String (20)","Header","(Same as header)","Invoice No"]
[null,"COL4","invjobnum","Required **","Numeric","Header","(Same as header)","Invoice Job No"]
[null,"COL5","jobnum","Required **","Numeric","Job Cost",null,"Job No"]
[null,"COL6","wrkord","**","String (20)","Job Cost",null,"Work Order No"]
[null,"COL7","dscrpt","Required","String (50)","Job Cost",null,"Description"]
[null,"COL8","phsnum","**","Numeric","Job Cost",null,"Phase No"]
[null,"COL9","cstcde","Required **","Numeric (15,3)","Job Cost",null,"Cost Code"]
[null,"COL10","csttyp","Required **","Numeric","Job Cost","1=Material; 2=Labor; 3=Equipment; 4=Subcontract; 5=Other; 6=Utilities; 7=Purchase Order; 8=Work Order; 9=User Def Type 9","Cost Type"]
[null,"COL11","cstamt","Required","Numeric (10,2)","Job Cost","(Negative Amount)","Cost Amount"]
[null,"COL12","ntetxt",null,"Text","Job Cost",null,"Notes"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[null,"COL: a placeholder must be provided for each column even if no value is provided"]
[]
[null,"Equipment Cost Details (Required if a \"Equipment Expense\" account is used and the net sum of these accounts is not zero)"]
[null,"COL1","filetype","Required","String (5)","Import","ARINV","(File Type Code)"]
[null,"COL2","linetype","Required","String (1)","Import","E","(Line Type Code)"]
[null,"COL3","invnum","Required","String (20)","Header","(Same as header)","Invoice No"]
[null,"COL4","invjobnum","Required **","Numeric","Header","(Same as header)","Invoice Job No"]
[null,"COL5","eqpnum","Required **","Numeric","Equip Cost",null,"Equip No"]
[null,"COL6","eqdscrpt","Required","String (50)","Equip Cost",null,"Description"]
[null,"COL7","eqcstcde","Required **","Numeric (15,3)","Equip Cost",null,"Cost Code"]
[null,"COL8","eqcsttyp","Required **","Numeric","Equip Cost","1=Material; 2=Labor; 3=Equipment; 4=Subcontract; 5=Other; 6=Utilities; 7=Purchase Order; 8=Work Order; 9=User Def Type 9","Cost Type"]
[null,"COL9","cstamt","Required","Numeric (10,2)","Equip Cost","(Negative Amount)","Cost Amount"]
[null,"COL10","eqnotes",null,"Text","Equip Cost",null,"Notes"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[null,"COL: a placeholder must be provided for each column even if no value is provided"]
[]
[null,"File Example:"]
[null,"ARINV,H,\"ART1\",2017008,\"AR Test 1\",\"5/25/2017\",\"5/25/2017\",\"5/25/2017\",1,1,,,\"\",\"\",\"\",\"\",,,0,\"\",\"\""]
[null,"ARINV,D,\"ART1\",2017008,\"AR Line 1\",,\"\",1,50,\"N\",4000,,,\"\",\"\""]
[null,"ARINV,D,\"ART1\",2017008,\"AR Line 2\",,\"\",1,75,\"N\",4001,,,\"\",\"\""]
[null,"ARINV,J,\"ART1\",2017008,2017008,\"\",\"Test AP Invoice\",,2120.000,4,150,\"\""]
[null,"ARINV,E,\"ART1\",2017008,1,\"Test AP Invoice\",2010.000,3,180,\"\""]

{"sheet":"AR Invoice Form","index":1,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,2,11,3]]}
["Sample AR Invoice Form"]
[]
[]
[null,"Invoice No: *","ART1",null,"Invoice Date: *","2017-05-25","Status: *",1]
[null,"Description: *","AR Test 1",null,"Due Date: *","2017-05-25","Type: * ",1]
[null,"Job:  *",2017008,null,"Discount Date: *","2017-05-25"]
[null,"Phase:  ",null,null,"PO #: ",null,"User Def 1: "]
[null,"Tax District:",null,null,"Reference No: ",null,"User Def 2: "]
[null,null,null,null,null,null,"Discount Avail:"]
[null,"Notes:","zz",null,false,null,"Retention:"]
[]
[null,null,null,null,"","","Posting Period:"]
[]
[]
[]
[null,null,"Invoice Details"]
[null,null,"Line Description *","Part No","Unit of Measure","Quantity","Price","Taxable\nY or N","Account *","Sub Account","Cost Code","User Def 1","Notes"]
[null,null,"AR Line 1",null,null,1,50,"N","4000"]
[null,null,"AR Line 2",null,null,1,75,"N","4010"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Job Cost Details (Required only if a \"Direct Expense\" account is used on any AP Invoice line)"]
[null,null,"Job No *","Work Order No","Description *","Phase No","Cost Code *","Cost Type *","Cost\nAmount *","Notes"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Equipment Cost Details (Required only if an \"Equipment Expense\" account is used on any AP Invoice line)"]
[null,null,"Equip No *","Description *","Cost Code *","Cost Type *","Cost Amount *","Notes"]

{"sheet":"Grid Sample","index":2,"n_rows":16,"n_cols":22,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Sample Template"]
[]
[]
[null,"COL1","COL2","COL3","COL4","COL5","COL6","COL7","COL8","COL9","COL10","COL11","COL12","COL13","COL14","COL15","COL16","COL17","COL18","COL19","COL20","COL21"]
[null,"ARINV","H","Invoice No","Job No","Invoice Description","Invoice Date","Due Date","Discount Date","Status","Invoice Type","Phase No **","Tax District **","Client PO#","Reference #","User Def1","User Def2","Discount Avail","Retention","Hot List","Notes","Posting Period"]
[null,"ARINV","D","Invoice No","Job No","Part # **","Line Description","Unit Desc","Qty","Unit Price","Taxable","Account **","Sub-Account **","Cost Code **","User Def 1","Notes"]
[null,"ARINV","J","Invoice No","Job No","Job No **","Work Order No **","Description","Phase No **","Cost Code **","Cost Type **","Cost Amount **","Notes"]
[null,"ARINV","E","Invoice No","Job No","Equip No **","Description","Cost Code **","Cost Type **","Cost Amount","Notes"]
[]
[]
[null,"ARINV","H","Inv #25","2017008","Inv #23 Test Invoice","2017-05-20","2017-05-20","2017-05-20",1,1]
[null,"ARINV","D","Inv #25","2017008","AR Line 1",null,null,1,200,null,6002]
[null,"ARINV","D","Inv #25","2017008","AR Line 2",null,null,1,300,null,6003]
[null,"ARINV","H","Inv #26","2017008","Inv #23 Test Invoice","2017-05-20","2017-05-20","2017-05-20",1,1]
[null,"ARINV","D","Inv #26","2017008","AR Line 1",null,null,1,200,null,6002]
[null,"ARINV","D","Inv #26","2017008","AR Line 2",null,null,1,300,null,6003]

{"sheet":"misc","index":3,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["1 - Open",null,null,"1 - Contract"]
["2 - Review",null,null,"2 - Memo"]
["3 - Dispute"]