Borneosoft Sales Management
1. Introduction
 |
| Figure 1.1. Automatically Generated
Quotation |
Borneosoft Sales Management provides
facility for you to record all stages of sales. Borneosoft Sales
Management is tightly integrated with Contact and Calendar Management
making it easy to use. Coupled with Product Management, you can have
the quotation generated automatically for you.
You start the sales stage by creating
lead and adding contacts to it. You can add related events or tasks to
lead. This helps you to easily find events (meetings) or tasks that
are related to specific lead. The lead and associated contacts, events
and tasks tracks all activities you have made or plan to make for the
specific lead. This ensures that sales efforts are not duplicated,
reducing the risk of irritating your customers. You can also rate your
lead into three different rating: hot, warm and cold. This helps you
to concentrate your sales efforts to those that have higher chance to
ends with successful sales.
You should qualify your leads at the
appropriate time by setting the status from Prospecting to Qualified or Disqualified. You can then create
opportunities from the qualified leads. All contacts, events and tasks
related to the lead will be retained in the newly created opportunity.
In the opportunity, you can add products and set the sales stage. Each
sales stage has a corresponding probability that the sales will be
won. The estimated revenue for the opportunity is calculated as the
opportunity sales stage probability multiplied with expected revenue.
You can enter the expected revenue or let it be calculated from the
included products.
The Product Management provides
facility for you to enter product information such as availability,
pricing and its adjustment (markup, margin, or discount) and product
suppliera and manufacturer. You can also set multi-tier pricing where
the product price is determined based on the amount. Different amount
has different price. The product information is used to generate
quotation automatically.
|
2. Sales Lead
 |
| Figure 2.1. Blank Lead Details |
There are two ways sales data can be
entered into the application. It can be started by creating leads or
by creating opportunities directly.
The lead captures information about the
customers that helps to focus to sales with high chance of success.
The lead also concentrates the information such as contacts, events,
tasks, notes and documents for easy access.
A lead can be converted to an
opportunity when it is qualified and products can be added to the
opportunity. An opportunity brings more focus and attention on the
customer needs. Products can be added to the opportunity and quotation
can readily be generated as and when it is needed. Opportunities also
provides performance measure for each sales. They can give forecast on
the sales revenue.
2.1. Creating Lead
- Click the Lead folder or any of its sub-folders where the
new lead will be put into.
- Click the 'New' button at the toolbar, or click the menu:
'Edit', 'New Item', or click the menu: 'File', 'Create New', 'Lead'.
- An empty lead details dialog box will open (Figure
2.1: Blank Lead Details).
- Click 'Save' when you finish entering the details.
|
A new lead will start with 'Open' case.
The other fields are selectable from a list of options. The Lead
predefined fields are:
2.1.1. Lead Status
The possible values are:
- Prospecting
- Qualified
- Disqualified
It can be left empty if progress has not
been made. As soon as any activity has been made such as meeting, making
phone calls, etc., the status should be changed to 'Prospecting'. The
status can be lifted to 'Qualified' when the lead is ready to be
converted to an opportunity. If there is no further prospect in the
lead, the status should be changed to 'Disqualified'.
Changing status will not make the lead
case to be closed. The status can still be changed. To close the lead,
either the lead is converted to an opportunity or the case is changed to
'Closed'.
2.1.2. Lead Rating
The possible values are:
- Hot
- Warm
- Cold
It can be left empty if progress has not
been made. It is good practice to set the lead rating. Effort can be
concentrated to leads which are 'Hot' or 'Warm'.
2.1.3. Industry Type
The possible values are:
- Advertising/Marketing/PR
- Aerospace
- Agriculture/Forestry
- Automotive
- Business Services & Consulting
- Chemicals
- Computers/Electronics
- Construction/Real Estate
- Consumer Goods
- Education
- Energy/Mining
- Finance/Insurance
- Food, Drinks & Services
- Government/Military/Public Services
- Hospitality/Hotel/Recreation
- Information/Comm. Technology
- Manufacturing
- Media/Publishing/Entertainment
- Medical & Health Services
- Non Profit Organization
- Pharmaceuticals
- Retail
- Sport
- Travel/Transportation/Logistic
2.1.4. Lead Source
The possible values are:
- Advertisement
- Call Center Inquiries
- Cold Call
- Commercial Database
- Conference/Seminar
- Direct Mail
- E-Newsletter
- Email
- Existing Customer
- Partner
- Public Relations
- Referral (External)
- Referral (Internal)
- Search Engine
- Virtual/Tradeshow
- Website Request
- Website Visit
- Word of mouth
- Yellow Page
2.2. Adding Contacts to Lead
Contacts can be added to a lead by
creating new contacts or selecting existing contacts. The relationship
between contact and lead can be selected from a predefined options:
 |
| Figure 2.2. Adding New Contact to
Lead |
- Contact Person
- Decision Maker
- Project Manager
- Executive
- Sponsor
- Employee
- Reviewer
- Supplier
- Partner
- Sub Contractor
- Buyer
- End User
- Test User
- Tech. Team Member
- Advisor
|
2.2.1. Adding Contact to Lead by Creating New
Contact
 |
| Figure 2.3. Adding Existing Contacts
to Lead |
- Click the Contact at the related items title bar.
- Click 'New' button at the related item toolbar. A dialog box
will appear to enter contact details.
- Enter the contact details. An additional field is added to
determine how the contact is related to the lead (Figure 2.2:
Adding New Contact to Lead).
- Click 'Save' button at the toolbar. The new contact is saved
into contact folder and at the same time it will be added to the
lead.
|
2.2.2. Adding Contacts to Lead by Selecting Existing
Contacts
 |
| Figure 2.4. Completed Lead Details |
- Click the Contact at the related items title bar.
- Click 'Select' button (
) at the related item toolbar. A dialog box will
appear to select existing contacts (Figure
2.3: Adding Existing Contacts to Lead). Those contacts that have
already been added to the lead have ticks ( )
on their row.
- Select how the contacts are related to the lead.
- Check the checkboxes of the contacts that will be added.
- Click 'Accept Selection' button (
) at the toolbar. The selected contacts will be added
to the lead (Figure 2.4: Completed
Lead Details).
|
2.3. Adding Events and Tasks to Lead
Adding events and tasks to lead is
similar to adding contacts to lead. However, there is no relation field
that needs to be defined.
2.4. Adding Documents to Lead
Adding documents to lead is similar to
adding contacts to lead. The relationship between document and lead can
be selected from a predefined options:
- Miscellaneous
- Demo
- Executable
- Drawing
- Supporting Document
- Case Study
- Howto
- Reference
- User Guide
- Manual
- Brochure
- Datasheet
- Quotation
- Purchase Order
2.5. Adding Notes to Lead
 |
| Figure 2.5. Blank Notes |
Notes can be added to lead in similar
way as adding contacts to lead. New notes can be created by using the
provided editor ( Figure 2.5:
Blank Notes ).
|
2.6. Creating Opportunity from Lead
When a new opportunity is created from a
lead, the lead case is automatically closed and the lead cannot be
further modified. Closed lead can be find in the 'Closed' folder. All
relationship between related items (contacts, events, and tasks) to the
lead are retained in the new opportunity. However, the relationship
between notes and document to the lead are not brought over to the new
opportunity.
To create an opportunity from lead:
- Click 'Create Opportunity' button at the toolbar of the Lead
Details. An alert dialog box with message to select an Account where
the new opportunity should be put into, will appear (Figure 2.6:
Account Alert for New Opportunity).
- Click 'OK'.
- An Account selection dialog box will appear (Figure
2.7: Selecting an Account for The New Opportunity). Select the account
and click 'Accept Selection' button at the toolbar. If necessary, new
account can be created by clicking 'New' button at the toolbar.
- The lead is closed and it is not editable (). Its status is
set 'Qualified'.
- Click the new Opportunity link (see Figure
2.8: Closed Lead after Creating New Opportunity).
- The new Opportunity Details will appear (Figure
2.9: The New Opportunity Created from The Lead). In the opportunity
details, a link back to the lead, where the opportunity is created
from, is provided. The new opportunity rating and source follow the
lead rating and source respectively. The new opportunity sales stage is
automatically set to 'Qualified'. The contacts, events and tasks, which
are related to the lead, are related to the new opportunity too. In
effect, the continuity of the information is maintained.
 |
