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.

Customization of Standard Fields

Customization of Standard Fields (c4108)

c4108 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open customization-of-standard-fields-uis.xlsx.

Customization of Standard Fields (UIS Edition)

Customization of Standard Fields - UIS edition

Download - Customization of Standard Fields

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

111 KBDownload

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

303 KBDownload

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

2.82 MBDownload

Detail

Standard fields are those that already created in the default database file shipped with Uniform Invoice Software (UIS), as opposed to custom fields (i.e. user-defined fields) which you should create yourself. This template demonstrates how to change the definition of standard fields.

The database fields defined by the default invoice template (or standard invoice template) are useful for common situations. In most cases you don't have to change them. However if it is needed according to your business requirements, here are the steps to follow.

First, make sure you have made a backup of your current database file, so that in case something goes wrong during the following steps you are able to return to the original state easily. In this sample, we'll be using c4020 Invoice Template with Long Product Description with which we show you how to customize the invoice template so that it allows you to enter more text into the description fields of the standard invoice format shipped with UIS.

  1. Open your template as usual.
  2. Click "Customers" on the "Invoice" ribbon tab.
  3. Click "Custom Fields", and then "Advanced..."
  4. If you have not backed up your database file yet, click the "Backup Database" to do so now.
  5. From the "Database Table" list, choose the table you want to modify. The "Fields" section shows the fields defined in this table.
  6. Double-click the field you want to modify; or click to select the field, and then click the "Customize" button.
  7. On the "Customizing Field" dialog box, you can field size (or in case of "Decimal" field, its precision and scale) and text alignment method on data list window.
  8. Click OK to apply the modification.

See "Advanced Database Field Customization" chapter of Uniform Invoice Software documents for more information on this topic.

Note that if you change the size of the text field, you may also need to change the data validation of the corresponding cell. For example, if you change the size of customer name field to 80, to change the data validation of the Excel cell, follow the steps below.

  • When the Invoice worksheet is active, push the "Design Mode" button on the "Invoice" ribbon tab.
  • Click and choose the customer name cell that is named "oknWhoName".
  • Go to "Data" Excel ribbon tab, and then click "Data Validation" in the "Data Tools" group.
  • Specify the new validation - for this example, you just need to modify the "Maximum" field to be 80.
  • Exit design mode.
  • Save the invoice template.

See Customizing Invoice Template for more information.

The database and template attached on this page has its product description field, in both the "Product" and "InvBdy" database tables, were changed to 255.

Like other form designs here on InvoicingTemplate.com, Customization of Standard Database Fields 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#c4108
NameCustomization of Standard Fields
CategorySales Invoice Template
Release DateThursday, March 30, 2017
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns4
Lines6
Line Height (Points)39.75
Print Area$E$2:$N$44
Printable with Papaer Size / OrientationCustomization of Standard Fields - Portrait
Default Margins (Points)
Left36.00
Right36.00
Top77.76
Bottom88.56