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.

Excel Formula to Fix the Decimal Size Warning

Excel Formula to Fix the Decimal Size Warning (c5112)

c5112 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open excel-formula-to-fix-decimal-size-warning-uis.xlsx.

Excel Formula to Fix the Decimal Size Warning (UIS Edition)

Excel Formula to Fix the Decimal Size Warning - UIS edition

Download - Excel Formula to Fix the Decimal Size Warning

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

94 KBDownload

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

348 KBDownload

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

2.81 MBDownload

Detail

If you have an old invoice template, which does not have all the field values correctly rounded to proper size as defined in database, you may see the field size warning on saving an invoice. This tutorial shows you how to fix that.

When our invoicing program is called Excel Invoice Manager, a built-in feature automatically rounds decimal values to the size (or precision and scale) as what defined in the underlying Microsoft Access database. For example, the "Line total" is usually defined as "Decimal (10,2)", which means it allows up to 10 digits in the decimal value, and up to 2 digits after the decimal point. If the line total being saved is "10.123", it is automatically rounded to "10.12" and the invoice is successfully saved, plus a new invoice# is generated when needed.

However Uniform Invoice Software does not work that way. With Uniform Invoice Software we want to make sure everything is as accurate as possible and thus it does not remove digits from the calculated values silently. If you use an old template with the latest version of Uniform Invoice Software and encounter the decimal field size warning on saving invoice, there are two ways to fix it.

The first way is to use an Excel formula "Round" to make sure the result of the calculation fit into the field size definition in the Access database. For example, in c5001 invoice template with tax column (in the category Tax Invoice Template), we use a "Round" formula to make sure the calculated result of line total has only 2 digits to the most after the decimal point:

=ROUND(oknQuantity_1*oknPrice_1,2)

If you need to apply this change to your own template, follow the steps below.

  1. Backup your template.
  2. Open the template as usual.
  3. Switch to design mode by pushing down the "Design Mode" button on the "Invoice" ribbon tab.
  4. Click the cell for which you want to modify the formula. The Excel formula bar shows the current formula applied to this cell, like this:
    =oknQuantity_1*oknPrice_1
  5. Modify the above formula so that it looks like this:
    =ROUND(oknQuantity_1*oknPrice_1,2)
  6. You may need to repeat the above step to modify all formulas of all the line total cells.
  7. You may also need to check the formulas of the tax cells, make sure they have only two digits after the decimal point.
  8. Once done, exit design mode by clicking the "Design Mode" button again.
  9. Save the template.

The second way is to modify the field size definition in the underlying Access database. This is described in c4108 Customization of Standard Fields.

The template attached in this document is a revised version of c5001 invoice template with tax column. This new one has exactly the same fields as the original one, but with slightly different form layout and design.

Like other form designs here on InvoicingTemplate.com, Excel Formula to Fix the Decimal Size Error 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#c5112
NameExcel Formula to Fix the Decimal Size Warning
CategorySales Invoice Template
Release DateSunday, April 2, 2017
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns5
Lines12
Line Height (Points)19.50
Print Area$G$2:$P$44
Printable with Papaer Size / OrientationExcel Formula to Fix the Decimal Size Warning - Portrait
Default Margins (Points)
Left41.76
Right42.48
Top78.48
Bottom83.52