| Figure 2.6. Account Alert for New
Opportunity |
 |
| Figure 2.7. Selecting an Account for
The New Opportunity |
|
 |
| Figure 2.8. Closed Lead after
Creating New Opportunity |
 |
| Figure 2.9. The New Opportunity
Created from The Lead |
|
2.7. Navigating Lead List
 |
| Figure 2.10. Expanded Lead List |
The contacts that are related to lead
are shown together with lead information in the Lead List View ( Figure
2.10: Expanded Lead List View).
The Contacts' columns are:
- Contact
Contact's name
- As
How the contact is related to the lead
- Company
Contact's company
- Work
Contact's business telephone
- Email
Contact's email
|
 |
| Figure 2.11. Collapsed Lead List |
The Leads' columns are Lead (lead's
name) and Rating (lead's rating).
The contacts' columns can be made
non-visible by clicking 'Collapse' button (  ) at the toolbar, see Figure
2.10: Expanded Lead List View . The 'Collapse' button will change to
'Expand'. Clicking the 'Expand' button (  ) will make the contacts' columns visible
again, see Figure
2.11: Collapsed Lead List View.
When the lead list is expanded, the
same lead is grouped with the same color. In expanded list view, the
paging contains the number of contacts in all leads as well as the
number of unique leads. In Figure
10: Expanded Lead List View , the paging is 1-50 of 4174 [4 of 298
Leads]. It means the list shows the first 50 contacts from a total of
4174 contacts and the first 4 unique leads from a total of 298 unique
leads.
|
2.7.1. Lead Search Fields
Search field names for lead are:
- importance
Possible values: "Most Important", "Very Important", "Important", "Less
Important", "Not Important". To retrieve only leads with the specific
importance, the search value must be surrounded with double quotes, for
example, importance:"Most Important".
- description
- leadname
- industrytype
See Industry Type for possible values.
- source
See Lead Source for possible values.
- rating
Possible values: Hot, Warm, Cold
- leadstatus
Possible values: Prospecting, Qualified, Disqualified
- contactname
The names of the contacts related to the lead
- contactas
The relationship between the contacts and the lead
- businesstelephone
The business telephone of the contacts related to the lead
- companyname
The company name of the contacts related to the lead
- email
The email of the contacts related to the lead
 |
| Figure 2.12. Searching Decision
Makers in All Leads |
For example, to search all decision
makers of the leads, use search phrase: contactas:"Decision Maker".
The search value must be surrounded with double quotes to indicate
that the search has to be done in exact match. For this example, there
is 304 contacts who are decision makers in the leads, see Figure
2.12: Searching Decision Makers in All Leads.
|
 |
Figure 2.13. Searching Decision
Makers
in Company Wilkinson |
To filter further, additional search
phrase can be added. For example, to search the decision maker of the
company Wilkinson, use search phrase: +contactas:"Decision Maker"
+companyname:Wilkinson, see Figure
2.13: Searching Decision Makers in Company Wilkinson. In this example,
there are two decision makers from company Wilkinson Inc. They are
Intezar Wearne and Capraz Avan. Intezar is involved in two leads and
Capraz is involved in one lead. Only lead that involves Intezar on the
first row, is a warm lead.
|
2.8. Lead Charts
Charts about leads can be viewed by
clicking the Chart tab and select the 'Chart Type'.
2.8.1. #Converted Lead By Month
This chart displays the number of leads
being converted for each selected month. The selection on intervals for
the '#Converted Lead By Month' are:
- Current Fiscal Year
- Last Fiscal Year
- Next Fiscal Year
- Current Fiscal Year (Quarterly)
- Last Fiscal Year (Quarterly)
- Next Fiscal Year (Quarterly)
- Last 5 Fiscal Year
- Next 5 Fiscal Year
- Current 5 Fiscal Year (Quarterly)
- Next 5 Fiscal Year (Quarterly)
- Current Fiscal Quarter
- Last Fiscal Quarter
- Next Fiscal Quarter
- Last 4 Fiscal Quarter
- Next 4 Fiscal Quarter
- Other Interval
 |
| Figure 2.14. No of Converted Leads by
Month |
The start and end of the fiscal year
are determined by the country which has been selected in the
organization details. For example, if the country selected is United
States, the fiscal year is from October 1 st to September
30 th . If the country selected is Australia, the fiscal
year is from 1 July to 30 June.
Example of '#Converted Lead By Month'
for the US current fiscal year, October 1, 2008 to September 30, 2009;
assuming current date is August 11, 2009 is shown in Figure 2.14:
No of Converted Leads by Month .
|
2.8.2. #Days for each Lead Status
This chart displays the sum of the number
of days of all leads that stay in their status since their creation or
since the status being updated. For example, assuming current date is
August 11, 2009. Lead A has its status 'Qualified' on August 10, 2009.
Lead B has its status 'Prospecting' on August 9, 2009. The '#Days of
each Lead Status (bar chart)' will show two vertical bars. The first bar
shows that #Days for Qualified status is 2 (August 9 to August 11) and
the second bar shows that #Days for Prospecting status is 1 (August 10
to August 11).
Leads, which are closed or move to trash
bin, do not contribute to the chart. When all leads are closed, the
chart should show 0 for #Days for all lead status (Prospecting,
Qualified and Disqualified).
 |
Figure 2.15. No of Days
for Each Lead Status As Bar Chart |
 |
Figure 2.16. Percentage of Days
for Each Lead Status As Pie Chart |
|
2.8.3. #Lead for each Industry Type
This chart displays the number of Leads
for each industry type. Leads which are closed or in the trash folder
are excluded from the chart. Example of the bar chart is shown in
Figure
2.17: No of Leads for Each Industry Type As Bar Chart and the pie chart
is shown in
Figure
2.18: Percentage of Leads for Each Industry Type As Pie Chart.
 |
Figure 2.17. No of Leads
for Each Industry Type As Bar Chart |
 |
Figure 2.18. Percentage of Leads
for Each Industry Type As Pie Chart |
|
2.8.4. #Lead for each Source
This chart interpretation is the same as
the '#Lead for each Industry Type' except that the #Lead is counted
against the lead source instead of lead industry type. Example of the
bar chart is shown in
Figure
2.19: No of Leads for Each Source As Bar Chart and the pie chart is
shown in
Figure
2.20: Percentage of Leads for Each Source As Pie Chart.
 |
Figure 2.19. No of Leads
for Each Source As Bar Chart |
 |
Figure 2.20. Percentage of Leads
for Each Source As Pie Chart |
|
2.8.5. #Lead for each Rating
This chart interpretation is the same as
the '#Lead for each Industry Type' except that the #Lead is counted
against the lead rating instead of lead industry type. Example of the
bar chart is shown in
Figure
2.21: No of Leads for Each Rating As Bar Chart and the pie chart is
shown in
Figure
2.22: Percentage of Leads for Each Rating As Pie Chart.
 |
| Figure 2.21. No of Leads for Each
Rating As Bar Chart |
 |
| Figure 2.22. Percentage of Leads for
Each Rating As Pie Chart |
|
2.8.6. #Lead for each Status
This chart interpretation is the same as
the '#Lead for each Industry Type' except that the #Lead is counted
against the lead status instead of lead industry type. Example of the
bar chart is shown in
Figure
2.23: No of Leads for Each Status As Bar Chart and the pie chart is
shown in
Figure
2.24: Percentage of Leads for Each Status As Pie Chart.
 |
| Figure 2.23. No of Leads for Each
Status As Bar Chart |
 |
| Figure 2.24. Percentage of Leads for
Each Status As Pie Chart |
|
2.8.7. #Lead for each Status by Month
This chart displays the number of leads
for each status for each selected month. If the selected months contains
the current month, the values for the current month in '#Lead for each
Status by Month' is the same as those values in '#Lead for each Status'.
'#Lead for each Status' takes a snapshot at any point of time, where
'#Lead for each Status by Month' takes snapshot month by month.
Example of '#Lead for each Status By
Month' for the US current fiscal year, October 1, 2008 to September 30,
2009; assuming current date is August 11, 2009 is shown in
Figure
2.25: No of Leads for Each Status By Month .
2.8.8. #Lead for each Status by Day
The interpretation of this chart is the
same that of chart '#Lead for each Status by Month' except that the
interval is day by day.
Example of '#Lead for each Status By Day'
for the US current fiscal year, October 1, 2008 to September 30, 2009;
assuming current date is August 11, 2009, is shown in
Figure
2.26: No of Leads for Each Status By Day.
 |
