Recipient Tax Invoice Template

1. New Zealand Tax Invoice Template

"New Zealand Tax Invoice Template" was found to be relative to Recipient Tax Invoice Template with the score grade of 96.

(From Detail Page - about 31 words) - To make your invoice legally compliant it must show certain information. This template, designed by InvoicingTemplate.com, meets the requirements by New Zealand Inland Revenue and is capable of tax (GST) calculation.

(From Detail Page - about 16 words) - According to New Zealand Inland Revenue, for a tax invoice to be valid it must have:

• the words "tax invoice" in a prominent place
• the name and registration number of the supplier
• the name and address of the recipient
• the date the tax invoice is being issued
• a description of the good and services supplied
• the quantity or volume of the goods and services supplied and either:
  1. the total amount of tax charged, the consideration excluding tax and the consideration inclusive of tax, or
  2. the consideration for the supply and a statement that includes the tax charge.

(From Detail Page - about 214 words) - GST, stands for Goods and Services Tax, is a value added tax, implemented in Canada, Hong Kong, India, Malaysia, New Zealand and Singapore etc. Goods and services tax (GST) is a tax on most goods and services in New Zealand, most imported goods, and certain imported services. GST is added to the price of taxable goods and services at a rate of 15%. GST in New Zealand is designed to be a broad based system with few exemptions. Exceptions that do exist include rents collected on residential rental properties, donations, precious metals and financial services. End-users pay this tax on all liable goods and services directly, in that the purchase price of goods and services includes GST. GST-registered organizations and individuals pay GST only on the difference between GST-liable sales and GST-liable supplies (i.e., they pay GST on the difference between what they sell and what they buy: income less expenditure). This is accomplished by reconciling GST received (through sales) and GST paid (through purchases) at regular periods (typically every two months, with some qualifying companies opting for one-month or six-month periods), then either paying the difference to the Inland Revenue (IRD) if the GST collected on sales is higher or receiving a refund from IRD if the GST paid on purchases is higher.

LEARN MORE PDF

2. Commercial Invoice - FedEx Style (Landscape)

"Commercial Invoice Format - FedEx Style (Landscape)" was found to be relative to Recipient Tax Invoice Template with the score grade of 86.

(From Detail Page - about 33 words) - This commercial invoicing sample was a customized version of "c9002 Commercial Invoice - FedEx Style". This form is still be printable on standard A4 paper, but the paper orientation is changed to landscape.

(From Detail Page - about 76 words) - While the template at c9002 Commercial Invoice - FedEx Style implemented the layout and fields as the FedEx sample, many of you may find that the space left for the product description field is too small to fill your description text. To deal with this issues, we change the paper orientation from "Portrait" to "Landscape". This design allows you to enter longer description text. However the form has only 7 lines on the detail section now.

(From Detail Page - about 105 words) - c9003 - Commercial Invoice - FedEx Style (Landscape) (Commercial Invoice Format - FedEx Style (Landscape)) is one of the templates in the serial Commercial Invoices (FedEx). As of Dec/26/2015, there are 5 template(s) in this serial. For the basic version of blank FedEx format commercial invoice sample, see Commercial Invoice - FedEx Style. For the version that includes payment method checkboxes, see Commercial Template Sample - Using Payment Method Checkboxes. For the version that includes complete Incoterms option, see Commercial Template Sample - Complete Incoterms Option. For the version that includes insurance and currency symbol options, see Commercial Template Sample - Adding Insurance Cost Field.

(From Detail Page - about 157 words) - In order to create this template, we've also moved the address fields on the "Shipper/Exporter", "Recipient" and "Importer (If other than recipient)" sections. The purpose of this movement is to make the sections occupy less lines on the vertical orientation. In the original design, each of the section occupy 8 lines for these fields - Tax ID/VAT No, Contact Name, Company Name, Address, City State/Province, Postal Code, Country/Territory, and Phone. Now each of the section uses only 4 lines. With this commercial invoice format design, the lines for "Federal Express International Air Waybill Number" still uses one whole line; "Date of Export" and "Export References" use another whole line. These fields are put on the top of the form because they are the most important cells, at least in the FedEx design. The PDF version of this blank commercial invoice template for shipping, which was created by using Excel's built in feature, has exactly the same layout.

LEARN MORE PDF

3. Shipping Invoice Template (1)

