The printed version.
Excel Formula to Fix the Decimal Size Warning (c5112)
c5112 now includes the customized invoice template for the latest version of Invoice Manager for Excel. This is what you will see when you open
Excel Formula to Fix the Decimal Size Warning - IMFE edition
You are safe to download the resources. We've added our digital signatures to the files.
Download this if you want this design to be set as the default template by the installer program.
Without database file. How to download and use
Download this if you have already installed IMFE, and are looking for additional customized templates; or if you want a template for Invoice Manager (Lite).
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 Invoice Manager for Excel does not work that way. With Invoice Manager for Excel 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 Invoice Manager for Excel 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:
If you need to apply this change to your own template, follow the steps below.
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, 2016 or 2019.
|Name||Excel Formula to Fix the Decimal Size Warning|
|Category||Sales Invoice Template|
|Release Date||Sunday, April 2, 2017|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016 / Excel 2019|
|Line Height (Points)||19.50|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|