| Figure 2.25. No of Leads for Each
Status By Month |
 |
| Figure 2.26. No of Leads for Each
Status By Day |
|
3. Sales Product
Product information is needed when an
opportunity is created. Product data includes pricing and its
availability.
3.1. Creating Product
- Click the Product folder or any of its sub-folders where the
new product will be put into.
- Click the 'New' button at the toolbar, or click the menu:
'Edit', 'New Item', or click the menu: 'File', 'Create New', 'Product'.
- An empty product details dialog box will open (Figure
3.1: Blank Product Details).
- Click 'Save' when you finish entering the details.
3.2. Product Fields
 |
| Figure 3.1. Blank Product Details |
The fields that need to be entered in
product details are:
- Product Code
- Product Name
- Unit
Possible values:
- minute
- hour
- day
- week
- month
- year
- meter
- mile
- kilogram
- box
- package
- incident
- call
- license
- user
- seat
- processor
- gigabyte
- megabyte
- kilobyte
- User is allowed to adjust pricing
If this option is enabled, the normal user (not superuser) will be
able to change the product pricing when the product is added to the
opportunity.
- Single Unit Price
The price of the product for a single unit.
- Tiered* Unit Price
The price of the product at requested amount or at the minimum amount
- Use tiered unit price to calculate selling price
If this option is enabled, the requested amount will determine the
tiered unit price that eventually determines the selling price.
- Single Unit Cost
The cost of the product for a single unit.
- Tiered* Unit Cost
The cost of the product at requested amount or at the minimum amount
- Use tiered unit cost to calculate selling price.
If this option enabled, the requested amount will determine the
tiered unit cost that eventually determines the selling price.
- Selling Price Adjustment
Possible values:
- Fixed Price
Selling Price equals to the value the user enters into the 'Selling
Price' input field.
- At Unit Price
Selling Price = Single Unit Price
or
Selling Price = Tiered Unit Price,
if 'Use tiered unit price to calculate Selling Price' is enabled.
- At Unit Cost
Selling Price = Single Unit Cost
or
Selling Price = Tiered Unit Cost,
if 'Use tiered unit cost to calculate Selling Price' is enabled.
- Margin (Currency symbol)
If United States is selected as the country of the organization, the
currency symbol is USD. The displayed option is 'Margin USD'.
The amount, in this case in USD, needs to be entered in the input
field after the option 'Margin USD'.
Selling Price = Single Unit Cost + Margin USD
or
Selling Price = Tiered Unit Cost + Margin USD,
if 'Use tiered unit cost to calculate Selling Price' is enabled.
- Margin %
It is usually called 'Gross Profit Margin'. The percentage needs to
be entered in the input field after the option 'Margin %'.
'Margin %' = 100 * (Selling Price – Unit Cost)/Selling Price.
Selling Price = Single Unit Cost / (1 – 'Margin %'/100)
or
Selling Price = Tiered Unit Cost / (1 – 'Margin %'/100),
if 'Use tiered unit cost to calculate Selling Price' is enabled.
- Discount (Currency symbol)
If United States is selected as the country of the organization, the
currency symbol is USD. The displayed option is 'Discount USD'.
The amount, in this case in USD, needs to be entered in the input
field after the option 'Discount USD'.
Selling Price = Single Unit Price – Discount USD
or
Selling Price = Tiered Unit Price – Discount USD,
if 'Use tiered unit price to calculate Selling Price' is enabled.
- Discount %
The percentage needs to be entered in the input field after the
option 'Discount %'.
Selling Price = Single Unit Price * (1 – 'Discount %'/100)
or
Selling Price = Tiered Unit Price * (1 – 'Discount %'/100),
if 'Use tiered unit price to calculate Selling Price' is enabled.
- Markup (Currency symbol)
If United States is selected as the country of the organization, the
currency symbol is USD. The displayed option is 'Markup USD'.
The amount, in this case in USD, needs to be entered in the input
field after the option 'Markup USD'.
Selling Price = Single Unit Cost + Markup USD
or
Selling Price = Tiered Unit Cost + Markup USD,
if 'Use tiered unit cost to calculate Selling Price' is enabled.
- Markup %
The percentage needs to be entered in the input field after the
option 'Markup %'.
Selling Price = Single Unit Cost * (1 + 'Markup %'/100)
or
Selling Price = Tiered Unit Cost * (1 + 'Markup %'/100),
if 'Use tiered unit cost to calculate Selling Price' is enabled.
- Selling Price
This input field is only editable when 'Selling Price Adjustment' is
set to 'Fixed Price'.
- No. of digits to the right of the decimal point for unit
price/unit cost
Possible values:
- #,###.
No decimal fraction
- #,###.0
1 decimal fraction
- #,###.00
2 decimal fraction. That
- #,###.000
3 decimal fraction. This is usually used in for parts that have unit
price/unit cost fraction of a cent.
- Rounding mode for unit price/unit cost
- Half Up
Rounding mode to round towards "nearest neighbor" unless
both neighbors are equidistant, in which case round up.
- Half Down
Rounding mode to round towards "nearest neighbor" unless
both neighbors are equidistant, in which case round down.
- Half Even
Rounding mode to round towards the "nearest neighbor"
unless both neighbors are equidistant, in which case, round towards
the even neighbor.
- Up
Rounding mode to round away from zero.
- Down
Rounding mode to round towards zero.
- Ceiling
Rounding mode to round towards positive infinity.
- Floor
Rounding mode to round towards negative infinity.
- Unit in Stock
Number of unit in stock.
- Available Unit
This is not editable. Its value is calculated automatically.
Available Unit = Unit in Stock – Total of Requested Amount in all
opportunities
- Supplier and Manufacturer (Optional)
The supplier and manufacturer need to be selected from existing
companies. To select the supplier or manufacturer, click the
'Select/Create Company' button ( ). A dialog box will appear to select the
company as supplier or manufacturer.
When 'Update Existing Supplier Detail' and/or 'Update Existing
Manufacturer Detail' are/is enabled, any changes made to the supplier
and/or manufacturer will be saved in the existing company details.
- Notes
|
3.3. Creating Tiered Unit Price/Unit Cost
 |
| Figure 3.2. Adding Price Tier |
- In the product details, click the 'Price Tier' or 'Cost
Tier' at the related items title bar.
- Click 'New' button (
) to add a new row to the list, see Figure
3.2: Adding Price Tier.
- Click the new row under the column 'Amount Up To'. Enter the
amount.
- Click the new row under the column 'Price'. Enter the price.
- Click 'Save' button (
) to save the changes.
|
 |
| Figure 3.3. Product Tiered Pricing |
Using Figure
3.2: Adding Price Tier as example, if the 'Use tiered unit price to
calculate selling price' is enabled, the 'Tiered Unit Price' will be
calculated automatically as 150. The tiered unit price will be
calculated from Price Tier using the lowest 'Amount Up To' ( Figure 3.3: Product
Tiered Pricing ).
|
3.4. Navigating Product List
 |