"Shipping Invoice Template (1)" was found to be relative to Recipient Tax Invoice Template with the score grade of 80.

(From Detail Page - about 34 words) - Shipping Invoice Template is also called freight invoice template. A shipping invoice is just like a commercial invoice which is used by business that deals in shipment of goods within or across the borders.

(From Detail Page - about 33 words) - Unlike the packing slip template, Shipping Invoice Template includes the "Unit Price" and the "Line Total" columns on the invoice body, whereas a packing list usually does not include this type of information.

...(11)...

(From Detail Page - about 76 words) - This sample free shipping invoice template designed by us at InvoicingTemplate.com has two editions - the first is the freeware edition, and the second is the Uniform Invoice Software edition which must be run with our Excel Invoicing Software installed. Uniform Invoice Software has the ability to turn a simple Excel invoice template a powerful invoicing system. For example, using this Shipping Invoice Template along with Uniform Invoice Software, it becomes your powerful Shipping Billing Software.

(From Detail Page - about 51 words) - To implement the sample shipping invoice template, Invoicing Templates added a number of custom fields to the default sales invoice template that comes with the setup program of Uniform Invoice Software, including: Bill of Loading No, Destination, Cont. Type, Vessel/ Vyoage, Port of Loading, No. Of Pkgs., Gross/Net weight, Ex. Rate.

(From Detail Page - about 134 words) - Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the invoice form. Shipping Invoice Template (1) uses custom fields to implement the features that are not available in the default sales invoice template. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, Uniform Invoice Software has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

...(110)...

(From Detail Page - about 92 words) - These new custom fields, combined with the default fields defined by the sales invoice template, make the billing template has the ability to detail shipping company, sender, recipient, description of the goods being shipped, total items shipped in one package, cost of shipment, date of shipment, name of the company which is the manufacturer of the goods, shipment code, etc. The shipping invoice sample also defines one tax, named "Service Tax", on the bottom of the form. You can easily change the tax name and tax rate by typing whatever you like.

(From Detail Page - about 33 words) - The shipping invoices created by this shipping invoice template is printable on standard A4 paper with Portrait paper orientation. If you would like to see a Landscape version, see Shipping Invoice Template (2).

LEARN MORE PDF

4. Australian GST Invoice Template

"Australian GST Billing Form" was found to be relative to Recipient Tax Invoice Template with the score grade of 78.

(From Detail Page - about 34 words) - Australian GST Invoice Template is a sample of customization of the default sales invoice template. Australian GST Invoice Template implements the invoice layout and form according to Australian Government / Australian Taxation Office requirements.

(From Detail Page - about 68 words) - Australian GST Invoice Template was designed according to the guidelines of Australian Taxation Office "How to set out tax invoices and invoices (NAT 11675)". While this is sample invoice template, like all the other blank invoice templates available here on InvoicingTemplate.com, is also created from the default sales invoice template shipped with Uniform Invoice Software, we've customize the template to meet the standards recommended by Australian Taxation Office.

(From Detail Page - about 109 words) - Why standardize the way tax invoices and invoices are set out? As Australian Taxation Office stated, the voluntary standards have been developed in consultation with small business, in response to feedback about their frustration with inconsistent tax invoice and invoice formats. The standards will help achieve greater consistency in the set out of tax invoices and invoices, making it easier for recipients to locate the necessary information for tax purposes. For more information about the specific requirements of a tax invoice, refer to Australian Taxation Office: Valid tax invoices and GST credits (NAT 12358), 'Section 03 - Issuing and obtaining tax invoices' in GST for small business (NAT 3014).

(From Detail Page - about 12 words) - As always Australian GST Invoice Template is offered in Excel spreadsheet format.

(From Detail Page - about 102 words) - Although it is easy to create the layout and format of Australian GST Invoice Template with Microsoft Word or other Microsoft Office programs, or even with some PDF programs, the support for Excel formulas makes doing automated calculations easy to implement and modify. For example, Australian GST Invoice Template uses Excel formulas extensively to do calculations whenever possible and necessary, such as the taxes, totals. If you use the Uniform Invoice Software version of Australian GST Invoice Template, Excel formulas are also used to create the relationship between several fields, such as one field should be the sum of two other fields.

...(72)...

