Ivoice for Irrigation Meter-Trump PlatIPM.Note
Ivoice for Irrigation Meter-Trump Plat
Steve Harrington
EX
/O=CITYOFYELM/OU=FIRST ADMINISTRATIVE GROUP/CN=RECIPIENTS/CN=STEVEH
Ivoice for Irrigation Meter-Trump Plat
Steve Harrington
EX
/O=CITYOFYELM/OU=FIRST ADMINISTRATIVE GROUP/CN=RECIPIENTS/CN=STEVEH
Roberta Allen
Ivoice for Irrigation Meter-Trump Plat
00000002SERVER1/o=CITYOFYELM/ou=first administrative group/cn=Recipients/cn=stevehMicrosoft Exchange Server
00000002SERVER1/o=CITYOFYELM/ou=first administrative group/cn=Recipients/cn=stevehMicrosoft Exchange Server
I will try this again. Gretchen said I needed to add the location. I added it. Disregard the first one.
Thanks,
Steve Harrington
Engineering / Civil Inspector
City of Yelm
Office (360) 458-8423 / Field (360) 561-4264
<DC90029353CCCD468AA2A2858FFCD8F554E168@server1.ci.yelm.wa.us>
Ivoice for Irrigation Meter-Trump Plat.EML
Steve Harrington
Steve Harrington
11.0
Microsoft Exchange Server
00000002SERVER1/o=CITYOFYELM/ou=first administrative group/cn=Recipients/cn=steveh
invoice SUB-05-0456-YL - Scott Ritter
invoice SUB-05-0456-YL - Scott Ritter
Roberta Allen
EX
/O=CITYOFYELM/OU=FIRST ADMINISTRATIVE GROUP/CN=RECIPIENTS/CN=R_allen
r_allen@ci.yelm.wa.us
r_allen
458-3835
Community Development
Roberta Allen
Roberta Allen
r_allen
invoice SUB-05-0456-YL - Scott Ritter.xls
TemplateInformation
Intl Data Table
Lock
ATW
Macros
Invoice
Customize Your Invoice
AutoOpen Stub Data
__IntlFixupTable
boxes
button_area_1
CC
CCT
CDB
celltips_area
ChangeFont
CS
Customize
data1
data10
data11
data12
data13
data14
data15
data16
data17
data18
data19
data2
data20
data21
data22
data23
data24
data25
data26
data27
data28
data29
data3
data30
data31
data32
data33
data34
data35
data36
data37
data38
data39
data4
data40
data41
data42
data43
data44
data45
data46
data47
data48
data49
data5
data50
data51
data52
data53
data54
data55
data56
data57
data58
data59
data6
data60
data61
data62
data63
data64
data65
data66
data67
data68
data69
data7
data70
data8
data9
dflt1
dflt2
dflt3
dflt4
dflt5
dflt6
dflt7
display_area_1
display_area_2
InsertLogo
INV_Payments
LOC
LockSheet
LTR
Nada
NO
NS
qzqzqz10
qzqzqz11
qzqzqz12
qzqzqz13
qzqzqz14
qzqzqz15
qzqzqz16
qzqzqz17
qzqzqz18
qzqzqz19
qzqzqz20
qzqzqz21
qzqzqz22
qzqzqz23
qzqzqz24
qzqzqz25
qzqzqz26
qzqzqz27
qzqzqz28
qzqzqz29
qzqzqz30
qzqzqz31
qzqzqz32
qzqzqz6
qzqzqz7
qzqzqz8
qzqzqz9
SHR1
SHR2
SS
tax1
tax2
tax3
tax4
TOT
vital1
vital2
vital4
vital5
vital6
vital8
vital9
CUSTOMIZE YOUR INVOICE
Hover Your Pointer
HERE for a Useful Tip!
Type Company Information Here...
Company Name
Phone
Address
Fax
City
City
State
State
ZIP Code
Specify Default Invoice Information Here...
Credit Cards Accepted
1st Tax Name
Rate
Apply tax on local purchases only.
2nd Tax Name
Shipping Charge
Share invoice numbers on network.
Counter Location
Template Wizard Database
Formatted Information
Invoice
Invoice No.
Name
Date
Address
Order No.
ZIP
Rep
Phone
FOB
Description
Unit Price
TOTAL
SubTotal
Shipping & Handling
Cash
Taxes
Check
TOTAL
Office Use Only
US
UK
Canada
Australia
New Zealand
Ireland
Arabic Countries
Austria
Belgium
Brazil
China
Denmark
France
Germany
Hungary
Israel
Italy
Japan
Korea
Luxembourg
Netherlands
Norway
Portugal
South Africa
Spain
Sweden
Switzerland
Taiwan
Turkey
Venezuela
Sheet Name
Cell Address
Action Code
Customize Your Invoice
E22
VAT
GST
WST
MwSt.
BTW
ICMS
Moms
T.V.A.
ÁFA
IVA
Mva.
I.V.A.
I.G.
E23
E26
PST
IPI
E27
G27
$#,##0.00_);("$"#,##0.00)
£#,##0.00_);("£"#,##0.00)
IR£#,##0.00_);("IR£"#,##0.00)
#,##0.00_);(#,##0.00)
ÖS #.##0,00_);("ÖS "#.##0,00)
BF #.##0,00_);("BF "#.##0,00)
R$ #.##0,00_);("R$ "#.##0,00)
kr #.##0,00_);("kr "#.##0,00)
#.##0,00 "DM"_);(#.##0,00 "DM")
#.##0,00 "Ft"_);(#.##0,00 "Ft")
#,##0.00_D_M_);(#,##0.00_D_M)
L. #.##0,00_);("L. "#.##0,00)
¥#,##0.00_);("¥"#,##0.00)
#.##0,00 "F"_);(#.##0,00 "F")
fl #.##0,00_);("fl "#.##0,00)
kr # ##0,00_);("kr "# ##0,00)
#.##0,00 "PTE"_);(#.##0,00 "PTE")
R #,##0.00_);("R "#,##0.00)
#.##0,00 "Pts"_);(#.##0,00 "Pts")
# ##0,00 "kr"_);(# ##0,00 "kr")
SFr. #'##0.00_);("SFr. "#'##0.00)
NT$#,##0.00;(NT$#,##0.00)
#.##0,00 "TL"_);(#.##0,00 "TL")
Bs #.##0,00_);("Bs "#.##0,00)
K18:L34
L35:L39
A1
AutoTemplateWizardDONTMESSWITHIT
Database Type:
Excel 5.0
Database Location:
Reserved
Number of Tables:
Table Name:
Table1
Number of Fields:
Field Name:
Invoice Number
Invoice Date
Customer Name
Customer Address
Customer City
Customer State
Customer Zip
Customer Phone
Total Invoice
Refers To:
C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\LIBRARY\Invdb.xls
City of Yelm, Community Development Department
P.O. Box 479
Yelm
WA
98597
(360) 458-3835
City of Yelm
Community Development Department
Yelm, WA 98597
THANK YOU
(360) 458-3835
CDD-07-0262
Ritter Holding Company / Scott L. Ritter
2840 Crites Street S.W.
Tumwater
98512
12/27/07
SUB-05-0456-YL
Trump Plat
Irrigation Meter / 607 Trump Avenue
Page
1.00
1.00
10.00
894223103.00
CDD-07-0262
12/27/07
Ritter Holding Company / Scott L. Ritter
2840 Crites Street S.W.
Tumwater
WA
98512
0.00
$650.00
Trump Plat
Seite
-999.00
44.00
2.00
61.00
64.00
353.00
785.00
43.00
32.00
55.00
86.00
45.00
33.00
49.00
36.00
972.00
39.00
81.00
82.00
352.00
31.00
47.00
351.00
27.00
34.00
46.00
41.00
886.00
90.00
58.00
1.00
1.00
0.05
0.18
0.07
0.22
0.13
0.21
0.20
0.21
0.18
0.17
0.25
0.19
0.15
0.25
0.17
0.19
0.03
0.10
0.15
0.18
0.23
0.17
0.14
0.28
0.25
0.07
0.05
0.08
0.12
1.00
1.00
0.07
0.10
0.06
0.15
0.06
0.07
0.12
0.16
0.06
0.06
0.16
0.21
0.02
0.15
2.00
2.00
2.00
4.00
1.00
9.00
1.00
9.00
9.00
9.00
9.00
9.00
9.00
1.00
9.00
9.00
9.00
9.00
9.00
9.00
9.00
9.00
9.00
9.00
9.00
9.00
9.00
9.00
9.00
9.00
9.00
9.00
9.00
9.00
Page
Unlock This Sheet
By unlocking this sheet, you enable changes to be made to the information on the Customize sheet. Select "Lock This Sheet" after you make your changes to protect the sheet from accidental
changes.
OK
Cancel
Locking Options
Lock but don't save
Lock and save Template
Page
Create and Interact with Database
OK
Cancel
Database Options
Create a new Template Database
Update existing Database
This feature allows you to update the existing Template Wizard Database with values from this copy of the template.
If you would like to track different cell values, you can use the Template Wizard to 'Create a new Template Database' and specify the cell values you want to track.
sample1
Created by Village Software
sample2
Created by Village Software
sample3
Created by Village Software
1.00
$650.00
$650.00
$650.00
WA
2.00
$650.00
City of Yelm
Community Development Department
INVOICE
Payment Details
Customer
Customize...
If you have not entered a logo on the Customize Your Invoice sheet, this logo box will not appear on your printed invoices.
This is the location for the unique identifier for each invoice. If you would like to add a unique number to this invoice, click the Add a Number button on the Invoice toolbar. Remember,
if you want to generate sequential invoices from more than one computer on a network, go to the Customize Your Invoice sheet and choose that option.
Click this button to go back to the Customize Your Invoice sheet to change your customized information.
FOB stands for Freight On Board. It is the location from which freight is being charged. For example, if you ordered from a company in Indiana but the product was being shipped from
Boston, you would enter Boston here.
ENTERING PAYMENT DETAILS
Check off a payment method. If you choose Credit Card, select the type of credit card and enter the relevant information.
0.08
c:\program files\microsoft office\office\library\invdb.xls
1.00
0.00
Unlock This Sheet
City of Yelm, Community Development Department
P.O. Box 479
Yelm, WA 98597
(360) 458-3835 fax (360) 458-3835
Select Logo
Change Plate Font
CUSTOMIZING YOUR INVOICE
Use this sheet to enter all of your company information to be used by subsequent worksheets in this template. The template will format this information for you and place it on the Invoice
sheet. You can lock this sheet when you are finished with your customizations and save the template for future use.
LOCK/UNLOCK THIS SHEET
Click this button to prevent accidental changes to your customized information. It will change to an Unlock This Sheet button, which you can click should you wish to change this information
at a later time. When you lock the sheet, you can simply lock the sheet or you can choose to save your own version of this template with your customized information.
TIPS AND COMMENTS
Tips and comments are useful features in Microsoft Excel. ToolTips tell you about toolbars, and Comments tell you about actual cells on your sheet. You can even create your own personalized
Comments with the Document Cell button on your Toolbar.
ENTERING COMPANY INFORMATION
Entering information in these cells will update the Invoice lettertype boilerplate. Note that you are not required to fill in all the cells. Any cells that you leave blank will simply
not show up on the lettertype.
ENTERING DEFAULT INVOICE INFORMATION
Entering information in these cells will update the Invoice form automatically. You can change the information in these cells by deleting the old information and typing the new.
Check this option if your sales tax only applies to customers located in the same state in which you are located.
Invoice numbering is normally for your computer only. If you would like to generate sequential invoices from more than one computer on a network, check this box and specify a server
location in the Counter Location box. For more information about automatic numbering, click Template Help on the Invoice toolbar.
ENTERING FORMATTED INFORMATION
Use this area to customize the look of your invoices. Click on Select Logo to choose a graphic for your company logo. Click on Change Plate Font to change the font in the lettertype
boilerplate. The boilerplate changes will be automatically adjusted on all appropriate sheets.
.xls
INVOIC~1.XLS
invoice SUB-05-0456-YL - Scott Ritter.xls