BoostExcel main content

Form with Product Category

Template#: c5008



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.
334 KBDownload

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


The screen shot for Form with Product Category


"Product Category" is a standard field defined in the Product database table but not added to the "InvBdy" database table. So when you create an invoice with our invoicing app, the category information is not loaded along with product data and thus not saved along with other details.

However, the support for custom fields makes overcoming this limitation easy and quick. What you need to do is add the custom field "Product Category" to the "InvBdy" database table and then name a column of cells where you want to display the category. In this example, we don't want to show product categories on printed copies, so the product category column is placed outside the printable area.

Format and Specification

Belongs to
Format (XLS or XLSX).xlsx
Line Height (Points)18.00
Print Area$F$3:$N$45
Papaer OrientationPortrait
Default Margins (Points)


Sales Invoice Template with Discount Amount Column Thumbnail
Sample Sales Invoice Template: Using Line Number Instead of Item# Thumbnail
Simple Sales Invoicing Sample Thumbnail
Bill of Sales Template Thumbnail
General Purchase Invoice Template (Sales, One Tax) Thumbnail