ࡱ> z~  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxy|}Root Entry FpV{WorkbookSummaryInformation(TDocumentSummaryInformation8 P `\pMichael R. Newland Ba=  ThisWorkbook=;8X@"1Calibri1Calibri1Calibri1Calibri1Calibri1" Wingdings1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1 Calibri1>Calibri14Calibri1<Calibri1?Calibri1h8Cambria1Calibri1 Calibri1Calibri1Calibri1 Calibri1Calibri1XCalibri1Calibri1 Calibri1 Calibri1Tahoma1Calibri1 Calibri"$"#,##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\);_(* "-"??_);_(@_):5_(* #,##0.0000_);_(* \(#,##0.0000\);_(* "-"??_);_(@_) 0.0%                                                                       ff + ) , *     P  P         `            a>    !x  3 !      (    `   @  `@   `   ``   (`   (`   (``     h@ @  "x@ @    8@ @   h@ @  !0  @7  H7  H7  H7  H7 X7 X7 !8  x@@ #  @ @ + @ @ + +@ @ + +@ @ + @ @ +   (  @ p@ @  (p@ @   H  h@ @  !  !0@ @  !4@ @  !0@ @  !0    h  h @ @ +   "x 7 +@@ + + @ +  "x@ @  "@ @ + "@ @ + ! ! @ @ + !0 !0`  !8@@ !8@ !8` @ !0@ "x@@  "x @  ,8"@@  ,8 " @  "x@ "x "x  Q! Q!  "x@@   "x@   "x` @    8   +@ @  8!@ @  !@ @ + !@ @ + #X #x  +@@+ + @+ +"8@ @  @ @+ +@ @+ +@ @+ x@ @  "@ @  "+@ @   @ @  ||u2w}-} 0.0000\)}-} 0.0000\)}-} 0.0000\)}-} 0.0000\)}-} 0.0000\)}-} 0.0000\)}-} 0.0000\)}-} 0.0000\)}-} 0.0000\)}-}  0.0000\)}-}  0.0000\)}-}  0.0000\)}-}  0.0000\)}-}  0.0000\)}-} 0.0000\)}-} 0.0000\)}A} 0.0000\)ef)_(@_) }A} 0.0000\)ef)_(@_) }A} 0.0000\)ef)_(@_) }A} 0.0000\)ef)_(@_) }A} 0.0000\)ef)_(@_) }A} 0.0000\)ef )_(@_) }A} 0.0000\)L)_(@_) }A} 0.0000\)L)_(@_) }A} 0.0000\)L)_(@_) }A} 0.0000\)L)_(@_) }A} 0.0000\)L)_(@_) }A} 0.0000\)L )_(@_) }A} 0.0000\)23)_(@_) }A} 0.0000\)23)_(@_) }A} 0.0000\)23)_(@_) }A} 0.0000\)23)_(@_) }A}  0.0000\)23)_(@_) }A}! 0.0000\)23 )_(@_) }A}" 0.0000\))_(@_) }A}# 0.0000\))_(@_) }A}$ 0.0000\))_(@_) }A}% 0.0000\))_(@_) }A}& 0.0000\))_(@_) }A}' 0.0000\) )_(@_) }A}( 0.0000\))_(@_) }}) }0.0000\))_(@_)    }}* 0.0000\))_(@_) ??? ??? ??? ???}-}+ 0.0000\)}-}, 0.0000\)}-}- 0.0000\)}-}. 0.0000\)}-}/ 0.0000\)}A}0 a0.0000\))_(@_) }A}1 0.0000\))_(@_) }A}2 0.0000\)?)_(@_) }A}3 0.0000\)23)_(@_) }-}4 0.0000\)}(}5  0.0000\)}}6 ??v0.0000\)̙)_(@_)    }A}7 }0.0000\))_(@_) }A}8 e0.0000\))_(@_) }}9 0.0000\))_(@_)    }}: ???0.0000\))_(@_) ??? ??? ??? ???}-}; 0.0000\)}-}< 0.0000\)}U}= 0.0000\))_(@_)  }-}> 0.0000\)}-}? 0.0000\)}}@ 0.0000\))_(@_)    }-}A 0.0000\)}-}B 0.0000\)}-}C 0.0000\)}-}D 0.0000\)}-}E 0.0000\)}-}F 0.0000\)}-}G 0.0000\)}-}H 0.0000\)}-}I 0.0000\)}-}J 0.0000\)}-}K 0.0000\)}-}L 0.0000\)}-}M 0.0000\)}-}N 0.0000\)}A}O 0.0000\))_(@_) }A}P 0.0000\))_(@_) }-}Q 0.0000\)}-}R 0.0000\)}-}S 0.0000\)}A}T 0.0000\))_(@_) }-}U 0.0000\)}A}V 0.0000\)4)_(@_) }A}W 0.0000\)4)_(@_) }A}X 0.0000\)4)_(@_) }A}Y 0.0000\)4)_(@_) }A}Z 0.0000\)4)_(@_) }A}[ 0.0000\)4)_(@_) }A}\ 0.0000\)4)_(@_) }-}] 0.0000\)}A}^ 0.0000\))_(@_) }-}_ 0.0000\)}A}` 0.0000\))_(@_) }A}a 0.0000\))_(@_) }A}b 0.0000\))_(@_) }A}c 0.0000\))_(@_) }A}d 0.0000\))_(@_) }-}f 0.0000\)}-}g 0.0000\)}A}h 0.0000\))_(@_) }A}i 0.0000\))_(@_) }A}j 0.0000\))_(@_) }A}k 0.0000\))_(@_) }A}l 0.0000\))_(@_) }-}m 0.0000\)}-}n 0.0000\)}-}o 0.0000\)}-}p 0.0000\)}-}q 0.0000\)}-}r 0.0000\)}-}s 0.0000\)}-}t 0.0000\)}A}u 0.0000\))_(@_) }-}v 0.0000\)}A}w 0.0000\)4)_(@_) }A}x 0.0000\))_(@_) }A}y 0.0000\))_(@_) }A}z 0.0000\))_(@_) }A}{ 0.0000\))_(@_) }A}| 0.0000\))_(@_) }-}} 0.0000\)}-}~ 0.0000\)}A} 0.0000\))_(@_) }-} 0.0000\)}-} 0.0000\)}-} 0.0000\)}-} 0.0000\)}-} 0.0000\)}-} 0.0000\)}A} 0.0000\))_(@_) }A} 0.0000\))_(@_) }-} 0.0000\)}-} 0.0000\)}A} 0.0000\))_(@_) }A} 0.0000\))_(@_) }A} 0.0000\))_(@_) }(}  0.0000\)}(}  0.0000\)}A} 0.0000\))_(@_) }A} 0.0000\))_(@_) }A} 0.0000\))_(@_) }-} 0.0000\)}-} 0.0000\)}-} 0.0000\)}-} 0.0000\)}-} 0.0000\)}-} 0.0000\)}A} 0.0000\))_(@_) }A} 0.0000\))_(@_) }A} 0.0000\))_(@_) }A} 0.0000\))_(@_) }A} 0.0000\))_(@_) }A} 0.0000\))_(@_) }-} 0.0000\)}A} 0.0000\))_(@_) }A} 0.0000\))_(@_) }A} 0.0000\))_(@_) }A} 0.0000\))_(@_) }A} 0.0000\))_(@_) }A} 0.0000\))_(@_) }-} 0.0000\) 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 % 0Good;Good  a%1 Heading 1G Heading 1 I}%O2 Heading 2G Heading 2 I}%?3 Heading 3G Heading 3 I}%234 Heading 49 Heading 4 I}%54 Hyperlink   6InputuInput ̙ ??v% 7 Linked CellK Linked Cell }% 8NeutralANeutral  e%3Normal % 9Noteb Note   :OutputwOutput  ???%????????? ???;$Percent <Title1Title I}% =TotalMTotal %OO> Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight16`w Information6Invoice SQL Cache Sample ValuesC5Devl32ProductsOfficeConnectorOfficeConnector.xlaSheet1    CustomerID:  DrawNumber: DueDate: ExtraID: Header:! InvoiceDate: # InvoiceNumber: JobID: ' qryARCustomer; + qryBLStandarditem; # qryJCJob1; $sqlContactInfo:%sqlCustomerInfo: sqlJobInfo:TaxGroup:( ToAddress1:  ToAddress2: ToName: ! TotalAmount:' TSFindTSImportTSKeyStrTSLookupgbZ 3 A@@  '{ DescriptionAmountUnits Unit Cost Template NamePurposeUsing This TemplateAbout the DesignJob IDNumberDateItem#UOMTOTALExtra ID03-009Phone:Fax:Contact:TSImportJobs Job Address Billed ToCustomerOHSU CustomersCode00010053BItemsDrawDue DateINVOICEAR Invoice Form.xltThis template provides a sample AR invoice form that can be filled in, printed and then used to create an import file for entry into Accounts Receivable. This template uses Office Connector Query to provide lists for Customer, Job, Standard Items.Hidden column O contains TSImport functions that serve as instructions to place information into the import file. The TSImport functions in cells O3, O10 and O11 write information to the Invoice record. The TSImport functions adjacent to the item grid write information to Distribution records. These TSImport functions refer to the TSImport in cell O3 as the parent reference which ties the items to the parent invoice. Hidden columns Q, R and S provide lists for Job, Cost Code, and Standard Item. Requirements Event 1 Import Tools  Event 1 Office Connector Query. Sage Timberline Office - Accounts ReceivablesqlCustomerInfosqlContactInfo sqlJobInfo"L""""Null""F"4"COMPANY_INFORMATION,CWEBADDRCOMPANY_WEB_ADDRESS,,0""String""COMPANY_INFORMATION,CEMAIL,,0""COMPANY_INFORMATION,CFAX,,0""COMPANY_INFORMATION,CPHONE,,0""COMPANY_INFORMATION,CCITY,,0""COMPANY_INFORMATION,CSTATE,,0""COMPANY_INFORMATION,CZIP,,0""COMPANY_INFORMATION,CADDR2,,0""COMPANY_INFORMATION,CADDR1,,0""COMPANY_INFORMATION,CNAME,,0"""STANDARD_BLS_RECORD_4,IDESC,"""""!"STANDARD_BLS_RECORD_4,IUOM,"""""$"STANDARD_BLS_RECORD_4,IUPRICE,"""""x"SELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 ,CADD1,"""""x"SELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 ,CNAME,"""""x"SELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 ,CADD2,"""""x"SELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 ,CCITY,"""""y"SELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 ,CSTATE,"""""w"SELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 ,CZIP,"""""y"SELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 ,CPHONE,"""""w"SELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 ,CFAX,"""""y"SELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 ,CCONT1,"""""E"SELECT COCONT, CONAME FROM STANDARD_ARS_RECORD_1,CONAME,""""""SELECT JOB, JDESC, JADDR1, JADDR2, JCITY, JSTATE, JZIP, JPRJMGR, JSPHN FROM MASTER_JCM_RECORD_1_1 WHERE JSTATUS<>'Closed',JSPHN,""""""SELECT JOB, JDESC, JADDR1, JADDR2, JCITY, JSTATE, JZIP, JPRJMGR, JSPHN FROM MASTER_JCM_RECORD_1_1 WHERE JSTATUS<>'Closed',JPRJMGR,""""""SELECT JOB, JDESC, JADDR1, JADDR2, JCITY, JSTATE, JZIP, JPRJMGR, JSPHN FROM MASTER_JCM_RECORD_1_1 WHERE JSTATUS<>'Closed',JZIP,""""""SELECT JOB, JDESC, JADDR1, JADDR2, JCITY, JSTATE, JZIP, JPRJMGR, JSPHN FROM MASTER_JCM_RECORD_1_1 WHERE JSTATUS<>'Closed',JSTATE,""""""SELECT JOB, JDESC, JADDR1, JADDR2, JCITY, JSTATE, JZIP, JPRJMGR, JSPHN FROM MASTER_JCM_RECORD_1_1 WHERE JSTATUS<>'Closed',JCITY,""""""SELECT JOB, JDESC, JADDR1, JADDR2, JCITY, JSTATE, JZIP, JPRJMGR, JSPHN FROM MASTER_JCM_RECORD_1_1 WHERE JSTATUS<>'Closed',JADDR2,""""""SELECT JOB, JDESC, JADDR1, JADDR2, JCITY, JSTATE, JZIP, JPRJMGR, JSPHN FROM MASTER_JCM_RECORD_1_1 WHERE JSTATUS<>'Closed',JADDR1,""""""SELECT JOB, JDESC, JADDR1, JADDR2, JCITY, JSTATE, JZIP, JPRJMGR, JSPHN FROM MASTER_JCM_RECORD_1_1 WHERE JSTATUS<>'Closed',JDESC,""""" Draw NumberJobExtra Item CodebTo try this template using the "Construction Sample Data", you can try using the following values:18192 1. Enter values into each of the yellow-shaded cells to complete the data entry of the purchase order information. Use the group button in the left margin ([-] or [+]) to show or hide the header information as you enter item details. 2. Click Save Import Files on the ImportTools toolbar. 3. Provide a name for the import file and and click Save. 4. Follow the steps documented in Accounts Receivable's help to import the file into Accounts Receivable. Not sure where to start? Use the "Construction Sample Data" provided with your Sage Timberline Office software then click on the "Sample Values" worksheet to see values you might try using.Y]Invoice DetailsDistribution DetailsLine 1Line 2Lists"Blank" Tax GroupTaxPercentMETSUBTOTAL|"SELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 ,CNAME,""OHSU"""|"SELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 ,CADD1,""OHSU"""|"SELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 ,CADD2,""OHSU"""|"SELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 ,CCITY,""OHSU"""}"SELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 ,CPHONE,""OHSU"""{"SELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 ,CFAX,""OHSU"""}"SELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 ,CCONT1,""OHSU"""&"STANDARD_BLS_RECORD_4,IDESC,""0001"""'"STANDARD_BLS_RECORD_4,IDESC,""0053B"""}"SELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 ,CSTATE,""OHSU"""{"SELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 ,CZIP,""OHSU""""SELECT JOB, JDESC, JADDR1, JADDR2, JCITY, JSTATE, JZIP, JPRJMGR, JSPHN FROM MASTER_JCM_RECORD_1_1 WHERE JSTATUS<>'Closed',JDESC,""03-009""""SELECT JOB, JDESC, JADDR1, JADDR2, JCITY, JSTATE, JZIP, JPRJMGR, JSPHN FROM MASTER_JCM_RECORD_1_1 WHERE JSTATUS<>'Closed',JADDR1,""03-009""""SELECT JOB, JDESC, JADDR1, JADDR2, JCITY, JSTATE, JZIP, JPRJMGR, JSPHN FROM MASTER_JCM_RECORD_1_1 WHERE JSTATUS<>'Closed',JADDR2,""03-009""""SELECT JOB, JDESC, JADDR1, JADDR2, JCITY, JSTATE, JZIP, JPRJMGR, JSPHN FROM MASTER_JCM_RECORD_1_1 WHERE JSTATUS<>'Closed',JCITY,""03-009""""SELECT JOB, JDESC, JADDR1, JADDR2, JCITY, JSTATE, JZIP, JPRJMGR, JSPHN FROM MASTER_JCM_RECORD_1_1 WHERE JSTATUS<>'Closed',JPRJMGR,""03-009""""SELECT JOB, JDESC, JADDR1, JADDR2, JCITY, JSTATE, JZIP, JPRJMGR, JSPHN FROM MASTER_JCM_RECORD_1_1 WHERE JSTATUS<>'Closed',JSPHN,""03-009"""%"STANDARD_BLS_RECORD_4,IUOM,""0001"""&"STANDARD_BLS_RECORD_4,IUOM,""0053B"""#"MASTER_TXM_RECORD_2,GRATE,""MET"""("STANDARD_BLS_RECORD_4,IUPRICE,""0001""")"STANDARD_BLS_RECORD_4,IUPRICE,""0053B""""SELECT JOB, JDESC, JADDR1, JADDR2, JCITY, JSTATE, JZIP, JPRJMGR, JSPHN FROM MASTER_JCM_RECORD_1_1 WHERE JSTATUS<>'Closed',JSTATE,""03-009""""SELECT JOB, JDESC, JADDR1, JADDR2, JCITY, JSTATE, JZIP, JPRJMGR, JSPHN FROM MASTER_JCM_RECORD_1_1 WHERE JSTATUS<>'Closed',JZIP,""03-009""" "MASTER_TXM_RECORD_2,GRATE,"""""%V VzV(WkWR![[\}^zba fiHj/Sm:psccvjv@ Connection3Invoice!qryBLStandarditemvev@ ConnectionInvoice!qryARCustomervbv@ Connection1Invoice!qryJCJob1B  #{G  dMbP?_*+%,sp&L&"-,Bold"&10Event 1 Import Tools for Sage Timberline Office&C&"-,Bold"&14AR Invoice Form &10Information&R&D &T&L&Z&F&RPage &P of &N&ffffff?'ffffff?(?)?MEpson LQ-25504C odLetterDINU"4&"[ZZ333333?333333?&<3U} } A} } C#,,,,,, , , ,@ ,,,,,,,,,,,,,,,,,, , @ ?! @ v"vvv @$ B% e& f' @ vV vvvvvvvvvvv @ v#vvvvvv v<   !,",!v"v< PH 0(  >@d" wksInformationggD  +~H  dMbP?_*+%;&L&Z&F&RPage &P of &N&?'?(?)?MEpson LQ-25504C odZZLetterDINU"4&"CZZ333333?333333?&<3U} I C} $ C} $ C}  C} $ C} $ C} $ C} $ V} $ X}  X}  X} $ C+ ;;;;;;;A J  J ; ; ; ;;;;J J;;NXQXQXQXQXQXQXQXQXQXQXQA} +#COMPANY_INFORMATIONCNAMEB}}}}} _ B~,#COMPANY_INFORMATIONCADDR1B~~~~~ WB~,#COMPANY_INFORMATIONCADDR2B~~~~~  z z  z  zV q# ARInvoiceInvoice###"Draw# InvoiceDate#DueDate#Amount#B ~#COMPANY_INFORMATIONCCITYB@, @@#COMPANY_INFORMATIONCSTATEB@@ @@#COMPANY_INFORMATIONCZIPB@~~~~~ {{{{ V~@Phone: @#COMPANY_INFORMATIONCPHONEB@~~~~~  z  z  z zR~<Fax: @#COMPANY_INFORMATIONCFAXB@~~~~~ |{|{ V~@Email: @#COMPANY_INFORMATIONCEMAILB@~~~~~[E#COMPANY_INFORMATIONCWEBADDRCOMPANY_WEB_ADDRESSBBg w[ ww Y Y Y     T= '## CNAME#B@@  T=  '##JDESC#B@@  `=  '## CADD1#B@@ `>  (##JADDR1#B@@ [[ G=  '## CADD2#B@@  T>  (##JADDR2#B@@ [[ G=  '## CCITY#B@@ > E&(## CSTATE#B@@< F &## CZIP#B@@ `=  '##JCITY#B@@ > D& (##JSTATE#B@@< K &##JZIP#B@@ [[G ]> (## CPHONE#B@@GUUEDK [[G ]<&## CFAX#B@@G ]?  )##JPRJMGR#B@@  [[G ]aK## CONAME## CCONT1#B@@B@@G ]=  '##JSPHN#B@@  [[ HIIIIJHIIILM [\[[ O ^  P  P  P   VZ[XX~ S?aP:#STANDARD_BLS_RECORD_4IDESC$B@@~ br@O c 9#STANDARD_BLS_RECORD_4IUOM$B@@F b( 0#STANDARD_BLS_RECORD_4IUPRICE$B! x DD  yV#D  ARInvoice "# Distribution$JCJob#JCExtra#Units$Amount$ AccountingDate#TaxGroup#B[[XXS@ DaP:#STANDARD_BLS_RECORD_4IDESC$B@@~ b@O c 9#STANDARD_BLS_RECORD_4IUOM$B@@F b 0#STANDARD_BLS_RECORD_4IUPRICE$B! x DD  yV#D  ARInvoice "# Distribution$JCJob#JCExtra#Units$Amount$ AccountingDate#TaxGroup#B[[XXS@ DaP:#STANDARD_BLS_RECORD_4IDESC$B@@~ bO c 9#STANDARD_BLS_RECORD_4IUOM$B@@F b 0#STANDARD_BLS_RECORD_4IUPRICE$B! x DD  yV#D  ARInvoice "# Distribution$JCJob#JCExtra#Units$Amount$ AccountingDate#TaxGroup#B[[XXS@ DaP:#STANDARD_BLS_RECORD_4IDESC$B@@~ bO c 9#STANDARD_BLS_RECORD_4IUOM$B@@F b 0#STANDARD_BLS_RECORD_4IUPRICE$B! x DD  yV#D  ARInvoice "# Distribution$JCJob#JCExtra#Units$Amount$ AccountingDate#TaxGroup#B[[XXS@ DaP:#STANDARD_BLS_RECORD_4IDESC$B@@~ bO c 9#STANDARD_BLS_RECORD_4IUOM$B@@F b 0#STANDARD_BLS_RECORD_4IUPRICE$B! x DD  yV#D  ARInvoice "# Distribution$JCJob#JCExtra#Units$Amount$ AccountingDate#TaxGroup#B[[XXS@ DaP:#STANDARD_BLS_RECORD_4IDESC$B@@~ bO c 9#STANDARD_BLS_RECORD_4IUOM$B@@F b 0#STANDARD_BLS_RECORD_4IUPRICE$B! x DD  yV#D  ARInvoice "# Distribution$JCJob#JCExtra#Units$Amount$ AccountingDate#TaxGroup#B[\XXS@ DaP:#STANDARD_BLS_RECORD_4IDESC$B@@~ bO c 9#STANDARD_BLS_RECORD_4IUOM$B@@F b 0#STANDARD_BLS_RECORD_4IUPRICE$B! x DD  yV#D  ARInvoice "# Distribution$JCJob#JCExtra#Units$Amount$ AccountingDate#TaxGroup#B[\XXS @ DaP:#STANDARD_BLS_RECORD_4IDESC$B@@~ bO c 9#STANDARD_BLS_RECORD_4IUOM$B@@F b 0#STANDARD_BLS_RECORD_4IUPRICE$B! x DD  yV#D  ARInvoice "# Distribution$JCJob#JCExtra#Units$Amount$ AccountingDate#TaxGroup#B[\XXS"@ DaP!:#STANDARD_BLS_RECORD_4IDESC$B@@~ bO c! 9#STANDARD_BLS_RECORD_4IUOM$B@@F b! 0#STANDARD_BLS_RECORD_4IUPRICE$B! x! DD  yV!#D  ARInvoice "# Distribution$JCJob#JCExtra#Units$Amount$ AccountingDate#TaxGroup#B[XXXS$@ DaP!:#STANDARD_BLS_RECORD_4IDESC$B@@~ bO c! 9#STANDARD_BLS_RECORD_4IUOM$B@@F b! 0#STANDARD_BLS_RECORD_4IUPRICE$B! x! DD  yV!#D  ARInvoice "# Distribution$JCJob#JCExtra#Units$Amount$ AccountingDate#TaxGroup#B[XXXS&@ DaP!:#STANDARD_BLS_RECORD_4IDESC$B@@~ bO c! 9#STANDARD_BLS_RECORD_4IUOM$B@@F b! 0#STANDARD_BLS_RECORD_4IUPRICE$B! x! DD  yV! #D  ARInvoice "# Distribution$JCJob#JCExtra#Units$Amount$ AccountingDate#TaxGroup#B[XXXD'lgh|n*F2 -BBBBBBBBB XQ!XQ"XQ#XQ$XQ%XQ&XR 'wR(;R)@ *@  S(@! D aP !:#STANDARD_BLS_RECORD_4IDESC$ B@@ ~ bO c! 9#STANDARD_BLS_RECORD_4IUOM$ B@@F b! 0#STANDARD_BLS_RECORD_4IUPRICE$ B! x!! D D  y V!!#D  ARInvoice "# Distribution$ JCJob#JCExtra#Units$ Amount$ AccountingDate#TaxGroup#B [XXX!S*@" D !aP!! :#STANDARD_BLS_RECORD_4IDESC$!B@@!~ !bO! c! 9#STANDARD_BLS_RECORD_4IUOM$!B@@F! b! 0#STANDARD_BLS_RECORD_4IUPRICE$!B!! x!" D!D! ! y!V!"#D!  ARInvoice "# Distribution$!JCJob#JCExtra#Units$!Amount$! AccountingDate#TaxGroup#B![XXX"S,@# D!"aP"!!:#STANDARD_BLS_RECORD_4IDESC$"B@@"~ "bO" c!! 9#STANDARD_BLS_RECORD_4IUOM$"B@@F" b!! 0#STANDARD_BLS_RECORD_4IUPRICE$"B!" x!# D"D" " y"V!##D"  ARInvoice "# Distribution$"JCJob#JCExtra#Units$"Amount$" AccountingDate#TaxGroup#B"[XXX#S.@$ D"#aP#!":#STANDARD_BLS_RECORD_4IDESC$#B@@#~ #bO# c!" 9#STANDARD_BLS_RECORD_4IUOM$#B@@F# b!" 0#STANDARD_BLS_RECORD_4IUPRICE$#B!# x!$ D#D# # y#V!$#D#  ARInvoice "# Distribution$#JCJob#JCExtra#Units$#Amount$# AccountingDate#TaxGroup#B#[XXX$S0@% D#$dP$!#:#STANDARD_BLS_RECORD_4IDESC$$B@@$~ $bO$ c!# 9#STANDARD_BLS_RECORD_4IUOM$$B@@F$ b!# 0#STANDARD_BLS_RECORD_4IUPRICE$$B!$ x!% D$D$ $ y$V!%#D$  ARInvoice "# Distribution$$JCJob#JCExtra#Units$$Amount$$ AccountingDate#TaxGroup#B$[XXX%S1@& D$%dP%!$:#STANDARD_BLS_RECORD_4IDESC$%B@@%~ %bO% c!$ 9#STANDARD_BLS_RECORD_4IUOM$%B@@F% b!$ 0#STANDARD_BLS_RECORD_4IUPRICE$%B!% x!& D%D% % y%V!&#D%  ARInvoice "# Distribution$%JCJob#JCExtra#Units$%Amount$% AccountingDate#TaxGroup#B%[XXX&2@ D%&P&!%:#STANDARD_BLS_RECORD_4IDESC$&B@@&~ &O& !% 9#STANDARD_BLS_RECORD_4IUOM$&B@@F& !% 0#STANDARD_BLS_RECORD_4IUPRICE$&B!& ! D&D& & &V!' #D&  ARInvoice "# Distribution$&JCJob#JCExtra#Units$&Amount$& AccountingDate#TaxGroup#B&\XXX' 'a' #' !( %& L' 'V\XXX( (] (u (_F( !& 0#MASTER_TXM_RECORD_2GRATE$(Bd ( ^)( !* %& 3D( ( (V\XXX * * !* ! D' D( * WBBBBBBB{  *PH0(  >@<dA   bL(( ((** '' ''       %% && ** "" ##  !! $$               !!    $$%%&& ##""       qryBLStandarditem KHSELECT "ITEM" AS "Standard item" FROM "STANDARD_BLS_RECORD_4"DSN=E1 Timberline Gold Data;UID=E1;;DBQ=D:\TSDATA\BLANK;CODEPAGE=1252;MaxColSupport=255;DictionaryMode=1;MaxColSupport=255;Short enNames=0;&qryBLStandarditem1;,    Standard item qryARCustomerd EBSELECT "CUST" AS "Customer" FROM "MASTER_ARM_RECORD_1"DSN=E1 Timberline Gold Data;UID=E1;;DBQ=D:\TSDATA\BLANK;CODEPAGE=1252;MaxColSupport=255;DictionaryMode=1;MaxColSupport=255;Short enNames=0;" qryARCustomerID,  Customer qryJCJob1to a^SELECT "JOB" AS "Job" FROM "MASTER_JCM_RECORD_1_1" WHERE "JSTATUS"<>'Closed'DSN=E1 Timberline Gold Data;UID=E1;;DBQ=D:\TSDATA\BLANK;CODEPAGE=1252;MaxColSupport=255;DictionaryMode=1;MaxColSupport=255;Short enNames=0; qryJCJob1ta,  Job i Units.Enter a numeric value for the number of units. 2;d rtdA&p Unit of Measure7Enter a unit of measure up to six characters in length.d& s  Unit Cost4Enter a numeric value for the unit cost of the item. led dA& } Amount1Enter a numeric value for the amount of the item. teRd dRdA%& # &  Item DescriptionEEnter a description for the line item up to 300 characters in length.  ,&~ Item DescriptionEEnter a description for the line item up to 300 characters in length. # ,&+ pt# E + pt# E TInvoice NumberEnter a valid Invoice Numberliem _ Due Date'Enter a valid due date for the invoice.o @ I Extra IDEnter a valid Extra ID.r nv  N Draw NumberEnter a valid draw number  W Date#Enter a valid date for the invoice.o @  wksInvoiceggD   X  dMbP?_*+%,&ffffff?'ffffff?(?)?",333333?333333?li&<3U} h} $ch} $ h ,,, k(i nkSELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 nkSELECT CUST, CNAME, CADD1, CADD2, CCITY, CSTATE, CZIP, CPHONE, CFAX, CCONT1 FROM MASTER_ARM_RECORD_1 k)Pj1 :7SELECT COCONT, CONAME FROM STANDARD_ARS_RECORD_1:7SELECT COCONT, CONAME FROM STANDARD_ARS_RECORD_1 k*jU SELECT JOB, JDESC, JADDR1, JADDR2, JCITY, JSTATE, JZIP, JPRJMGR, JSPHN FROM MASTER_JCM_RECORD_1_1 WHERE JSTATUS<>'Closed'SELECT JOB, JDESC, JADDR1, JADDR2, JCITY, JSTATE, JZIP, JPRJMGR, JSPHN FROM MASTER_JCM_RECORD_1_1 WHERE JSTATUS<>'Closed'\d  LEC>@   wksSQLggD  8  dMbP?_*+%,&ffffff?'ffffff?(?)?",333333?333333?DR&<3U8,,,,,,,,, , D D D DD ,,,D,,, . 9 \ 0 . 8 , 0 . 7 , 0 . 4 , 0 . 5 , 0 . 6 , 0 . 3 , 0 . 2 , 0 . 1 , 0 . / , 0 + gb , - + gc , - + gd , - + ge , - + gf , - + gg , - + gh , - + gF , - + i , - + j , - + : , - + gk , - + gl , - + gm , - + gn , - + go , - + gp , - + gq , - + gr , - + s , - + t , - + ; , -D l8888888888888888888888888888888 ,!,",#,$%&'()*+,-./01234567, + u , - !+ !v !, !- "+ "w ", "- #+ #< #, #- $+ $gx $, $- %+ %gy %, %- &+ &gB &, &- '+ 'gA ', '- (+ (gE (, (- )+ )gD ), )- *+ *gC *, *- ++ +g@ +, +- ,+ ,g? ,, ,- -+ -g= -, -- .+ .g> ., .- /+ /gI /, /- 0+ 0gJ 0, 0- 1+ 1gG 1, 1- 2+ 2gH 2, 2- 3+ 3gK 3, 3- 4+ 4gL 4, 4- 5+ 5gM 5, 5- 6+ 6gN 6, 6- 7+ 7z 7, 7-4 88888888888888888888888>@ wksCacheggD  |  dMbP?_*+%,&L&"-,Bold"&10Event 1 Import Tools for Sage Timberline Office&C&"-,Bold"&14AR Invoice Form&"-,Regular"&11 &"-,Bold"Sample Values&R&"-,Bold"&10&D &T&L&Z&F&RPage &P of &N&ffffff?'ffffff?(?)?MEpson LQ-25504C odhhLetterDINU"4&"dhh333333?333333?&<3U} $} m} I m  @ w , , , , ,  ,  ,  ,  w , ,,,,,, S rW lO nT l nU l ~ o@ l~ o`@ l p lP n lQ n l] p` tX ?Y lR n l~ pr@ sq ?Z lR p l~ p@( T&>@qr wksSampleValuesggD  Oh+'0$ `h   AR Invoice FormEvent 1 Import ToolsEvent 1 Software, Inc.This template provides a sample AR invoice form that can be filled in, printed and then used to create an import file for entry into Accounts Receivable. This template uses Office Connector Query to provide lists for Customer, Job, Standard Items.Michael R. NewlandMicrosoft Excel@gV@\#@SV՜.+,D՜.+,T PXt | Event 1 Software  InformationInvoiceSQLSample Values CustomerID DrawNumberDueDateExtraIDHeader InvoiceDateInvoiceNumberJobIDInvoice!qryARCustomerInvoice!qryBLStandarditemInvoice!qryJCJob1sqlContactInfosqlCustomerInfo sqlJobInfo TaxGroup ToAddress1 ToAddress2ToName TotalAmount  Worksheets Named Ranges0TimberlineDataFolderPersistentCacheIgnoreMissingTablesPrompt2-1CompObjr F&Microsoft Office Excel 2003 WorksheetBiff8Excel.Sheet.89q