• the identity of the supplier, such as the business name at the top
• the Australian business number (ABN) of the supplier at the top, near the supplier's identity
• the date of issue of the tax invoice at the top, on the right hand side
• that the document is intended as a tax invoice, such as including the words 'tax invoice' at the top
• an invoice number shown prominently alongside the words 'tax invoice'
• the purchaser's identity such as a name or ABN, for goods or services costing $1,000 or more
• a unit description of each good or service supplied, including quantities - it is optional to include item numbers, and
• the GST exclusive price, the GST amount and the GST inclusive price for each item, together with the totals for these, vertically in the bottom right hand corner.

(From Detail Page - about 29 words) - Australian GST Invoice Template includes seven columns on the invoice body - DESCRIPTION, ITEM No., PRICE (excl. GST), QTY, SUB TOTAL (excl. GST), GST AMOUNT, AMOUNT PAYABLE (incl. GST).

LEARN MORE PDF

5. Receipt Template for Gold Shop (1)

"Receipt Template for Gold Shop (1)" was found to be relative to Recipient Tax Invoice Template with the score grade of 63.

(From Detail Page - about 42 words) - Receipt Template for Gold Shop is a free blank receipt template and cash receipt template designed especially for gold shop. The template has a Rate field outside of printable receipt form, with which you can specify the current unit price of gold.

(From Detail Page - about 105 words) - The free receipt template does not include "Bill To" and "Ship To" section inside the printable receipt form. The two common sections that appear on almost all free invoice templates available here on InvoicingTemplate.com, the "Bill To" and "Shipping To" sections, are moved out of the printable receipt form. If you have tried Uniform Invoice Software, you probably have noticed that the information appear in the "Bill To" sections are required - especially the Customer# field. If the Customer# is blank when the "Save To DB" command is being clicked, Uniform Invoice Software shows a warning message and refuse to save the invoice to database.

(From Detail Page - about 79 words) - So how we make it possible to save a receipt in Uniform Invoice Software without manually filling in customer/client information? The secret is simple. Remember we are using Microsoft Excel that has a unique feature called Excel formula, which does not exists in Microsoft Word. By using Excel formula, we can easily assign default values (or place holder values) to those fields that must be filled according to Uniform Invoice Software, but not used in this money receipt template.

(From Detail Page - about 71 words) - For example, after moving the "Bill To" section out of the printable receipt form, we assign the formula (="PSName001") to the client name of the receipt, and assign the formula (="ps001") to the client# cell. Both Excel cells are then locked to prevent accidental modifications to the formula. Since the gold shop does not use or record these information, we can in fact assign any default values to these required cells.

(From Detail Page - about 129 words) - The "Lock" property is a very useful feature in Excel. When you protect a worksheet such as Receipt Template for Gold Shop (1), all cells are locked by default, which means that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only specific cells and ranges before you protect the Invoice worksheet of Receipt Template for Gold Shop (1). To lock a cell or a range of cells, first drag your mouse to select the cell or cells, and then right-click one of the selected cell on the form, choose Format Cells. On the Number tab, check the "Locked" box. To unlock a cell or a range of cells, simply clear the "Locked" box.

...(63)...

...(82)...

InvoicingTemplate.com also offers you variants of this receipt template, see Receipt Template for Gold Shop (2), which has the Making Charge column placed inside the printable receipt form; and Receipt Template for Gold Shop (3), which as the Rate cell moved into the printable receipt form; and Receipt Template for Gold Shop (4), which as both the Rate and Making Charge column moved into the printable blank receipt template.

LEARN MORE PDF

6. Mixed Tax Rates in an Invoice (5 Columns)

"Mixed Tax Rates in an Invoice (5 Columns)" was found to be relative to Recipient Tax Invoice Template with the score grade of 37.

(From Detail Page - about 37 words) - The default sales invoice template applies the defined tax rules to all items in an invoice. The customized free tax invoice template in this Mixed Tax Rates in an Invoice allows charging different rates to different items.

...(123)...

(From Detail Page - about 98 words) - Mixed Tax Rates in an Invoice (5 Columns), like the default sales invoice template, has two tax items on the bottom of the invoice form, which are applied to all the items in an invoice, and a column of Taxable checkboxes to the left of the form body, which are corresponding to each invoicing item. You can change the tax names and rates on the bottom of the form by typing in whatever meet your requirements. These are the supported features implemented in both the freeware version of the sales invoice template and the Uniform Invoice Software version.

