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 designed for specialists in lamps, bulbs, and tubes for many hi-tech and specialized applications.
This template is designed with a UK business in mind, so the layout meets the requirements of a UK VAT invoice. For example, below your business detail section, a "VAT Registration #" label was added.
This template is designed for A4 paper in landscape orientation.
The "Due Date" field has an Excel formula assigned:
=IF(oknPaymentTerm="Net 30", DATE(YEAR (oknInvoiceDate), MONTH (oknInvoiceDate) +2,0), oknInvoiceDate )
This formula means that if "oknPaymentTerm" equals "Net 30", the "Due Date" will be the end date of the next month to the invoice date; giving any other value to "oknPaymentTerm" causes the "Due Date" to be the invoice date. The "oknPaymentTerm" cell in the above formula is placed outside the printable area.
This sample uses a number of custom fields, such as "Order Received Date", "Weight", "Packages", and a custom column on the detail section "SC" (Support Code).
Format and Specification
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||15.00|
|Papaer Size / Orientation||Landscape|
|Default Margins (Points)|