| Figure 3.4. Product List View |
An example of the product list view is
shown in Figure
3.4: Product List View. The product list consists of columns:
- Product Name
- Product Code
- Unit Name
- Whether the Unit Price is tiered
- Single Unit Price
- Tiered Unit Price (Volume based unit price)
- Whether the Unit Cost is tiered
- Single Unit Cost
- Tiered Unit Cost (Volume based unit cost)
- Selected Price Adjustment
- Adjustment value
- Selling Price
- Unit in Stock
- Available Unit
- Supplier Name
- Manufacturer Name
|
3.4.1. Product Search Fields
The product search field names are:
- importance
Possible values: "Most Important", "Very Important", "Important", "Less
Important", "Not Important". To retrieve only products with the
specific importance, the search value must be surrounded with double
quotes, for example, importance:"Most Important".
- description
- productcode
- productname
- unitprice
- unitprice:[0 TO 0]
- unitcost
- unitcost:[0 TO 0]
- volumeunitprice
- volumeunitprice:[0 TO 0]
- volumeunitcost
- volumeunitcost:[0 TO 0]
- amount
- amount:[0 TO 0]
- subtotal
- subtotal:[0 TO 0]
- adjustmentvalue
- adjustmentvalue:[0 TO 0]
- sellingprice
- sellingprice:[0 TO 0]
- availableunit
- availableunit:[0 TO 0]
- unitinstock
- unitinstock:[0 TO 0]
- priceadjustment
Possible values are:
- "Fixed Price"
- "At Unit Price"
- "At Unit Cost"
- "Margin USD", or other currency symbol
- "Margin %"
- "Discount USD", or other currency symbol
- "Discount %"
- "Markup US", or other currency symbol
- "Markup %"
- unit
- manufacturercompanyname
- manufactureraddressline
- manufacturercity
- manufacturerstate
- manufacturerus_state
- manufacturerzipcode
- manufacturercountry
- manufacturerbusinesstelephone
- manufacturerfax
- manufacturerwebsite
- suppliercompanyname
- supplieraddressline
- suppliercity
- supplierstate
- supplierus_state
- supplierzipcode
- suppliercountry
- supplierbusinesstelephone
- supplierfax
- supplierwebsite
4. Opportunity
Opportunity can be created from lead or
it can be entered manually. When it is created from a lead, the
contacts, events, and tasks which are related to the lead, will also be
related to the opportunity.
Opportunity concentrates the information
with the goal of closing the sales. Products can be added to an
opportunity. Pricing information can also be added to the product list
that is contained inside the opportunity. Other information such as the
companies that supply or manufacture the products, or competitor
companies can also be added to the opportunity.
There are few sales stages associated
with each opportunity. Each of the sales stage has a probability value
that indicates how close the sales is being successful with purchase
order being raised. The probability values are indicative only and they
can be modified if necessary. Although, it is advisable to leave the
values unmodified. They are (with probability value in bracket):
- Qualified (10%)
- Needs Assessment (20%)
- Solution Evaluation (30%)
- Proposal (50%)
- Purchasing Decision (70%)
- Refine Solution (80%)
- Verbal Agreement (90%)
- Purchase Order (100%)
- Lost (0%)
- Canceled (0%)
- Suspended (0%)
If the opportunity is created from a
lead, the initial sales stage is Qualified. Its rating and source will
be the same as those of the lead.
4.1. Creating Opportunity
 |
| Figure 4.1. Blank Opportunity Details |
- Click the Opportunity folder or any of its sub-folders where
the new opportunity will be put into.
- Click the 'New' button at the toolbar, or click the menu:
'Edit', 'New Item', or click the menu: 'File', 'Create New',
'Opportunity'.
- An empty opportunity details dialog box will open (Figure 4.1: Blank
Opportunity Details).
- Click 'Save' when you finish entering the details.
- A new opportunity will start with 'Open' case.
|
A new opportunity will start with 'Open'
case. The other fields are selectable from a list of options. The
Opportunity predefined fields are:
4.1.1. Opportunity Rating:
4.1.2. Opportunity Source
The possible values are:
- Advertisement
- Call Center Inquiries
- Cold Call
- Commercial Database
- Conference/Seminar
- Direct Mail
- E-Newsletter
- Email
- Existing Customer
- Partner
- Public Relations
- Referral (External)
- Referral (Internal)
- Search Engine
- Virtual/Tradeshow
- Website Request
- Website Visit
- Word of mouth
- Yellow Page
4.1.3. Opportunity Sales Stage:
- Qualified
- Needs Assessment
- Solution Evaluation
- Proposal
- Purchasing Decision
- Refine Solution
- Verbal Agreement
- Purchase Order
- Lost
- Canceled
- Suspended
When the opportunity sales stage is
selected, the probability will be updated automatically according to the
probability associated to the sales stage.
To determine the decimal fraction of the
the pricing of the products involved in the opportunity, the number of
digits to the right of the decimal point for currency can be selected.
The default follows the currency format of the country selected in the
organization preference. The possible values are:
- #,###.
No decimal fraction
- #,###.0
1 decimal fraction
- #,###.00
2 decimal fraction. That
- #,###.000
3 decimal fraction. This is usually used in for parts that have unit
price/unit cost fraction of a cent.
The default rounding mode used for price
calculation is Half Up. The possible values for rounding mode are:
- Half Up
Rounding mode to round towards "nearest neighbor" unless both
neighbors are equidistant, in which case round up.
- Half Down
Rounding mode to round towards "nearest neighbor" unless both
neighbors are equidistant, in which case round down.
- Half Even
Rounding mode to round towards the "nearest neighbor" unless
both neighbors are equidistant, in which case, round towards the even
neighbor.
- Up
Rounding mode to round away from zero.
- Down
Rounding mode to round towards zero.
- Ceiling
Rounding mode to round towards positive infinity.
- Floor
Rounding mode to round towards negative infinity.
Opportunity must be associated with an
account. You can select the existing account by clicking the icon next
to the Account (
Figure 4.1: Blank
Opportunity Details ).
Although it is not compulsory, start
dates needs to be entered when the opportunity is created. If it is not
known, estimated close date can be left empty. The actual close date
should be entered when the opportunity is not being pursued anymore,
either because the sales is won (purchase order being raised), lost, or
canceled.
Estimated Revenue is automatically
calculated by multiplying the expected revenue with the probability
value. Expected Revenue can be entered manually or it can be
automatically calculated from the included products by checking the
checkbox 'Calculate from included Products'. Actual Revenue can be
entered manually when the sales is won or it can be set automatically to
the estimated value when the probability is 100%, i.e., when the sales
is won.
4.2. Adding Contacts, Events, Tasks, Documents and
Notes
Adding contacts, events, tasks, documents
and notes to the opportunity is similar to adding them to the lead.
4.3. Adding Companies
Adding companies to opportunity is
similar to adding contacts to opportunity. The relationship between
company and opportunity can be selected from a predefined options:
- Competitor
- Supplier
- Partner
- Sub-Contractor
4.4. Adding Products to Opportunity by Selecting
Existing Products
 |
| Figure 4.2. Selecting Existing
Products |
- Click the Product at the related items title bar.
- Click 'Select' button (
) at the related item toolbar. A dialog box
will appear to select existing products (Figure 4.2:
Selecting Existing Products).
- Check the checkboxes of the products that will be added.
- Enter the amount needed in the amount input field at the
'Amount' column.
- Optionally, adjust the pricing if the price adjustment is
allowed for normal user.
- Click 'Accept Selection' button (
) at the toolbar. The selected products
will be added to the opportunity.
|
4.5. Creating Products from inside Opportunity
4.6. Price Adjustment
 |
| Figure 4.4. Product Price Adjustment |
Price adjustment can be done by
superuser. If the superuser enables 'User is allowed to adjust
pricing' checkbox, normal user can adjust the pricing while the user
adds product to the opportunity. The products that allow users to
change the products' pricing can be identified with their input field
having light green background ( Figure 4.4: Product
Price Adjustment ).
|
4.6.1. Price Adjustment while adding Product to
Opportunity
The pricing fields that can be modified
while the product being added are:
- Tiered Unit Price
Whether unit price is tiered. If enabled, the Tiered Unit Price will be
used. The price will depend on the amount requested. If there is no
amount requested, the unit price will be the price at the lowest
'Amount Up To' in the tiered pricing.
However, if the tiered pricing has not been set up, the product needs
to be added to the opportunity first, before the tiered pricing can be
entered.
- Single Unit Price
- Tiered Unit Cost
Whether unit cost is tiered. If enabled, the Tiered Unit Cost will be
used. The price will depend on the amount requested. If there is no
amount requested, the unit cost will be the price at the lowest 'Amount
Up To' in the tiered pricing.
However, if the tiered pricing has not been set up, the product needs
to be added to the opportunity first, before the tiered pricing can be
entered.
- Adjustment
Adjustment type, i.e., Fixed Price, At Unit Price, At Unit Cost, Margin
USD, Margin %, Discount USD, Discount %, Markup USD, or Markup %.
- Adjust By
The value of the adjustment
- Selling Price
It is editable when the adjustment is 'Fixed Price'.
- Amount
The amount requested.
When the pricing is changed some fields
are calculated automatically. The calculated fields are:
- Price (Tiered)
It is re-calculated when the tiered unit pricing is changed or the
amount changed.
- Cost (Tiered)
It is re-calculated when the tiered unit cost is changed or the amount
changed.
- Selling Price
It is re-calculated when any of the pricing variables are changed.
Except when the adjustment is 'Fixed Price', the selling price provides
input field for the user to enter the desired unit price.
- Sub Total
It is re-calculated by multiplying selling price with the amount
requested.
4.6.2. Working with Products inside Opportunity
 |