...(167)...

(From Detail Page - about 138 words) - Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the invoice form. Mixed Tax Rates in an Invoice (5 Columns) uses custom fields to implement the features that are not available in the default sales invoice template. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, Uniform Invoice Software has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

...(114)...

...(102)...

...(238)...

...(21)...

(From Detail Page - about 111 words) - The difference between sales invoice template and service invoice template here on InvoicingTemplate.com is simple - if a template contains the "Ship To" section on the printable section, we call it sales invoice. If it does not contain the "Ship To" section, it is categorized as service invoice. If the form has a very special design in its layout, such as Tax Invoice for Printing Shop, which moves the "Ship To" section (titled with "Delivery To") to the body of the invoice form, we add the template to both the sales invoice template and service invoice template category. Mixed Tax Rates in an Invoice (5 Columns) adheres to this rule too.

(From Detail Page - about 76 words) - This invoice template, Mixed Tax Rates in an Invoice, has the "Product Type" and "Applied Tax Rate" placed outside of the printable area. What if you want to show these two columns on the printable invoice form? It is easy actual to do - as mentioned above, all you need to do is to first adjust the existing columns to leave space for the two newly added columns, and then move in the two new columns.

...(261)...

(From Detail Page - about 31 words) - The next step is to move the new columns added for this Mixed Tax Rates in an Invoice template, i.e. "Product Type" and "Applied Tax Rate" to the printable invoice form.

(From Detail Page - about 245 words) - Moving a cell or a group of cells is easy in Excel. First, you click to select the cell or drag your mouse to select all the cells you want to move. And then, drag the border of the selected area to move it to the new location where you want to place the cell or cells. The moving content will overwrite the content in the target location, so make sure the target range is empty (not used) in Mixed Tax Rates in an Invoice (5 Columns) before doing the movement. And, if the target location contains merged cells, sometimes the movement fails. So it is also helpful to make sure the target location does not contain merged cell. If the target location Mixed Tax Rates in an Invoice (5 Columns) is overlapping the original range and the original range contains merged cells, the movement could also fail because you cannot change part of merged cell - if this happens, you need to first move the cells to a temporal location in Mixed Tax Rates in an Invoice (5 Columns) that are empty (i.e. not used), unmerge cells, and then move the cells from the temporal location to the desired location. If you need to unmerge a cell, first select it and then click the "Merge and Center" command on the Format toolbar in Excel 2003; or click the "Merge and Center" command on the Home ribbon tab in Excel 2007, 2010 and Excel 2013.

(From Detail Page - about 28 words) - The result of moving the "Product Type" and "Applied Tax Rate" columns into the printable form can be found at Mixed Tax Rates in an Invoice (7 Columns).

LEARN MORE PDF

7. Service Invoice Form with Discount Percentage

"Service Invoice Form with Discount Percentage" was found to be relative to Recipient Tax Invoice Template with the score grade of 23.

(From Detail Page - about 28 words) - This service invoice template is a variant of Service Invoice Form with Discount Amount. The template redefined several Excel formulas so the Discount field becomes a percentage value.

(From Detail Page - about 73 words) - In the original implementation that could be found at Service Invoice Form with Discount Amount, the discount field is an amount value, which is deducted from the subtotal of an invoice by using Excel formula. With this customized invoice template, we modified the formula of the "discounted subtotal" cell to be "Subtotal * (1 - Discount Percentage)". This way, the discount value saved along with other customer information becomes a discount percentage value.

(From Detail Page - about 117 words) - Besides modifying the formula, you'll also need to set the format of the discount cell to show as a percentage. To do this, first unprotect the Invoice worksheet by clicking the Unprotect Sheet command on the Review ribbon tab, and then right-click the Discount cell on the bottom of the invoice form and choose Format Cells. On the Number tab of the Format Cells dialog box, you can set the format of the discount cell to be a percentage value. Feel free to browse the other options available on the Format Cells dialog box, you may find it helps you a lot when you try to customized the invoice template to create your own style and layout.

(From Detail Page - about 102 words) - The freeware version of Service Invoice Form with Discount Percentage invoice template does help you create professional and beautiful invoices with its intuitive form layout, and printing a hardcopy of an invoice is also as easy as issuing the Print command in Excel. However a pure Excel invoice template is a simple invoice creator or invoice generator, because it lacks the ability to manage customers, products, invoices and payments. To fulfill these types of business requirements, upgrade the pure-Excel invoice template to Uniform Invoice Software version, which allows Uniform Invoice Software creates the connection between Excel formatted invoice template and backend database.

