Customs Invoice Form Spreadsheet Free Download

1. Commercial Invoice - FedEx Style

"Commercial Invoice - FedEx Style" was found to be relative to Customs Invoice Form Spreadsheet Free Download with the score grade of 90.

(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).

(From Detail Page - about 110 words) - c9002 - Commercial Invoice - FedEx Style (Commercial Invoice Format - FedEx Style) 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 version of blank FedEx format commercial invoice sample that is printable with landscape paper orientation, see Commercial Invoice - FedEx Style (Landscape). 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 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.

LEARN MORE PDF

2. Consulting Invoice Template (3rd Sample - One Tax)

"Consulting (3rd Sample - One Tax)" was found to be relative to Customs Invoice Form Spreadsheet Free Download with the score grade of 85.

(From Detail Page - about 26 words) - The previous 2 sample consulting invoice templates have two taxes defined on the bottom of the form. This new sample demonstrating how to use one tax.

(From Detail Page - about 87 words) - The first sample consulting invoice template in this serial talks about how to move cells. With the second sample, we take an easy way to change the appearance of the invoice form by changing the color theme of the form. With this third sample of customizing the original consulting invoice template, we look at another common problem faced by many of our users - how to change the tax items. That is, if you charge only one tax, how to implement it with the consulting invoice template?

(From Detail Page - about 98 words) - Consulting Invoice Template (3rd Sample - One Tax), 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.

(From Detail Page - about 167 words) - If you use the Uniform Invoice Software version of Consulting Invoice Template (3rd Sample - One Tax), there are additional taxing options on the Taxes tab of the Settings window. The first is the option for choosing the number of tax items; you have 3 choices - no tax, one tax and two taxes. Secondly, you can set the names and rates in percentage for each tax, such as VAT, GST or PST, or simply Sales Tax. Thirdly, there are a group of checkbox options on the dialog box, including: "Tax invoice total including shipping cost", which adds the shipping cost to the taxable amount when checked; "Tax 2 is applied to tax 1", which adds the amount of "tax 1" to the taxable amount if checked; and "tax rate can be zero", which allows you to set any of the tax rates to be the value of zero. If you modify the options on this dialog box, the invoice form will be changed accordingly if needed.

LEARN MORE PDF

3. Commercial Template Sample - Using Payment Method Checkboxes

"Commercial Template Sample - Using Payment Method Checkboxes" was found to be relative to Customs Invoice Form Spreadsheet Free Download with the score grade of 66.

...(21)...

...(93)...

(From Detail Page - about 84 words) - A checkbox is an ideal way to present a "yes/no" option. The FedEx style of commercial invoice template, which we added here on InvoicingTemplate.com to mimic the layout of the PDF version of FedEx blank commercial invoicing template, uses 3 checkboxes on the bottom of the form in the section tilted with "Check One". There are 3 options there - FOB, C&F and CIF. On the Adobe PDF version of the commercial invoices converted from the Excel-formatted document, the checkboxes will work well too.

(From Detail Page - about 117 words) - With the sample, a payment method option is added, which comprises 3 checkbox - "L/C", "T/T" and "Other" - where T/T means telegraphic transfer, or simply wire transfer; and L/C Letter of credit (See the screenshot). For international trade, this payment detail should be useful when it appear on the commercial invoices. Generally, every dutiable shipment sent through FedEx, DHL or UPS must be accompanied with an invoice. The invoice must identify the seller and buyer. It must also clearly indicate the terms and date of sale, quantity, weight and volume of the shipment. It must also indicate a complete description of the shipped goods, shipping, insurance and other charges, unit value and total value as applicable.

(From Detail Page - about 115 words) - c9004 - Commercial Template Sample - Using Payment Method Checkboxes (Commercial Template Format - Using Payment Method Checkboxes) 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 of blank FedEx format commercial invoice sample that is printable with landscape paper orientation, see Commercial Invoice - FedEx Style (Landscape). 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.

...(89)...

...(93)...

