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 is a variant of Music Store Invoicing Form (Retail) (c5010). It differs from the original version in that this form includes a new custom field, Discount. It enables you to apply discounts to wholesale clients.
If you want to set the default Discount Rate for each customer, simply add the Discount Rate custom field to the Customer database table.
The Excel formula for the discount amount cell is as follows:
The formula for the "Total" cell is also updated to use the discounted amount:
=ROUND(oknSubTotal -oknDiscountAmount + oknShippingCost + IF(oknTaxType=0,0,IF(oknTaxType=1,oknTax1,oknTax1+oknTax2)),2)
Format and Specification
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||24.75|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|