LEARN MORE PDF

8. Commercial Invoice - FedEx Style

"Commercial Invoice - FedEx Style" was found to be relative to Recipient Tax Invoice Template with the score grade of 21.

...(31)...

(From Detail Page - about 80 words) - Note that there are two styles on FedEx, FedEx Express and FedEx Ground international shipping. This sample follows the one for FedEx Express. The Commercial invoice serves as an important document international trading, especially for the customs clearance process. Customs officials use commercial invoices to classify your merchandise. This in turn will help them in correctly assessing the applicable duties and taxes. Commercial invoices, like a bill of lading, one of the important documents used in international / foreign trade.

(From Detail Page - about 50 words) - There are already sample forms on FedEx, such as How to Complete a Commercial Invoice. The templates on FedEx is in either Adobe PDF or HTML format. Here at InvoicingTemplate.com we provide you with another alternative in Microsoft Excel spreadsheet format (and also a PDF version generated with Excel itself).

...(110)...

(From Detail Page - about 167 words) - Note that there are other commercial invoicing templates too. For example, DHL has a tutorial on this topic at Prepare Your Commercial Invoice. ShipNorthAmerica Transportation provides Free generic commercial invoice forms & templates on their website. Microsoft has an online version here. And here at InvoicingTemplate.com, we've already published several sample templates too, such as Commercial Invoicing Template, Commercial Invoice Template with Colorful Business Name, Blank Commercial Invoice Template, Free Commercial Invoice Template (UPS Style). There is no specified format for either a commercial invoice or a pro forma invoice, according to the U.S. Customs and Border Protection website. However, a commercial invoice must disclose certain required information, including a description and quantity of each item being shipped, the value of the shipment in both U.S. dollars and in the foreign currency, the country of origin, location of purchase, and the names and addresses of both the seller and the purchaser. U.S. Customs and Border Protection does not require the same information on a pro forma invoice.

(From Detail Page - about 103 words) - A pro forma invoice only needs to include sufficient information to allow for a determination of duties and examination. Since there is no required format for either type of invoice, a commercial invoice and a pro forma invoice may appear virtually identical or they may appear radically different. You can find several samples on pro forma invoice templates too here on InvoicingTemplate.com, for example Proforma Invoicing Sample, Simple Proforma Invoice Template, Proforma Invoice Template (4th Sample, Landscape Page Orientation), etc. For a full list of the commercial and proforma invoice template available here, visit the category page at commercial and proforma invoice template.

...(212)...

(From Detail Page - about 61 words) - All fields on this template are fillable, including Federal Express International Air Waybill Number, Date of Export, Export References and those checkboxes on the bottom of the form - FOB, C&F, CIF, except the "SHIPPER" and "DATE" fields located on the very bottom of the form. These should be manually signed, and thus not be stored into Uniform Invoice Software database.

LEARN MORE PDF

9. Hotel Receipt Template

"Hotel Receipt Template" was found to be relative to Recipient Tax Invoice Template with the score grade of 11.

(From Detail Page - about 46 words) - Hotel Receipt Template is a free Excel spreadsheet formatted template for hotel and motel / hostel businesses, for invoicing room tental and bed and breakfast. It is also one of the samples on how to customize the default sales invoice template shipped with Uniform Invoice Software.

(From Detail Page - about 121 words) - A hotel or motel needs different invoice and receipt formats than a generic sales invoice template or generic service invoice template for purchasing goods and service. The blank receipt form provided here on InvoicingTemplate.com offers a sample hotel receipt that you could use to create your hotel bills in an easy way. Our templates are in Microsoft Excel format. All templates here are not protected with password, so that you can easily customize the layout without problems. You can also download a printable PDF version of the hotel invoice template here. If you are looking for a hotel invoice template in Word ".doc" format online, we recommend this Excel-format template instead, as Excel provides more features for calculations and data validations.

(From Detail Page - about 58 words) - Front office transactions are typically charted on account statement as Invoice or Folios. Invoice consists of Debit and Credit (Also refer to Credit Memo Template) affecting the balance of a single guest account or room. This is different than general house rent, for which InvoicingTemplate.com also has a house rental invoice template too at House Rent Receipt Template.