| Figure 4.7. Opportunity with Products |
An example where products have been
added to the opportunity is shown in Figure 4.7:
Opportunity with Products . The table cells with light green
background are editable. The product pricing can be edited directly in
the list:
- Click the 'Product' at the related items title bar.
- Click the input field with light green background, edit or
select the value.
- Click 'Save' button (
) at the toolbar.
|
 |
| Figure 4.8. Selecting Products for An
Opportunity |
Clicking the 'Select' button (  ) at the toolbar will open a products selection
window ( Figure
4.8: Selecting Products for An Opportunity ). The products that have
been selected are identified with green ticks.
|
 |
Figure 4.9. Added Product to an
Opportunity -
Users can Adjust Pricing |
The product pricing can also be edited
by opening up the product by selecting the product row and clicking
the 'View' button (  ) at the toolbar. The
details of the included product in the opportunity that allow the
users to change product pricing is shown in Figure
4.9: Added Product to an Opportunity - Users can Adjust Pricing.
|
4.7. Expected and Estimated Revenue Calculation
 |
Figure 4.11. Product Expected and
Estimated Revenue Automatic Calculation |
If the 'Calculate from included
Products' checkbox is enabled, the 'Expected Revenue' will be
calculated automatically every time products are added to the
opportunity. The expected revenue equals the sum of all sub totals of
the included products.
However, if it is preferred that the
expected revenue is entered manually, the 'Calculate from included
Products' checkbox must be disabled.
The 'Estimated Revenue' will be
calculated automatically from the 'Expected Revenue'. The estimated
revenue equals the expected revenue multiplied by the probability. In
this example ( Figure
4.11: Product Expected and Estimated Revenue Automatic Calculation ),
the probability is 10%, the expected revenue is USD 22,694.00, hence
the estimated revenue is USD 2,269.40 (22,694.00 x 10%).
|
4.8. Adding Contacts, Events, Tasks, Notes, and
Documents to Opportunity
The steps to add contacts, events, tasks,
notes, and documents to an opportunity is the same as the steps to add
them to a lead.
4.9. Adding Companies to Opportunity
 |
| Figure 4.12. Expanded Opportunity
List |
In addition to contacts, events, tasks,
notes and documents, companies can be added as related items to an
opportunity. The relationship of a company to opportunity can be one
of the following:
- Competitor
- Supplier
- Partner
- Sub Contractor
|
Clicking the 'Expand' or 'Collapse'
button (

) will expand or collapse the
opportunity list. The collapsed opportunity list consists of columns:
- Opportunity Name
- Opportunity's Sales Stage
- Opportunity's Expected Close Date
- Account Name
- Rating
In addition to the columns listed above,
the expanded opportunity list consists of columns:
- Contact Name
- How contact is associated to the opportunity
- Business/Work Telephone number
- Contact's Email
4.10.1. Opportunity Search Fields
Search fields names for opportunity are:
- importance
Possible values: "Most Important", "Very Important", "Important", "Less
Important", "Not Important". To retrieve only opportunities with the
specific importance, the search value must be surrounded with double
quotes, for example, importance:"Most Important".
- description
- opportunityname
- probability
- probability:[0 TO 0]
- estrevenue
Estimated Revenue. The search value must not contain any thousand
separator and must use dot (.) as the decimal separator. For example,
the search phrase to search USD 100,000.00 will be estrevenue:100000 or
estrevenue:100000.00.
- estrevenue:[0 TO 0]
Range search. For example, the search phrase to search estimated
revenue between USD 1,000,000.00 to 10,000,000.00 will be
estrevenue:[1000000 TO 10000000].
- exprevenue
Expected Revenue.
- exprevenue:[0 TO 0]
- actrevenue
- actrevenue:[0 TO 0]
- account
Account name.
- stage
Sales stage.
To retrieve specific sales stage, the search value must be surrounded
with double quotes, for example, stage:"Needs Assesment".
- source
Opportunity source.
It is the same as lead source.
- rating
Its possible values are:
- Hot
- Warm
- Cold
- contactname
Contact name.
- contactas
Association between contact and opportunity.
Its possible values are:
- Contact Person
- Decision Maker
- Project Manager
- Executive
- Sponsor
- Employee
- Reviewer
- Supplier
- Partner
- Sub Contractor
- Buyer
- End User
- Test User
- Tech. Team Member
- Advisor
- businesstelephone
Contact's business telephone.
- email
Contact's email
4.10.2. Searching Opportunity Start, Expected Close
and Actual Close Date
- startdate:yyyymmdd
This is used to search opportunities that start on specific date:
yyyy-mm-dd. For example, to search opportunities that start on March
31, 2009, use search phrase startdate:20090331.
- startdate:[yyyymmdd TO yyyymmdd]
This is used to search opportunities that start within specific dates.
For example, to search opportunities that start from the beginning of
this year, assuming today's date is August 11, 2009, use search phrase
startdate:[20090101 TO 20090811].
- startdate:[yyyymm* TO yyyymm*]
This is similar to search field startdate:[yyyymmdd TO yyyymmdd] but it
ignores the date. For example, search phrase startdate:[200901 TO
200903] will retrieve opportunities that start from January 1, 2009 to
March 31, 2009.
- startdatey:yyyy
This is used to search opportunities that start on specific year. For
example, search phrase startdatey:2009 will retrieve all opportunities
that start in 2009.
- startdatey:yyy?
This is used to search opportunities that start on some years. For
example, search phrase startdatey:200? will retrieve all opportunities
that start in 2000 to 2009.
- startdatem:mm
This is used to search opportunities that start on specified month mm.
For example, search phrase startdatem:03 will retrieve opportunities
that start in March.
- startdated:dd
This is used to search opportunities that start on specified day of the
month dd. For example, search phrase startdated:17 will retrieve
opportunities that start on the 17th day of the month.
- startdatelongm:January
This is the same as startdatem but using month's name (January,
February, March, April, May, June, July, August, September, October,
November, and December).
- startshortm:Jan
This is the same as startdatelongm but using month's short name (Jan,
Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, and Dec).
- startdatelongd:Monday
This is used to search opportunities that start on specific day of the
week (Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, or
Saturday).
- startshortd:Mon
This is the same as startdatelongd but using day's short name (Sun,
Mon, Tue, Wed, Thu, Fri, or Sat).
The format for searching the expected
close date and actual close date of the opportunity is the same as that
of searching the start date of the opportunity by replacing 'startdate'
with 'expclosedate' and 'actclosedate' respectively.
4.11. Opportunity Charts
There are two data sets that the charts
are generated from. The first data sets is the data that is related only
to a single opportunity. The second data sets is the data that is
related to all opportunities.
4.12. Charts on Single Opportunity Data Set
4.12.1. Expected Revenue Over Time
This chart displays the opportunity's
expected revenue over time. If the checkbox 'Calculate from included
Products' is enabled, the expected revenue equals the total of the
products' sub total. The chart in
Figure 4.15:
Expected Revenue Over Time shows that the opportunity's expected revenue
increases over time when more products are added to the opportunity. To
select other desirable interval, click the Interval selection. Selecting
'Other Interval' allows any desired interval to be entered.
4.12.2. Estimated Revenue Over Time
This chart displays the opportunity's
estimated revenue over time (
Figure 4.16:
Estimated Revenue Over Time ). The estimated revenue increases over time
when:
- the opportunity's sales stage goes to the next higher level,
or
- more products are added to the opportunity when the checkbox
'Calculate from included Products' is enabled.
The estimated revenue equals the expected
revenue when the sales has 100% probability, i.e., when purchase order
is being raised.
 |
| Figure 4.15. Expected Revenue Over
Time |
 |
| Figure 4.16. Estimated Revenue Over
Time |
|
4.12.3. Sales Stage Gantt Chart
 |
| Figure 4.17. Sales Stage Gantt Chart |
This chart displays the how the sales
progresses over time by showing the start and end dates of each sales
stage ( Figure 4.17: Sales
Stage Gantt Chart ).
|
4.12.4. Working Days Spent on Each Sales Stage
This chart shows the number of working
days spent on each sales stage (
Figure
4.18: Working Days Spent on Each Sales Stage ).
4.12.5. Calendar Days Spent on Each Sales Stage
This chart shows the number of calendar
days spent on each sales stage (
Figure
4.19: Calendar Days Spent on Each Sales Stage ).
 |
