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).
This sample shows how to change the precision / scale of the unit price, unit cost, line total, subtotal, paid and total due cells. For example, if you are a graphics business in New Zealand and want to calculate to a tenth of a penny (i.e. $000,000.062), you need to modify the default database fields.
To do the required calculations, the following database fields should be modified / reviewed.
|Database Table||Field||Field Precision / Scale|
Note that if you use the Purchase Order and Quote worksheets, the related database tables, i.e. PurchaseOrderHdr and PurchaseOrderBdy, QuoteHdr and QuoteBdy, should be modified in a similar way too.
To modify a field:
Once you have modified the database fields, the next step is to modify the invoice form so that it shows the required digits after the decimal point. To do this:
You can also format the reports to show 4 digits. To do this:
Note that as of Invoice Manager for Excel version 7.12, the setting of database fields does not affect how the decimal numbers shown on the data list windows and various "Edit" windows, such as the "Invoices" data list window and "Customer Edit" window. However, the program does offer a hidden option that allows you to show 4 digits for the price fields on the data list windows. Contact us to find out how you can registry file to enable this. We're looking forward to upgrade Invoice Manager so that the program adjust the decimal formats automatically according to the changes made to the database fields.
Like other form designs here on InvoicingTemplate.com, How to Modify the Standard 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, 2016 or 2019.
|Name||Custom Price Precision and Scale|
|Category||Sales Invoice Template|
|Release Date||Wednesday, April 24, 2019|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016 / Excel 2019|
|Line Height (Points)||18.00|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|