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:
This form is a variant of the Basic Sales Invoice Template (Light Blue) (c3001). It has an abstract blue-violet gradient painting in the background that looks like it was brushed with liquid.
The itemized detail section features 3 columns: "#", "Description", and "Amount". This "#" column is a line number column, but not the "Item#" or "Product ID" column as found in many other templates. The value of the "#" column is filled automatically using an Excel formula like this:
=IF ( oknLineTotal_1=0,0,1)
So when you fill in an item with the "amount" (field name "oknLinetotal_?") value, the "#" column is filled with a line number like "1, 2, 3..." etc.
The "Product ID" column is still in the template but is placed on column A (ranging from A20 to A31), which is outside the printable section of the worksheet. This layout design allows you to have more space left for the "Description" column while still being able to use the "Product ID" column to fill in items quickly by entering the shortcut code of a product (such as SKU# or barcode numbers read by a scanner).
The "Amount" column is manually editable. This is archived by removing all the formulas from the column.
Suggested by one of our app users who is a painter and likes to make everything different, this template may not be your favorite. Don't worry, we've got hundreds of original templates for you to choose from!
Format and Specification
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||19.50|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|