(From Detail Page - about 57 words) - Note that these 3 cells must be unlocked so that when the Invoice worksheet is protected, Uniform Invoice Software is able to write to these cells. To do this, select the 3 cells and right-click one of them, choose Format Cells. On the Format Cells dialog box, clear the "Locked" boxes from the "Protection" tab. Click OK.

(From Detail Page - about 89 words) - In Microsoft Excel, there are in fact two ways to add checkbox to a spreadsheet - by using a form control, or by using an ActiveX control. Both options are located on Excel's "Developer" ribbon tab. This tab is not shown by default in Microsoft Excel. To make it visible, firstly you right-click an empty area on the ribbon and then choose "Customize the Ribbon" command from the shortcut menu. On the "Customize the Ribbon" section of the Excel Options dialog box, check the "Developer" option and click OK.

...(56)...

(From Detail Page - about 68 words) - Assuming you choose the "Form Control" version of the checkboxes, now right-click the one of the newly added box and choose Format Control. On the "Control" tab, enter "oknPaymentMethodTT" (or "oknPaymentMethodLC", or "oknPaymentMethodOther") into the "Cell Link" property. By setting this property, you link the state of the check box to the specified cell value, which in turn links to a database field as specified by the name.

(From Detail Page - about 74 words) - The last thing is that, if you want to be able to extract the commercial invoice (this means to create a new Excel spreadsheet file for the current invoice) along with the new checkbox, then the checkbox must be named with "oknWidget_" prefix. In this commercial invoice sample, we named the controls "oknWidget_checkTT", "oknWidget_checkLC" and "oknWidget_checkOther" respectively. More information could be found in the documentation that comes with the Uniform Invoice Software installer program.

LEARN MORE PDF

4. Sales Invoice Form with Discount Percentage

"Sales Invoice Form with Discount Percentage" was found to be relative to Customs Invoice Form Spreadsheet Free Download with the score grade of 62.

(From Detail Page - about 33 words) - As the name implies this variant of the original Service Invoice Form with Discount Amount is a sales invoice template with shipping fields inside the printable area, and the discounts use percentage values.

(From Detail Page - about 46 words) - The meaning and the usage of the discount values, including the implementation details, can be found at Service Invoice Form with Discount Percentage. If you are look for information on moving Excel cells and controls, you can find it at Sales Invoice Form with Discount Amount.

(From Detail Page - about 58 words) - All templates available here on InvoicingTemplate.com, including this Sales Form with Discount Percentage, are created based on the sales invoice template that is shipped with Uniform Invoice Software. Uniform Invoice Software is our invoicing software that turns a simple Excel formatted invoice template to a powerful invoicing program with the ability to manage customers, products, payments and invoices.

(From Detail Page - about 100 words) - The invoice template has one tax set by default. You can change the tax name and rate by just typing in your own tax name and rate. If you need other taxing types and have Uniform Invoice Software installed, simply click the Settings button and then go to the Taxes tab, choose from Non-Tax, One-Tax and 2-Taxes. You can also set tax names and rates on this dialog box. Several other options, such as "tax invoice total including shipping cost", "tax 2 is applied to tax 1" and "Tax rate can be zero", are also available on this dialog box.

(From Detail Page - about 37 words) - While the freeware version of this Sales Invoice Form with Discount Percentage does help you create beautiful invoices in an easy way, Uniform Invoice Software goes one step further by making it all fully featured invoicing system.

LEARN MORE PDF

5. Telecom Consultant Estimation Template

"Telecom Consultant Estimation Template" was found to be relative to Customs Invoice Form Spreadsheet Free Download with the score grade of 60.

(From Detail Page - about 26 words) - A telecom consultant business sends estimations to their customers based on recommendation letters. Telecom Consultant Estimation Template makes the creation of the estimations easy and quick.

(From Detail Page - about 102 words) - Although it is easy to create the layout and format of Telecom Consultant Estimation 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, Telecom Consultant Estimation 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 Telecom Consultant Estimation 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.

...(77)...

