UniformSoftware main content

Vehicle Rental and Travel

Template#: c5117

Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
434 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.

Screenshot

The screen shot for Vehicle Rental and Travel

Detail

Although it is not common, there are business situations that require the customer's name to be included on each invoiced item. This travel invoice template demonstrates how to copy a field value from the invoice header section to the detail section.

This template is suitable for travel businesses. It has the summary section moved to the top of the form and also has several custom fields for vehicle rental and travel, including "Vehicle Number", "Vehicle Type", "Discount", and two custom columns in the detail section, including "Date From" and "Date To".

Related templates:

In this sample, we copy the customer name from the "Bill To" section so that it is stored along with each invoiced item in the "InvBdy" database table.

To do this, a custom field "CustomerName" is added to the "InvBdy" database table.

Here are the brief steps to update the sheet to copy the customer name values:

  1. Find an empty column on the sheet. In this case, we chose X20:X41.
  2. Name the cells oknCustomerName_1, ... oknCustomerName_20.
  3. Assign Excel formulas to these cells. If the description is filled, copy the customer's name into the cells from the "Bill To" section. The formula looks like this:

    =IF(oknProductName_1="","",oknWhoName)

That's it! Combining custom fields and Excel formulas, we implemented a very special feature that could hardly be done without using Microsoft Excel.

Format and Specification

Template#c5117
Belongs to

Service

Format (XLS or XLSX).xlsx
Columns5
Lines22
Line Height (Points)15.75
Print Area$H$3:$P$43
Papaer OrientationPortrait
Default Margins (Points)
Left43.20
Right42.48
Top65.52
Bottom72.00
PriceFree