Figure 4.18. Working Days Spent
on Each Sales Stage |
 |
Figure 4.19. Calendar Days Spent
on Each Sales Stage |
|
4.13. Charts on All Opportunities Data Set
The charts that uses data sets from all
opportunities can be accessed by clicking the opportunity folder and
clicking 'Chart'.
4.13.1. #Days for each Opportunity Sales Stage
This chart displays the sum of the number
of days for each sales stage from all opportunities as bar chart (
Figure
4.20: No of Days for Each Opportunity Sales Stage As Bar Chart ).
Figure
4.21: Percentage of Days for Each Opportunity Sales Stage As Pie Chart
shows percentage of number of days for each sales stage from all
opportunities.
 |
Figure 4.20. No of Days for Each
Opportunity Sales Stage As Bar Chart |
 |
Figure 4.21. Percentage of Days for
Each
Opportunity Sales Stage As Pie Chart |
|
4.13.2. #Opportunity for Each Source
This chart displays the number of
Opportunities for each source. Opportunities which are closed or in the
trash folder are excluded from the chart. Example of the bar chart is
shown in
Figure
4.22: No of Opportunities for Each Source As Bar Chart and the pie chart
is shown in
Figure
4.23: Percentage of Opportunities for Each Source As Pie Chart.
 |
Figure 4.22. No of Opportunities for
Each Source As Bar Chart |
 |
Figure 4.23. Percentage of
Opportunities for
Each Source As Pie Chart |
|
4.13.3. #Opportunity for Each Rating
This chart displays the number of
Opportunities for each rating. Opportunities which are closed or in the
trash folder are excluded from the chart. Example of the bar chart is
shown in
Figure
4.24: No of Opportunities for Each Rating As Bar Chart and the pie chart
is shown in
Figure
4.25: Percentage of Opportunities for Each Rating As Pie Chart.
 |
Figure 4.24. No of Opportunities for
Each Rating As Bar Chart |
 |
Figure 4.25. Percentage of
Opportunities for Each Rating As Pie Chart |
|
4.13.4. #Opportunity for each Sales Stage
This chart displays the number of
Opportunities for each sales stage. Opportunities which are closed or in
the trash folder are excluded from the chart. Example of the bar chart
is shown in
Figure
4.26: No of Opportunities for Each Sales Stage As Bar Chart and the pie
chart is shown in
Figure
4.27: Percentage of Opportunities for Each Sales Stage As Pie Chart.
 |
Figure 4.26. No of Opportunities for
Each Sales Stage As Bar Chart |
 |
Figure 4.27. Percentage of
Opportunities for
Each Sales Stage As Pie Chart |
|
4.13.5. #Opportunity for each Sales Stage By Month
This chart displays the number of
opportunities for each sales stage for each selected month. If the
selected months contains the current month, the values for the current
month in '#Opportunity for each Sales Stage by Month' is the same as
those values in '#Opportunity for each Sales Stage'. '#Opportunity for
each Sales Stage' takes a snapshot at any point of time, where
'#Opportunities for each Sales Stage by Month' takes snapshot month by
month. Example of '#Opportunities for each Sales Stage By Month' from
January 1, 2009 to August 17, 2009, is shown in
Figure
4.28: No of Opportunities for Each Sales Stage By Month.
4.13.6. #Opportunity for each Sales Stage By Day
The interpretation of this chart is the
same that of chart '#Opportunities for each Sales Stage by Month' except
that the interval is day by day. Example of '#Opportunities for each
Sales Stage By Day' from January 1, 2009 to August 17, 2009, is shown in
Figure
4.29: No of Opportunities for Each Sales Stage By Day.
 |
Figure 4.28. No of Opportunities for
Each Sales Stage By Month |
 |
Figure 4.29. No of Opportunities for
Each Sales Stage By Day |
|
5. Quotation
Quotation can be generated from an
opportunity at any time by clicking the button

after the 'Quotation Status' inside the
opportunity details (
Figure
5.1: Generating Quotation from an Opportunity ). A quotation dialog box
will appear (
Figure 5.2:
Quotation ).
 |
Figure 5.1. Generating Quotation
from an Opportunity |
 |
| Figure 5.2. Quotation |
|
The products that have been added to the
opportunity will become line items in the quotation, see
Figure
5.3: Line Items inside Quotation . The contacts related to the
opportunity will become the contacts for the quotation
Figure
5.4: Contacts in Quotation. The company name for the quotation is
derived from the account name that is associated with the opportunity.
 |
| Figure 5.3. Line Items inside
Quotation |
 |
| Figure 5.4. Contacts in Quotation |
|
5.1. Quotation Fields
 |
| Figure 5.5. Selecting Quotation's
Contact as Recipient |
 |
Figure 5.6. Selecting Contact
as Recipient of the Quotation |
 |
Figure 5.7. Selected Contact
as Recipient of the Quotation |
|
5.2. Working with Line Items
The line items fields are:
- S/N
The line item serial number.
- Product name
It can be modified.
- Delivery Date
It can be modified
- Optional (enabled/disabled)
If it is enabled, the line item will be optional. Its sub total will
not be included in the total.
- Hidden (enabled/disabled)
If it is enabled, the line item will not be displayed in the generated
quotation in PDF format. Although it is not displayed, the line item
sub total will still be included in the total.
- Hide Adjustment (enabled/disabled)
If it is enabled and the adjustment is set, the adjustment will not be
displayed.
- Hide Price/Amount (enabled/disabled)
If it is enabled, the line item's price and amount will not be
displayed.
- Hide Sub Total (enabled/disabled)
If it is enabled, the line item's sub total will not be displayed.
- Adjustment Type
- Extra Charge USD
- Extra Charge %
- Discount USD
- Discount %
- Handling Charge USD
- Handling Charge %
- By
This is the value of the adjustment type.
- Value
It is not editable. It is calculated from the line item sub total and
the adjustment value. For example, if the line item sub total is USD
1,000.00 and Handling Charge % is 10%, the adjustment value is USD
1,000.00 x 10% = USD 100.00.
- Taxable
If it is enabled the line item is taxable. The tax rate is defined in
the quotation.
- Price
The selling price of the line item. This is determine by the product
pricing in the opportunity. It is not editable. To modify the selling
price, it has to be done in the opportunity to which the quotation is
associated.
- Amount
The amount the product is required. It is not editable. To modify the
amount, it has to be done in the opportunity to which the quotation is
associated.
- Sub Total
Sub Total = Amount x Price
5.2.1. Inserting Comment
Comment can be inserted by selecting the
row where the comment will be inserted before the row and then clicking
the 'Insert' menu at the toolbar of the Line Item List, and select

'Comment' menu item (
Figure 5.8:
Inserting Comment Line Item ). Comment has only a comment field to store
additional information about the line items in the quotation (
Figure 5.9: Inserted
Comment Line Item ). Clicking 'Save' button (

) will save the entered comments.
 |
| Figure 5.8. Inserting Comment Line
Item |
 |
| Figure 5.9. Inserted Comment Line
Item |
|
5.2.2. Inserting Sub Total
Sub Total line item adds up the line item
from the previous sub total line item up to the row where the sub total
line item is inserted. If there is no previous sub total line item, the
sub total line item adds up from the beginning of the line items.
Sub Total line item can be inserted by
selecting the row where the Sub Total line item will be inserted before
the row and then clicking the 'Insert' menu at the toolbar of the Line
Item List, and select

'Sub Total' menu item (
Figure 5.10:
Inserting Sub Total Line Item ). Sub Total line item has two fields.
They are the description field to store additional information about the
line items in the quotation and the sub total field (
Figure 5.11:
Inserted Sub Total Line Item ). Clicking 'Save' button (

) will save the entered description.
 |
| Figure 5.10. Inserting Sub Total Line
Item |
 |
| Figure 5.11. Inserted Sub Total Line
Item |
|
5.2.3. Inserting Accumulated Sub Total
Accumulated Sub Total line item adds up
the line item from the beginning of line items up to the row where the
accumulated sub total line item is inserted.
Accumulated Sub Total line item can be
inserted by selecting the row where the Accumulated Sub Total line item
will be inserted before the row and then clicking the 'Insert' menu at
the toolbar of the Line Item List, and select