(From Detail Page - about 72 words) - The product# column is place to the left of the printable area. Although the term "product" is used here, you can actually use it for consulting service items. If you use the Uniform Invoice Software edition of Telecom Consultant Estimation Template, the product management features of the Excel Invoicing Software helps you management consulting service items, so that you don't have to enter the same or similar description text again and again.

(From Detail Page - about 61 words) - The protection of the Invoice worksheet in Telecom Consultant Estimation Template prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the invoice worksheet. However for the purpose of this sample, we should firstly unprotect the Invoice worksheet in Telecom Consultant Estimation Template.

...(25)...

(From Detail Page - about 89 words) - (Note that if you have installed the latest version of our invoicing software, Uniform Invoice Software, which is able to upgrade a simple template in Microsoft Excel spreadsheet format into a complete invoicing system, you don't have to replace the logo image manually - you can replace the default logo image by clicking the "Replace Logo Image" button on the ribbon tab in Excel 2007, Excel 2010 and Excel 2013). To replace the default LOGO image in Telecom Consultant Estimation Template with your own image, follow the steps below:

• Right click the Logo image, and then select Properties from the menu.
• Click the Picture property, and then click the "..." button.
• Browse to the folder containing your icon file. Select and open the icon file.
• Close the Properties dialog box.
• Drag the border of the image object to resize it, if needed.

...(100)...

(From Detail Page - about 48 words) - If you use the Uniform Invoice Software version of Telecom Consultant Estimation Template, and replace the default logo image by copy and paste, make sure it is named with the prefix "oknWidget", otherwise it will not be included if you execute the "Extract" command in Uniform Invoice Software.

(From Detail Page - about 59 words) - Although this template is named Telecom Consultant Estimation Template, it could actually be seen as a general purpose consulting invoice template. Remove the formula from the "Fee @ 50%" column to make it manually editable (and change the column headings of course), this will make it a generic consulting estimate template as you can enter any amount as needed.

LEARN MORE PDF

6. Commercial Invoice - FedEx Style (Landscape)

"Commercial Invoice Format - FedEx Style (Landscape)" was found to be relative to Customs Invoice Form Spreadsheet Free Download with the score grade of 58.

...(33)...

(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.

...(157)...

...(77)...

(From Detail Page - about 100 words) - As detailed on the FedEx web site, all shipments / freight must be accompanied by a FedEx International Air Waybill & two duplicate copies of commercial invoices. With Uniform Invoice Software installed, printing of two copies of your commercial invoices could be done with a single click of mouse. Go to the Print tab on the Settings window to find all the printing options. All forms available here on InvoicingTemplate.com are printable and fillable. You can adjust the printing and paper options by using Excel's own features too - for example, by choosing the options on Excel's Page Layout tab.

(From Detail Page - about 167 words) - Here on InvoicingTemplate.com, we have a number of commercial invoices and proforma invoice template built for you to choose, including samples that are similar to layouts recommended by DHL, UPS and FedEx. All the templates work well with Uniform Invoice Software. Feel free to visit U.S. Customs and Border Protection documentation for Requirements, criteria, or format of a commercial invoice, bill of sale, receipt that must be provided when clearing or filing entry documents. In foreign trade / international transactions, commercial invoice documents are important to both export trade and import trade. It is used when dutiable goods are shipped internationally, and as a customs declaration provided by the person or corporation that is exporting an item across international borders. It is used by the customs officials to classify your merchandise. This in turn will help them in correctly assessing the applicable duties and taxes. The Commercial Invoice is prepared by the exporter and is required by the foreign buyer to prove ownership and arrange for payment.

LEARN MORE PDF

7. Proforma (2nd Sample of Customization)

"Proforma Invoicing Form" was found to be relative to Customs Invoice Form Spreadsheet Free Download with the score grade of 46.

...(27)...

(From Detail Page - about 63 words) - With the first sample on how to customize the proforma invoice template, we learnt how to unprotect the Invoice worksheet and how to modify Excel color palette to change the color theme of an existing template. This second sample of customizing the pro forma invoicing template will be focused on how to enter your company information and replace the default "InvoicingTemplates" logo image.

(From Detail Page - about 90 words) - Most of the templates available here on InvoicingTemplate.com have the Invoice worksheet protected to avoid accidental modifications on form layout and formula. This is useful and necessary since once the design of the form is finished, you'll not change the design for a long time. However before using the invoice template, you at least need to do two things that are to enter your company information, and to replace the default logo image. Before you do, you first need to unprotect the Invoice worksheet, as detailed in the previous sample.

(From Detail Page - about 52 words) - Once the invoice spreadsheet is unprotected, it's straightforward to enter your own company information. Simply click a text label such as "Your Company Name", and then start typing in your own text. In the sample template that you can download here, we replace the placeholder text labels with our own company name.

(From Detail Page - about 55 words) - The next step is to replace the default "InvoicingTemplates" logo image. To do this, you need to switch the invoice form into design mode, which is done by clicking the "design mode" command on the Developer ribbon tab. If your Excel does not show the Developer ribbon tab, here is how to make it visible.

1. Start Excel as usual. On the File tab, choose the Options button.
2. In the Excel Options dialog box, choose the Customize Ribbon button.
3. In the list of main tabs, select the Developer check box.
4. Choose the OK button to close the Options dialog box.

(From Detail Page - about 81 words) - Now you can find the Design Mode button in the Controls group on the Developer ribbon tab. Click the Design Mode button once to put the template into design mode - in the design mode, Excel lets you change the properties of controls, such as the image control we used for the logo image. If you are using Uniform Invoice Software, our invoicing software that uses Excel templates as the front-end, the software program stops reaction to clicks on the button.

(From Detail Page - about 80 words) - Now right-click the InvoicingTemplates logo image and choose Properties from the shortcut menu. The Properties box appears. Look for the Picture property, and click the button on that line. Excel shows you a dialog box that allows you to browse to and specify your own logo image. Depending on your Excel version, the supported image file formats may vary, but JPG, PNG and GIF formats are good choices for storing your logo image that are likely supported by your Excel.

(From Detail Page - about 28 words) - Once you have specified your own logo image, exit design mode, and then protect the Invoice worksheet again. Save the invoice template once to make the changes persistent.

LEARN MORE PDF

8. Simple 2-Column Sales Invoice Template

"Simple 2-Column Sales Invoice Template" was found to be relative to Customs Invoice Form Spreadsheet Free Download with the score grade of 25.

...(32)...

(From Detail Page - about 63 words) - This general simple invoice template does not contains the section for shipping address fields, assuming shipping address are the same as the "bill to" address. However, "Ship Date", "Ship Method", and the field for you to enter shipping cost are still left on the invoice form, that's why we at InvoicingTemplate.com categorize it as sales invoice template, but not a service invoice template.

...(16)...

...(95)...

(From Detail Page - about 164 words) - If you use the Uniform Invoice Software version of Simple 2-Column Sales Invoice Template, there are additional taxing options on the Taxes tab of the Settings window. The first is the option for choosing the number of tax items; you have 3 choices - no tax, one tax and two taxes. Secondly, you can set the names and rates in percentage for each tax, such as VAT, GST or PST, or simply Sales Tax. Thirdly, there are a group of checkbox options on the dialog box, including: "Tax invoice total including shipping cost", which adds the shipping cost to the taxable amount when checked; "Tax 2 is applied to tax 1", which adds the amount of "tax 1" to the taxable amount if checked; and "tax rate can be zero", which allows you to set any of the tax rates to be the value of zero. If you modify the options on this dialog box, the invoice form will be changed accordingly if needed.

(From Detail Page - about 33 words) - The invoice template has our logo placeholder image on it, which you should replace with your own logo image. To do this, simple unprotect the Invoice worksheet, and then switch to design mode.

...(63)...

(From Detail Page - about 135 words) - In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Simple 2-Column Sales Invoice Template. Note that if you have our invoicing program (Uniform Invoice Software) installed, and you are running Excel 2007, Excel 2010 and Excel 2013, it already provides a Design Mode button on the ribbon tab, so that you don't have to switch to design mode manually. Our invoicing software is able to turn a simple spreadsheet into a powerful invoicing system, with the ability to manage customers, products invoices and payments, it also includes various tools that could help you configure the layout of your form, such as the number of taxes and tax names and rates. If you don't have our invoicing program installed, here are how you can switch to design mode manually.

...(153)...

(From Detail Page - about 23 words) - Once you have finished your design work for Simple 2-Column Sales Invoice Template, click the Design Mode button again to exit design mode.

(From Detail Page - about 90 words) - (Note that if you have installed the latest version of our invoicing software, Uniform Invoice Software, which is able to upgrade a simple template in Microsoft Excel spreadsheet format into a complete invoicing system, you don't have to replace the logo image manually - you can replace the default logo image by clicking the "Replace Logo Image" button on the ribbon tab in Excel 2007, Excel 2010 and Excel 2013). To replace the default LOGO image in Simple 2-Column Sales Invoice Template with your own image, follow the steps below:

• Right click the Logo image, and then select Properties from the menu.
• Click the Picture property, and then click the "..." button.
• Browse to the folder containing your icon file. Select and open the icon file.
• Close the Properties dialog box.
• Drag the border of the image object to resize it, if needed.

...(100)...

(From Detail Page - about 54 words) - Feel free to download and try Uniform Invoice Software along with this simple 2-column sales invoice template. Installing Uniform Invoice Software, our Excel Invoice Software, will also install the help documents for the invoicing program, which includes detailed instruction on how to customize the invoice template such like this simple 2-column sales invoice template.

LEARN MORE PDF

9. Service Invoice with Payment Advice

"Service Billing Template with Payment Advice" was found to be relative to Customs Invoice Form Spreadsheet Free Download with the score grade of 11.

(From Detail Page - about 16 words) - A general service invoice template that had the shipping section removed and added a payment advice.

(From Detail Page - about 77 words) - Like all the other invoice templates here on InvoicingTemplate.com, this Service Invoice with Payment Advice was also created from the default invoice template shipped with Uniform Invoice Software installer program. The most noticeable features of this template are that it has the shipping section moved out of the printable area of the template, and on the invoice body there are only two columns - a Description column and a Line Total column. Both columns are manually editable.

(From Detail Page - about 77 words) - Although this is a very different format or layout than the default invoice template shipped with Uniform Invoice Software, the fact is that it is not so hard to customize default invoice form to create this one. The most important operation during the customization is the moving of cells and fields. Let's say you want to move the shipping section in the default sales invoice template out of the printable area, for example, here are the steps.

1. First you should unprotect the Invoice worksheet. Most templates designed by us here at InvoicingTemplate.com turn on protection to avoid damage to layouts and formulas by mistake. However before you can customize an invoice template, you should firstly unprotect it by clicking the Unprotect command on Excel Review ribbon tab.
2. Now drag your mouse to select the cell/cells you want to move.
3. Push your mouse key on the border of the selected area. Drag it to the new location where you want to place the cell/cells.
4. Once done, protect the Invoice worksheet.

(From Detail Page - about 49 words) - The documents included in Uniform Invoice Software have more detailed instructions on how to customize the template. Be sure to download it and test it. If you are not satisfied with a simple Excel invoicing template, Uniform Invoice Software can turn it into a fully featured invoicing software program.

LEARN MORE PDF

10. Consultant Template Sample - New Company Name Field

"Consultant Template Sample - New Company Name Field" was found to be relative to Customs Invoice Form Spreadsheet Free Download with the score grade of 2.

(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.

(From Detail Page - about 61 words) - The solution is to add a new field "Company Name". In Uniform Invoice Software, we call this field "Custom Field" since it is not already defined in the template and database. On the other hand, those fields that are already included in the default template and database (as included in the setup program of Uniform Invoice Software) are called standard fields.

...(29)...

...(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).

...(51)...

(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.

(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