...(29)...

(From Detail Page - about 113 words) - A hotel receipt is also called guest invoice, folios or bill format for hotels. Usually when a folio is opened the starting balance is zero. All transactions which increase (debit) or decrease (credit) the balance of the account are recorded on the folio. In Uniform Invoice Software, when guest does the final settlement of the invoice should be returned to zero balance by any of the method of payment given by guest. The process of recording transactions on an Invoice or a receipt is called posting. A transaction is posted either debit or credit when it has been recorded on the proper folio in the proper location and a new balance is determined.

(From Detail Page - about 43 words) - This templates use several custom fields that are not found in the default sales invoice template shipped with Uniform Invoice Software. The definition of the custom fields could be found by a travel to the corresponding data edit form in Uniform Invoice Software.

(From Detail Page - about 61 words) - While there are complex and expensive hotel management software programs available, which, generally, could also produce invoices and receipts for you, this free hotel invoice template and receipt template offers a budget-free way for creating professional invoices and receipts. The intuitive blank form of this template allows you to prepare and draft your invoices and receipts without a hard learning curve.

(From Detail Page - about 43 words) - The template has two taxes defined on the bottom of the form - which you can easily change the names and rates depending on your requirements. The Taxable column found in the default sales invoice template was removed from the hotel receipt template.

LEARN MORE PDF

10. Consultant Template Sample - New Company Name Field

"Consultant Template Sample - New Company Name Field" was found to be relative to Recipient Tax Invoice Template with the score grade of 5.

(From Detail Page - about 22 words) - This free sample template for the consulting service business demonstrates how to add a new field "Company Name" to an existing template.

(From Detail Page - about 104 words) - Every business is different, their requirements of service invoice creation are different too. Depending on the requirements, you may like to show a company name when billing a client/customer. The default template, and most samples here on InvoicingTemplates.com, include a field "Name" in the "Bill To" section. You can fill in either a contact / personal name or a business / company name into this field. However, what if you want to show both the company name and the contact name on your consultant invoice / receipt form? Of course, the newly added field should be able to work with the back-end database too.

...(61)...

(From Detail Page - about 29 words) - In this tutorial, we'll go through the detailed steps required to add a custom field Company Name. This new template will be based on c4034 Simple Consulting Invoice Template.

...(25)...

(From Detail Page - about 52 words) - Next, switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab. This command provided by Uniform Invoice Software combines several commands provided by Microsoft Excel -- it unprotects the sheet, show gridlines and row/column headings, and then push down the design mode button on Excel's "Developer" tab.

(From Detail Page - about 27 words) - Now click the heading cell of row 11, then choose "Insert". A new row is inserted between the rows that have the text labels "Name" and "Address".

(From Detail Page - about 38 words) - Enter the text "Company Name" into cell $I$11. Click the next to the label "Name" and then click the "Format Painter" on Excel ribbon Home tab. Click the cell $J$11. This paste the format into the target cell.

(From Detail Page - about 34 words) - Enter the cell name "oknClientCompanyName" for $J$11. To do this, first make sure $J$11 cell is selected, click the name box on the formula bar, and then enter the cell name "oknClientCompanyName" (without quotes).

(From Detail Page - about 51 words) - Go to print preview mode of the current worksheet. To do this, for example in Excel 2013 and Excel 2016, you click "File" menu and then choose "Print". This shows how it will look like when the sheet is printed. Make sure it is printable on the paper size you choose.

(From Detail Page - about 64 words) - Now our customization work for the template part has been done. We need additional steps to make sure it work with the backend database. That is, when you choose an existing customer, the company name information should be loaded along with other data such as the address, city state and zip. When you save an invoice, the company name information should be saved too.

...(119)...

(From Detail Page - about 87 words) - Note that in this step, we've created the custom field ClientCompanyName in both the "Customer" and "Invoice Header" database tables. The entry for both database tables should be exactly the same - in this sample, the field name is "ClientCompanyName", and the size is 100. Also the field name should match the cell name on the "Invoice worksheet". This this sample, the cell name is "oknClientCompanyName", the field name is "ClientCompanyName" - as you can see, the field name is the cell name without the "okn" prefix.

LEARN MORE PDF