Skip to main content
InvoicingTemplate.com main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

Screenshots and Images

The printed version.

Simple Sample - Customer Name on Product Report

Simple Sample - Customer Name on Product Report (c4059)

c4059 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open simple-sample-customer-name-on-product-report-uis.xlsx.

Simple Sample - Customer Name on Product Report (UIS Edition)

Simple Sample - Customer Name on Product Report - UIS edition

Download

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Without database file. How to download and use

77 KBDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

308 KBDownload

Download this if you want this design to be set as the default template by the installer program.

2.79 MBDownload

Detail

The default product report contains fields defined in the "Invoice Body" database table. This simple invoice template sample demonstrates how to add fields in the "Customer" or "Invoice Header" database tables to the "Product" report by using custom fields.

In this sample, we'll take the result template built in c4051 Simple Invoice Template - Discount Amount Field as a starting point, create two custom fields, "CustomerName" and "CustomerContact" in the invoice body database table, and then add them to the product report. Note that in order to follow this tutorial, you should have Uniform Invoice Software installed, which is our invoicing software app for automated invoice processing. Download the fully functional trial version for free.

  1. As always, first you need to back up the files that will be modified. In this case, we'll modify both the template and database files. So back up both files.
  2. Open the invoice template as usual.
  3. Click the "Invoices" button on the ribbon tab.
  4. Click "Custom Fields" on the toolbar. This opens the Custom Field Manager.
  5. From the "Database table" drop-down list, choose "Invoice Body".
  6. Click "Add Field". This opens the "Add New Custom Field" dialog box.
  7. Fill in these values - Name: CustomerName, Size: 100. Click OK. This create a custom field named "CustomerName".
  8. Click "Add Field" again. Create another custom field "CustomerContact", set field size to 100.
  9. Click "Close" to close the Custom Field Manager and return to the invoice spreadsheet form.
  10. Click the "Design Mode" button on the "Invoice" ribbon tab to switch the billing form into design mode.
  11. Now choose a place to populate the customer name and contact number on the invoice body. Note these information will not be printed, so we choose column W and column X. Enter the column heading label "Customer Name" into $W$21, and then enter "Contact" into $X$21.
  12. Name the "CustomerName" cells, ranging from W22 to W33. The names should like these - oknCustomerName_1, oknCustomerName_2, oknCustomerName_3, ... oknCustomerName_12.

    Name the "CustomerContact" cells in the same way too, ranging from X22 to X33. The names should like these - oknCustomerContact_1, oknCustomerContact_2, oknCustomerContact_3, ... oknCustomerContact_12.

  13. Assign formula to the first customer name cell (oknCustomerName_1): =if(D22="","",oknWhoName). This formulas means that, if the first Product Description cell (D22) is empty, then the current cell is empty; if the first Product Description cell is not empty, fill the current cell with the value of customer name (oknWhoName).
  14. Make sure oknCustomerName_1 ($W$22) cell is selected, push left mouse key on the fill handler (right-bottom corner) of the selection box, drag down till W33. Excel fill formulas automatically into all the other oknCustomerName_* cells.
  15. Click to select the first customer contact number cell (oknCustomerContact_1). Assign it a formula: =IF(D22="","",oknWhoPhone).
  16. Make sure oknCustomerContact_1 ($X$22) cell is selected, push left mouse key on the fill handler (right-bottom corner) of the selection box, drag down till X33. Excel fill formulas automatically into all the other oknCustomerContact_* cells.

    As you can see from this sample, it is easy to populate and calculate data using Excel formulas. While there are other tools like Microsoft Word, Adobe Acrobat or even Photoshop and some online apps like Google Docs, that could create beautiful invoice and billing forms, one of the best / big advantages of Excel is that it simplifies calculations.

  17. Click and activate the "Product Report" worksheet.
  18. Click the "Unit Cost" column heading. Quickly click "Format Painter" twice on Excel "Home ribbon tab.
  19. Click the next two cells to the right of the "Unit Cost" cell - in this case, J10 and K10 . This paste the format of the "Unit Cost" cell to J10 and K10. Press ESC on keyboard to exit the format painter.
  20. Click to select the J10 cell. Name it "oknRpCustomerName". Fill column heading into this cell like "Cust. Name". You may need to resize the column to make it wider.
  21. Click to select the K10 cell. Name it "oknRpCustomerContact".Fill column heading into this cell like "Cust. Contact". Again, you may need to resize to column to make it wider.
  22. Exit design mode by clicking the "Design Mode" button again on the "Invoice" ribbon tab.
  23. Now if you create and save a new invoice, the customer name and contact number will be saved along with each item. And if you generate a product report, the customer name and contact number will be shown on report too. Note that after adding two new columns, the "Product Report" will not be printable with the default paper size and orientation. You may like to change paper size or orientation, or hide some columns by clicking the Columns button on the Product Report worksheet.

The definition of the database structure in Uniform Invoice Software established the "one-to-many" relationship between the "Invoice Header" (i.e. "InvIndr") and "Invoice Body" (i.e. "InvBdy") database tables. This means that, for each record in the invoice header database table, there might be one or many items belong to it.

On the other hand, the main content of the "Product" report is retrieved from the invoice body database table, adding the fields of the invoice header table to the invoice body table will create many redundant data, as they must be repeated for each item. One exception though - the definition of invoice body items must include the invoice# (InvoiceID) field, since it is the primary key of the invoice header table that identifies each uniquely.

However there are still situations where you prefer to know which customer purchased what product. For example, if you are service provider you may want to know what service offered to what customer from the product report. If you are selling products, the advantages of adding customer information to the product report is that you will be able to easy find where (or to whom) the products were sold to. It is common for attorney / legal, medical, catering, restaurant, law firms (whether small or big), health insurance billing or statement / timesheet, car / vehicle sales, graphic designs, freelance, plumbing, marketing, business plans, accounting, house rent (yearly or monthly), or even home businesses for monthly bill.

Like other form designs here on InvoicingTemplate.com, Simple Invoicing Sample - Customer Name on Product Report is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.

Format and Specification

Template#c4059
NameSimple Sample - Customer Name on Product Report
CategorySales Invoice Template
Release DateFriday, February 5, 2016
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns4
Lines12
Line Height (Points)18.00
Print Area$D$2:$K$47
Papaer Size / OrientationPortrait
Default Margins (Points)
Left15.12
Right24.48
Top53.64
Bottom55.80