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 itemizes "service" and "expense" in two separate sections. Each section has a different tax.
It has 18 lines in the detail section, but these lines are grouped into two sections: the "Services" section and the "Expenses" section.
To make this template work with our invoicing app, the leftmost column on the printable area was a custom field named "ItemLine", which was continuously named from "oknItemLine_1" to "oknItemLine_18". The other columns, such as "DATE", "DETAILS", and "AMOUNT", have an interruption in their names. For example, "oknItemDate_1" to "oknItemDate_6" are put into the same column; "oknItemDate_7" to "oknItemDate_12" are put into another column outside the printable area; and "oknItemDate_13" to "oknItemDate_18" are put into the same column as "oknItemDate_1" to "oknItemDate_6". This is necessary because the space for "oknItemDate_7" to "oknItemDate_12" is used by the tax and amount cells.
"Tax 1" is applied to the "Service" section, and "Tax 2" is applied to the "Expense" section. All the tax calculation formulas are modified according to this design.
The two custom fields "Service Amount" and "Expense Amount" calculate the sum amount of each section. These two fields are also added to the "Sales Report", namely "oknRsServiceAmount" and "oknRsExpenseAmount".
Format and Specification
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||18.00|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|