| Description |
This invoice template is for the companies or organizations who offer parenting services. As compared to the default/standard invoice template, the "Ship To" section is removed, and a new field, Date Of Birth, is added to the Bill To section, with witch you can record the birth date of a child. There are also a number of custom fields for the other customer-related information, such as Mother's Name, Mother's Profession, Mother's Mobile, etc., are added outside the Print_Area. On the invoice body section, Quantity and Price are moved out of the Print_Area, and two new columns, date and Fee, are added.
|
| Detail |
As a parenting service company or organization it is necessary to record detailed child information on their invoices, in additional to those default fields provided by Excel Invoice Manager. Here are the custom fields added to the database.
| Table name |
Field name |
Field type |
Note |
| Customer |
DOB |
date |
Date of birth |
| Customer |
DOE |
date |
|
| Customer |
ReferralSource |
text (255) |
Referral source |
| Customer |
School |
text (100) |
|
| Customer |
Mother |
text (60) |
Mother's name |
| Customer |
MotherProfession |
text (60) |
Mother's profession |
| Customer |
MotherMobile |
text (60) |
Mother's mobile |
| Customer |
Father |
text (60) |
Father's name |
| Customer |
FatherProfession |
text (60) |
Father's profession |
| Customer |
FatherMobile |
text (60) |
Father's mobile |
| Customer |
Sibling1 |
text (100) |
|
| Customer |
Sibling2 |
text (100) |
|
| Customer |
Sibling3 |
text (100) |
|
| Customer |
Sibling4 |
text (100) |
|
| InvHdr (Invoice Header) |
DOB |
date |
Date of birth |
| InvBdy (Invoice Body) |
ItemDate |
date |
Date of the invoicing item |
For a detailed document on custom fields please see Custom Fields. A step by step tutorial can be found here.
|
