Assuming you have downloaded and installed Uniform Invoice Software:
Prefer to have a look at other samples? Try our Search tool!
The printed version.
Advanced Invoicing Sample - Email Is Required Before Saving Invoice (c5103)
c5103 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open advanced-invoicing-sample-email-is-required-before-saving-invoice-uis.xlsx.
Advanced Invoicing Sample - Email Is Required Before Saving Invoice - UIS edition
You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed UIS, but are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
Starting from Uniform Invoice Software version 5, a new Excel add-in module "Uniform Invoice Software Helper" was introduced to provide functions for the Excel on-sheet buttons on the Invoice and report worksheets. This sample demonstrates how you can call the action procedures from your own macro.
In Advanced Invoicing Sample - Macro-Enabled Invoicing Template (c5101) we looked at how to make your invoice template a macro-enabled template, and provided information and resource links involved, such as Office / Excel security settings, digital signature, etc. In Advanced Invoicing Sample - Invoiced Total in English Words (c5102), we provided a practical example implemented as a macro-enabled invoicing template, i.e. a user-defined Excel formula / function that is able to convert a numeric value into English words.
Unlike the billing format samples implemented in the "Simple Invoice Templates" series, where the customized templates are usually created by moving fields and cells, or modifying Excel formulas etc., this "Advanced Invoicing Sample" series contains samples that require some knowledge of VBA programming and Microsoft Excel / Office object model.
This sample template demonstrates how you can call UIS action procedures (i.e. those actions performed when you clicking the buttons on the "Invoice" worksheet. By calling the UIS procedures from your own macro, you'll be able to include your own business logic on invoicing processing.
This sample template takes Advanced Invoicing Sample - Invoiced Total in English Words as the base template, which is a title featured on the "Business Invoice Templates" gallery. We'll add macro code to check if the email field in the "Bill To" section is blank - if so, saving invoice will be failed and a message is shown to ask the user to enter the email address. (Feel free to see samples in the email invoice template gallery).
Option Explicit Public Sub NewSaveToDBProc() If Range("oknWhoEmail").Value = "" Then MsgBox "Please enter email address in the 'Bill To' section.", vbExclamation + vbOKOnly, "Save Invoice" Exit Sub End If UISClickProc ("oknCmdSave") End Sub
Now when you click the "Save To DB" button to save an invoice, your own macro code will check if the email address field is empty. If so, it will refuses to save the invoice; otherwise, the invoice will be saved normally.
"UISClickProc" is a procedure provided by "UniformInvoiceSoftwareHelper" that is referenced to by using the "References - VBA Project" dialog box. In your macro code you call this procedure, and provide the button name as the argument to ask Uniform Invoice Software to perform the specified action.
You can provide any button name as the argument provided to "UISClickProc" procedure. To find the button name, first switch your template into design mode, and then click the button, the name box on the left-side of the formula shows the button name.
By calling "UISClickProc" from your own macro code, you can customize Uniform Invoice Software deeply in the way you like to meet your own business requirements.
Like other form designs here on InvoicingTemplate.com, Advanced Invoicing Format - Email Is Required Before Saving Invoice 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.
|Name||Advanced Invoicing Sample - Email Is Required Before Saving Invoice|
|Category||Sales Invoice Template|
|Release Date||Tuesday, November 22, 2016|
|Format (XLS or XLSX)||.xlsm|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||18.00|
|Printable with Papaer Size / Orientation||A4 (210 mm x 297 mm) - Portrait|
|Default Margins (Points)|
As a business document, an invoice sent by a business to a client to denote an obligation to pay for goods or services. One of the most important fields is the total amount to pay. This sample invoicing template shows you how to show the invoiced total in English words.
While most templates here on InvoicingTemplate.com are ".xlsx" and ".xls" formats, Uniform Invoice Software does work with macro-enabled invoice templates. This sample introduces the steps to use ".xlsm" workbooks and templates.
In most business situations the quantity numbers on an invoice are not addable - for example, if you are invoicing for both goods sold and service rendered. But there are cases where you want to add up quantities on an invoice and show the sum on the sales report.
Do you like New York, the state in the northeastern United States? You can even add it to your invoices and bills! This free downloadable invoicing template for Microsoft Excel (".xlsx" format) provides a sample on how to add a watermark of New York.
Download this free simple VAT invoice template in Excel format for invoicing in Euros. This design has a similar layout as the German version. The differences are that all labels are in English, and it shows the Euro symbol on cells, and also has a Euro watermark on the form.
As one of the member countries of the EU (European Union), the rules on German VAT registrations, returns and compliance are based on European Union EU VAT Directives which German has transposed into its VAT Act. This free invoicing sample in Excel and PDF format follows the German VAT compliance rules. It charges MwSt VAT tax at 19% by default.
The invoice template is designed for book wholesaler, publisher or store. It calculates discounts on each product as they are entered on an invoice, by using Excel formulas. Besides wholesale, it also allows applying discounts to retail customers when you invoice them.
This invoicing format is basically the default template shipped with Uniform Invoice Software (UIS), but with the "Taxable" boxes removed and an image of furniture and appliances on it. This sample template is suitable for stores and manufacturers that operate as a retailer or wholesaler.
This basic sales invoicing sample has an abstract blue-violet gradient painting in the background that looks like brushed with a liquid. This design sample also has the stripes background on the detail section removed.