'Accumulated Sub Total' menu item (
Figure
5.12: Inserting Accumulated Sub Total Line Item ). Accumulated Sub Total
line item has two fields. They are the description field to store
additional information about the line items in the quotation and the
accumulated sub total field (
Figure
5.13: Inserted Accumulated Sub Total Line Item ). Clicking 'Save' button
(

) will save the entered description.
 |
| Figure 5.12. Inserting Accumulated
Sub Total Line Item |
 |
| Figure 5.13. Inserted Accumulated Sub
Total Line Item |
|
5.2.4. Removing Comment, Sub Total, or Accumulated
Sub Total
Comment, sub total, and accumulated sub
total line items can be removed from the line item list. Product line
item can't be removed from the list. Product line item removal must be
done in the opportunity.
Clicking the checkbox of the comment, sub
total or accumulated sub total line item, and clicking 'Delist' button (

) will remove the line item from the list.
The value of other sub totals will be re-calculated.
5.2.5. Reordering Line Items
Reordering line items is done by moving
one line item at the time to the desired position. It begins with the
line item that has to be the first line item, and then the second line
item, and so on until the last line item.
To move line item:
- Click the up-down arrow button (
) of the line item to be moved.
- The background of the up-down arrow button will become red. It
indicates that the line item is now movable.
- Move the cursor to any line item where the line item to be
moved will be inserted (Figure
5.14: Moving Line Item).
- Click the up-down arrow button again.
- The background of the up-down arrow button returns to normal (Figure 5.15:
Moved Line Item).
 |
| Figure 5.14. Moving Line Item |
 |
| Figure 5.15. Moved Line Item |
|
5.2.6. Entering and Removing Delivery Date
 |
| Figure 5.16. Entering Line Item
Delivery Date |
Clicking the delivery date cell will
show the delivery date input fields ( Figure
5.16: Entering Line Item Delivery Date ). Clicking the tick button (  ) will set the delivery date. Clicking the cross
button (  ) will remove the delivery date.
|
5.3. Generating Quotation as PDF file
 |
| Figure 5.17. Generating Quotation in
PDF Format |
When details about the quotation and
line items have been entered, the quotation in PDF format can be
generated by clicking the 'Preview' or 'PDF' button. The 'Preview'
button will open a new window showing the generated quotation in PDF
format. Acrobat reader plugin for your browser is needed to view the
PDF document. The 'PDF' button will generate the quotation in PDF
format without opening a new window but the generated PDF file is
stored inside Document list ( Figure
5.17: Generating Quotation in PDF Format ).
|
 |
Figure 5.18. Example of Generated
Quotation
in PDF Format |
The generated Quotation in PDF format
in this example is shown in Figure
5.18: Example of Generated Quotation in PDF Format .
5.4. Working with Quotation Template
The quotation in PDF format is
generated by merging the quotation template with the data from the
quotation and line item details. There are three sources of quotation
template:
- System template
This cannot be modified. It may be updated from time to time when
software update is released.
- Company Template
This can be modified only by the superuser. Initially it is
set to the system template. The company template can be reset to
system template anytime after modification. Any modification made
before the reset will be lost.
- User template
This can be modified by the user and the modification is specific to
the quotation. The modification does not affect user template for
other quotations. The user template for specific quotation can be
reset to the company template anytime after modification, the reset
does not affect user template for other quotations.
|
The system template inside an HTML editor
is shown in
Figure
5.19: Quotation Template .
5.4.1. Quotation Template Tag
The template contains tags that will be
replaced with the data from the quotation and line items. To insert the
tag, click the 'Insert Tag' button (

) at the quotation template toolbar. A dialog box will
appear with selection of tags, see
Figure
5.20: Quotation Template Tag . The tag can be inserted at the cursor in
the quotation template by clicking one the tags.
 |
| Figure 5.19. Quotation Template |
 |
| Figure 5.20. Quotation Template Tag |
|
The following list is the quotation tags
with their tag values:
- Company Name
{{companyname}}
- Company Full Address (Address Line 1, 2, and 3, City, State or
US State, Country and Zip Code)
{{companyfulladdress}}
- Company Address (Address Line 1, 2, and 3, and City)
{{companyaddress}}
- Company Address Line 1
{{companyaddressline1}}
- Company Address Line 2
{{companyaddressline2}}
- Company Address Line 3
{{companyaddressline3}}
- Company City
{{companycity}}
- Company State/Province or US State, Zip Code and Country
{{companystatecountry}}
- Company State
{{companystate}}
- Company US State
{{companyus_state}}
- Company Zipcode/Postcode
{{companyzipcode}}
- Company Country
{{companycountry}}
- Company Telephone and Fax
{{companytelephonefax}}
- Company Telephone
{{companybusinesstelephone}}
- Company Telephone Ext.
{{companybusinessphoneext}}
- Company Fax
{{companyfax}}
- Shipping Full Address (Address Line 1, 2, and 3, City, State
or US State, Country and Zip Code)
{{shippingfulladdress}}
- Shipping Address (Address Line 1, 2, and 3, and City)
{{shippingaddress}}
- Shipping Address Line 1
{{shippingaddressline1}}
- Shipping Address Line 2
{{shippingaddressline2}}
- Shipping Address Line 3
{{shippingaddressline3}}
- Shipping City
{{shippingcity}}
- Shipping State/Province or US State, Zip Code and Country
{{shippingstatecountry}}
- Shipping State
{{shippingstate}}
- Shipping US State
{{shippingus_state}}
- Shipping Zipcode/Postcode
{{shippingzipcode}}
- Shipping Country
{{shippingcountry}}
- Shipping Telephone, Ext, and Fax
{{shippingtelephonefax}}
- Shipping Business Telephone
{{shippingbusinesstelephone}}
- Shipping Business Telephone Extension
{{shippingbusinessphoneext}}
- Shipping Fax
{{shippingfax}}
- Contact Full Address (Address Line 1, 2, and 3, City, State or
US State, Country and Zip Code)
{{contactfulladdress}}
- Contact Address (Address Line 1, 2, and 3)
{{contactaddress}}
- Contact Address Line 1
{{contactaddressline1}}
- Contact Address Line 2
{{contactaddressline2}}
- Contact Address Line 3
{{contactaddressline3}}
- Contact City
{{contactcity}}
- Contact State/Province or US State, Zip Code and Country
{{contactstatecountry}}
- Contact State
{{contactstate}}
- Contact US State
{{contactus_state}}
- Contact Zipcode/Postcode
{{contactzipcode}}
- Contact Country
{{contactcountry}}
- Contact Telephone and Fax
{{contacttelephonefax}}
- Contact Business Telephone
{{contactbusinesstelephone}}
- Contact Business Telephone Extension
{{contactbusinessphoneext}}
- Contact Fax
{{contactfax}}
- Contact Title and Full Name
{{contacttitlefullname}}
- Contact Title
{{contacttitle}}
- Contact Full Name (First Name, Middle Name and Last Name)
{{contactfullname}}
- Contact First Name
{{contactfirstname}}
- Contact Middle Name
{{contactmiddlename}}
- Contact Last Name
{{contactlastname}}
- Contact Suffix Name
{{contactsuffixname}}
- My Company Name
{{mycompanyname}}
- My Company Full Address (Address Line 1, 2, and 3, City, State
or US State, Country and Zip Code)
{{mycompanyfulladdress}}
- My Company Address (Address Line 1, 2, and 3, and City)
{{mycompanyaddress}}
- My Company Address Line 1
{{mycompanyaddressline1}}
- My Company Address Line 2
{{mycompanyaddressline2}}
- My Company Address Line 3
{{mycompanyaddressline3}}
- My Company City
{{mycompanycity}}
- My Company State/Province or US State, Zip Code and Country
{{mycompanystatecountry}}
- My Company State
{{mycompanystate}}
- My Company US State
{{mycompanyus_state}}
- My Company Zipcode/Postcode
{{mycompanyzipcode}}
- My Company Country
{{mycompanycountry}}
- My Company Telephone, Ext, Fax and Website
{{mycompanytelephonefaxwebsite}}
- My Company Telephone, Ext, and Fax
{{mycompanytelephonefax}}
- My Company Telephone
{{mycompanybusinesstelephone}}
- My Company Fax
{{mycompanyfax}}
- My Company Website
{{mycompanywebsite}}
- My Company Logo
{{mycompanylogo}}
- Quote No.
{{quoteno}}
- Quote Date
{{quotedate}}
- Quote Expiry Date
{{quoteexpirydate}}
- Payment Terms
{{paymentterms}}
- Ship Via
{{shipvia}}
- FOB
{{fob}}
- Tax Rate
{{taxrate}}
- Sales Tax
{{salestax}}
- Shipping Cost
{{shippingcost}}
- Sales Rep
{{salesrep}}
- Line Items (S/N, Qty, Line Item Description, Delivery, Unit
Price, Sub Total)
This is an aggregate of tags that display the line items in a table
format. It contains the delivery date column. The default format is
shown in Figure
5.21: Line Items Tag With Delivery Date.
- Line Items (S/N, Qty, Line Item Description, Unit Price, Sub
Total)
This is an aggregate of tags that display the line items in a table
format. It does not contain the delivery date column. The default
format is shown in Figure
5.22: Line Items Tag Without Delivery Date.
 |
