| Name |
C7-003 |
|
| Category |
7-Column Invoice Template |
| Size |
131 KB |
| Download |
|
| Description |
The invoice template is for book wholesaler, publisher or store. It can calculate discounts on each product as they are entered on an invoice. Besides wholesale, it also allows applying discounts to retail customers when you invoice them.
Discounts could vary by product. Some invoices may have products at 40% discounts, others at 50%, for example.
|
| Detail |
In order to implement the feature required with this invoice template, the template uses 3 custom fields (custom columns) on the invoice body.
| Field name |
Field type |
Note |
| Disc |
Decimal (8,6) |
Discount, a percentage value shown on invoice body. This custom field is also added to Product database table so that you can define default discount for each product which is loaded whenever you pick up a product.
|
| UnitCost |
Decimal (15,6) |
The applied price for the customer.
On invoice body, the invoice template uses the following formula to calculate UnitCost:
=oknPrice_?*(1-oknDisc_?)
Where "?" is a line number, ranging from 1 to 30.
|
| ExtRetail |
Decimal (15,6) |
ExtRetail is calculated using the following formula:
=ROUND(oknPrice_?*oknQuantity_?,2)
|
On the bottom of the invoice form, there are also 2 custom fields that are labeled TOTAL QUANTITY and TOTAL EXT. RETAIL. These custom fields are defined in the InvHdr (Invoice Header) database table, and are named TotalQuantity and TotalExtRetail, respectively.
|
| Requirements |
This template uses custom fields. It requires Platinum/Pro/Enterprise editions of Excel Invoice Manager |
| Notes |
- You have to install Excel Invoice Manager, the billing software and invoicing software based on Excel invoice templates, in order to run the templates in the member area.
- To download the Excel template, first login using your e-mail and password.
- After downloading, double click to open the template. The new invoice template will find Excel Invoice Manager and work with it.
- To report a broken link, please click here.
|
|
