Please
refer to the FAQ
section for troubleshooting
problems.
How
do I handle discounts?
To
handle discount for certain product,
insert an extra line for the product
in the inventory sheet with
different Product_id and mention in
the description that the price is
the discounted price, type in then
the new product_id in the invoice
sheet and the discounted price will
be imported automatically along with
the new description.
Example:
Printer ABC is at $100 and you want
to invoice it for 20% discount
In
the inventory sheet insert the
following 2 lines
|
Product_id |
Description |
Price |
|
|
P_ABC |
Printer
ABC |
$100 |
|
|
P_ABC_D |
Printer
ABC at 20% Discount |
$80 |
|
Now,
type in the product_id (P_ABC_D) in
the invoice sheet to use the
discounted price or (P_ABC) to use
the regular price
Can
I add more columns to the Inventory
sheet?
You
can add as many column you want PAST
the "Unit Price" Column,
do not add any one before the
"Unit Price" since the
invoice sheet will refer to them by
location to import information.
Can
I add more column to the Contacts
sheet?
You
can add as many column you want PAST
the "E-mail" Column, do
not add any one before the
"e-mail" column since the
invoice sheet will refer to them by
location to import information.
How
do I handle an item that is not in
the Invoice Sheet like "Order
No." ?
You
can substitute any item you do not
want in the invoice sheet by the new
one. The database does not store
item names ( every thing in the blue
cells). The database only stores row
data (Cells below the blue ones)
How
do I print a sheet in color?
To
print in color, unlock the sheet
using the button "Unlock this
sheet", and from the main menu
click on "File", then
"Page Setup", then click
on the tab "Sheet", then
finally uncheck the option
"Black & White"
How
do I hide a column in one of the
reports?
Simply
select the column or one cell of the
column, then from the main menu go
to Format, then Columns, then hide.
(Do not delete or remove the column)
How
do I create add-hoc reports?
The
database created is Microsoft Access
database, if you have Microsoft
access you can open the database and
perform add-hoc query and generate
reports.