Figure 5.21. Line Items Tag
With Delivery Date |
 |
Figure 5.22. Line Items Tag
Without Delivery Date |
|
5.4.2. Quotation Template's Header and Footer
When the quotation template editor is
opened, it initially shows the quotation template's body. The quotation
template's header or footer can be edited by selecting it at the
quotation template editor's toolbar, see
Figure 5.23:
Quotation Template's Header and
Figure 5.24:
Quotation Template's Footer .
 |
| Figure 5.23. Quotation Template's
Header |
 |
| Figure 5.24. Quotation Template's
Footer |
|
 |
| Figure 5.25. Quotation Page Numbering
and Company Logo |
The tag {{mycompanylogo}} will be
replaced with the company logo that has been uploaded into company
details. The forward slash at the quotation template's footer is for
the page numbering, see Figure
5.25: Quotation Page Numbering and Company Logo .
|
5.5. Navigating Quotation List
 |
| Figure 5.26. Quotation List |
An example of the quotation list view
is shown in Figure 5.26:
Quotation List .
The quotation list consists of columns:
- Quotation No
- Company name
- Quotation Date
- Quotation Expiry Date
- Quotation Status
Its possible values are:
- Rejected
- PO Raised
- Revised
- Acknowledged
- Sent and Waiting Response
- Draft
|
5.5.1. Quotation Search Fields
The quotation search field names are:
- importance
Possible values: "Most Important", "Very Important", "Important", "Less
Important", "Not Important". To retrieve only quotations with the
specific importance, the search value must be surrounded with double
quotes, for example, importance:"Most Important".
- description
- companyname
Customer's company name
- status
Quotation Status
- quoteno
Quotation number
- custpono
Customer PO number
- salesrep
Sales Representative
- fob
- paymentterms
- shipvia
- taxrate
- taxrate:[0 TO 0]
- shippingcost
- shippingcost:[0 TO 0]
- companyaddress
- companycity
- companystate
- companyus_state
- companyzipcode
- companycountry
- companybusinesstelephone
- companyfax
- shippingaddress
- shippingcity
- shippingstate
- shippingus_state
- shippingzipcode
- shippingcountry
- shippingbusinesstelephone
- shippingfax
- contactaddress
- contactcity
- contactstate
- contactus_state
- contactzipcode
- contactcountry
- contactbusinesstelephone
- contactbusinessphoneext
Business telephone extension
- contactfax
- contactitle
- contactfirstname
- contactmiddlename
- contactlastname
- contactsuffixname
- contactscreenname
5.5.2. Searching Quotation Date and Quotation Expiry
Date
- quotedate:yyyymmdd
This is used to search quotations that are created on specific date:
yyyy-mm-dd. For example, to search quotations that are created on March
31, 2009, use search phrase quotedate:20090331.
- quotedate:[yyyymmdd TO yyyymmdd]
This is used to search quotations that are created within specific
dates. For example, to search quotations that are created from the
beginning of this year, assuming today's date is August 11, 2009, use
search phrase quotedate:[20090101 TO 20090811].
- quotedate:[yyyymm* TO yyyymm*]
This is similar to search field quotedate:[yyyymmdd TO yyyymmdd] but it
ignores the date. For example, search phrase quotedate:[200901 TO
200903] will retrieve quotations that are created from January 1, 2009
to March 31, 2009.
- quotedatey:yyyy
This is used to search quotations that are created on specific year.
For example, search phrase quotedatey:2009 will retrieve all quotations
that are created in 2009.
- quotedatey:yyy?
This is used to search quotations that are created on some years. For
example, search phrase quotedatey:200? will retrieve all quotations
that are created in 2000 to 2009.
- quotedatem:mm
This is used to search quotations that are created on specified month
mm. For example, search phrase quotedatem:03 will retrieve quotations
that are created in March.
- quotedated:dd
This is used to search quotations that are created on specified day of
the month dd. For example, search phrase quotedated:17 will retrieve
quotations that are created on the 17th day of the month.
- quotedatelongm:January
This is the same as quotedatem but using month's name (January,
February, March, April, May, June, July, August, September, October,
November, and December).
- startshortm:Jan
This is the same as quotedatelongm but using month's short name (Jan,
Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, and Dec).
- quotedatelongd:Monday
This is used to search quotations that are created on specific day of
the week (Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, or
Saturday).
- startshortd:Mon
This is the same as quotedatelongd but using day's short name (Sun,
Mon, Tue, Wed, Thu, Fri, or Sat).
The format for searching the quotation
expiry date is the same as that of searching the quotation creation date
by replacing 'quotedate'' with 'quoteexpirydate'.
6. Account
Opportunities must be associated with a
particular account. The account is associated with a company. The
account contains information about the customer such as customer's
billing and shipping address. The billing and shipping address are the
same data as those of the company with which the account is associated.
6.1. Creating Account
To enter account details:
- Click the Account folder or any of its sub-folders where the
new account will be put into.
- Click the 'New' button at the toolbar, or click the menu:
'Edit', 'New Item', or click the menu: 'File', 'Create New', 'Account'.
- An empty account details dialog box will open (Figure
6.1: Empty Account Details).
- Select company by clicking the select company button (
). A company selection dialog box will appear (Figure 6.2:
Selecting Company for an Account).
- Select a company and click 'Accept Selection' button (
).
- Optionally, enable 'Updating Existing Company Detail'. When
enabled, it allows any change made in the account details to be made on
the company details too.
- Enter account code and name.
- Select the rating of the account. Its possible values are:
- Hot
- Warm
- Cold
- Enter the company revenue if it is known or it can be
estimated.
- Enter the number of employees of the company if it is known or
it can be estimated.
- Click 'Save' when you finish entering the details.
 |
| Figure 6.1. Empty Account Details |
 |
Figure 6.2. Selecting Company
for an Account |
|
6.2. Account Fields
The fields that need to be entered in
account details are:
- Account Code
- Account Name
- Rating
Its possible values are:
- Hot
- Warm
- Cold
- Annual Revenue
- Number of Employee
- Company
An account must be associated with a company. The company details can
be selected by clicking company selection button (
).
- Optionally, if the 'Update Existing Company Detail' checkbox
is enabled, any update related to the company in the account details
will be reflected to the company details.
6.3. Navigating Account List
 |
| Figure 6.3. Account List View |
An example of the account list view is
shown in Figure
6.3: Account List View .
The account list consists of columns:
- Account Name
- Account Code
- Company Name
- Company's City
- Company's Telephone
- Company's Fax
- Company's Website
- Account's Rating
- Account's Revenue
|
6.4. Account Search Fields
The account search field names are:
- importance
Possible values: "Most Important", "Very Important", "Important", "Less
Important", "Not Important". To retrieve only accounts with the
specific importance, the search value must be surrounded with double
quotes, for example, importance:"Most Important".
- description
- accountcode
- accountname
- annualrevenue
- annualrevenue:[0 TO 0]
- noofemployee:000000000
- noofemployee:[000000000 TO 000000000]
- rating
- Company search field names:
- companyname
- industrytype
- addressline
- city
- state
- us_state
- zipcode
- country
- businesstelephone
- fax
- website
- shippingaddressline
- shippingcity
- shippingstate
- shippingus_state
- shippingzipcode
- shippingcountry
- shippingbusinesstelephone
- shippingfax