US Toll Free: +1 877 319-0330,     Australia: 1300 786-922
Table of Contents
;
Borneosoft Sales Management

1. Introduction

Borneosoft Sales - Automatically Generated Quotation
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

Borneosoft Sales - Blank Lead Details
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

  1. Click the Lead folder or any of its sub-folders where the new lead will be put into.
  2. Click the 'New' button at the toolbar, or click the menu: 'Edit', 'New Item', or click the menu: 'File', 'Create New', 'Lead'.
  3. An empty lead details dialog box will open (Figure 2.1: Blank Lead Details).
  4. 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:
  1. Prospecting
  2. Qualified
  3. 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:
  1. Hot
  2. Warm
  3. 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:
  1. Advertising/Marketing/PR
  2. Aerospace
  3. Agriculture/Forestry
  4. Automotive
  5. Business Services & Consulting
  6. Chemicals
  7. Computers/Electronics
  8. Construction/Real Estate
  9. Consumer Goods
  10. Education
  11. Energy/Mining
  12. Finance/Insurance
  13. Food, Drinks & Services
  14. Government/Military/Public Services
  15. Hospitality/Hotel/Recreation
  16. Information/Comm. Technology
  17. Manufacturing
  18. Media/Publishing/Entertainment
  19. Medical & Health Services
  20. Non Profit Organization
  21. Pharmaceuticals
  22. Retail
  23. Sport
  24. Travel/Transportation/Logistic

2.1.4. Lead Source

The possible values are:
  1. Advertisement
  2. Call Center Inquiries
  3. Cold Call
  4. Commercial Database
  5. Conference/Seminar
  6. Direct Mail
  7. E-Newsletter
  8. Email
  9. Existing Customer
  10. Partner
  11. Public Relations
  12. Referral (External)
  13. Referral (Internal)
  14. Search Engine
  15. Virtual/Tradeshow
  16. Website Request
  17. Website Visit
  18. Word of mouth
  19. 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:
Borneosoft Sales - Adding New Contact to Lead
Figure 2.2. Adding New Contact to Lead
  1. Contact Person
  2. Decision Maker
  3. Project Manager
  4. Executive
  5. Sponsor
  6. Employee
  7. Reviewer
  8. Supplier
  9. Partner
  10. Sub Contractor
  11. Buyer
  12. End User
  13. Test User
  14. Tech. Team Member
  15. Advisor

2.2.1. Adding Contact to Lead by Creating New Contact

Borneosoft Sales - Adding Existing Contacts to Lead
Figure 2.3. Adding Existing Contacts to Lead
  1. Click the Contact at the related items title bar.
  2. Click 'New' button at the related item toolbar. A dialog box will appear to enter contact details.
  3. 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).
  4. 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

Borneosoft Sales - Completed Lead Details
Figure 2.4. Completed Lead Details
  1. Click the Contact at the related items title bar.
  2. 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.
  3. Select how the contacts are related to the lead.
  4. Check the checkboxes of the contacts that will be added.
  5. 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:
  1. Miscellaneous
  2. Demo
  3. Executable
  4. Drawing
  5. Supporting Document
  6. Case Study
  7. Howto
  8. Reference
  9. User Guide
  10. Manual
  11. Brochure
  12. Datasheet
  13. Quotation
  14. Purchase Order

2.5. Adding Notes to Lead

Borneosoft Sales - Blank Notes
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:
  1. 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).
  2. Click 'OK'.
  3. 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.
  4. The lead is closed and it is not editable (). Its status is set 'Qualified'.
  5. Click the new Opportunity link (see Figure 2.8: Closed Lead after Creating New Opportunity).
  6. 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.
Borneosoft Sales - Account Alert for New Opportunity
Figure 2.6. Account Alert for New Opportunity
Borneosoft Sales - Selecting an Account for The New Opportunity
Figure 2.7. Selecting an Account for The New Opportunity
Borneosoft Sales - Closed Lead after Creating New Opportunity
Figure 2.8. Closed Lead after Creating New Opportunity
Borneosoft Sales - The New Opportunity Created from The Lead
Figure 2.9. The New Opportunity Created from The Lead

2.7. Navigating Lead List

Borneosoft Sales - Expanded 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:
  1. Contact
    Contact's name
  2. As
    How the contact is related to the lead
  3. Company
    Contact's company
  4. Work
    Contact's business telephone
  5. Email
    Contact's email
Borneosoft Sales - Collapsed Lead List
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:
  1. 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".
  2. description
  3. leadname
  4. industrytype
    See Industry Type for possible values.
  5. source
    See Lead Source for possible values.
  6. rating
    Possible values: Hot, Warm, Cold
  7. leadstatus
    Possible values: Prospecting, Qualified, Disqualified
  8. contactname
    The names of the contacts related to the lead
  9. contactas
    The relationship between the contacts and the lead
  10. businesstelephone
    The business telephone of the contacts related to the lead
  11. companyname
    The company name of the contacts related to the lead
  12. email
    The email of the contacts related to the lead
Borneosoft Sales - Searching Decision Makers in All Leads
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.
Borneosoft Sales - Searching Decision Makers in Company Wilkinson
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
Borneosoft Sales - No of Converted Leads by Month
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).
Borneosoft Sales - No of Days for Each Lead Status As Bar Chart
Figure 2.15. No of Days
for Each Lead Status As Bar Chart
Borneosoft Sales - Percentage of Days for Each Lead Status As Pie 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.
Borneosoft Sales - No of Leads for Each Industry Type As Bar Chart
Figure 2.17. No of Leads
for Each Industry Type As Bar Chart
Borneosoft Sales - Percentage of Leads for Each Industry Type As Pie 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.
Borneosoft Sales - No of Leads for Each Source As Bar Chart
Figure 2.19. No of Leads
for Each Source As Bar Chart
Borneosoft Sales - Percentage of Leads for Each Source As Pie 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.
Borneosoft Sales - No of Leads for Each Rating As Bar Chart
Figure 2.21. No of Leads for Each Rating As Bar Chart
Borneosoft Sales - Percentage of Leads for Each Rating As Pie 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.
Borneosoft Sales - No of Leads for Each Status As Bar Chart
Figure 2.23. No of Leads for Each Status As Bar Chart
Borneosoft Sales - Percentage of Leads for Each Status As Pie 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.
Borneosoft Sales - No of Leads for Each Status By Month
Figure 2.25. No of Leads for Each Status By Month
Borneosoft Sales - No of Leads for Each Status By Day
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

  1. Click the Product folder or any of its sub-folders where the new product will be put into.
  2. Click the 'New' button at the toolbar, or click the menu: 'Edit', 'New Item', or click the menu: 'File', 'Create New', 'Product'.
  3. An empty product details dialog box will open (Figure 3.1: Blank Product Details).
  4. Click 'Save' when you finish entering the details.

3.2. Product Fields

Borneosoft Sales - Blank Product Details
Figure 3.1. Blank Product Details
The fields that need to be entered in product details are:
  1. Product Code
  2. Product Name
  3. Unit
    Possible values:
    1. minute
    2. hour
    3. day
    4. week
    5. month
    6. year
    7. meter
    8. mile
    9. kilogram
    10. box
    11. package
    12. incident
    13. call
    14. license
    15. user
    16. seat
    17. processor
    18. gigabyte
    19. megabyte
    20. kilobyte
  4. 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.
  5. Single Unit Price
    The price of the product for a single unit.
  6. Tiered* Unit Price
    The price of the product at requested amount or at the minimum amount
  7. 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.
  8. Single Unit Cost
    The cost of the product for a single unit.
  9. Tiered* Unit Cost
    The cost of the product at requested amount or at the minimum amount
  10. 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.
  11. Selling Price Adjustment
    Possible values:
    1. Fixed Price
      Selling Price equals to the value the user enters into the 'Selling Price' input field.
    2. 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.
    3. 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.
    4. 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.
    5. 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.
    6. 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.
    7. 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.
    8. 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.
    9. 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.
  12. Selling Price
    This input field is only editable when 'Selling Price Adjustment' is set to 'Fixed Price'.
  13. No. of digits to the right of the decimal point for unit price/unit cost
    Possible values:
    1. #,###.
      No decimal fraction
    2. #,###.0
      1 decimal fraction
    3. #,###.00
      2 decimal fraction. That
    4. #,###.000
      3 decimal fraction. This is usually used in for parts that have unit price/unit cost fraction of a cent.
  14. Rounding mode for unit price/unit cost
    1. Half Up
      Rounding mode to round towards "nearest neighbor" unless both neighbors are equidistant, in which case round up.
    2. Half Down
      Rounding mode to round towards "nearest neighbor" unless both neighbors are equidistant, in which case round down.
    3. Half Even
      Rounding mode to round towards the "nearest neighbor" unless both neighbors are equidistant, in which case, round towards the even neighbor.
    4. Up
      Rounding mode to round away from zero.
    5. Down
      Rounding mode to round towards zero.
    6. Ceiling
      Rounding mode to round towards positive infinity.
    7. Floor
      Rounding mode to round towards negative infinity.
  15. Unit in Stock
    Number of unit in stock.
  16. Available Unit
    This is not editable. Its value is calculated automatically.
    Available Unit = Unit in Stock – Total of Requested Amount in all opportunities
  17. 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.
  18. Notes

3.3. Creating Tiered Unit Price/Unit Cost

Borneosoft Sales - Adding Price Tier
Figure 3.2. Adding Price Tier
  1. In the product details, click the 'Price Tier' or 'Cost Tier' at the related items title bar.
  2. Click 'New' button () to add a new row to the list, see Figure 3.2: Adding Price Tier.
  3. Click the new row under the column 'Amount Up To'. Enter the amount.
  4. Click the new row under the column 'Price'. Enter the price.
  5. Click 'Save' button () to save the changes.
Borneosoft Sales - Product Tiered Pricing
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

Borneosoft Sales - Product List View
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:
  1. Product Name
  2. Product Code
  3. Unit Name
  4. Whether the Unit Price is tiered
  5. Single Unit Price
  6. Tiered Unit Price (Volume based unit price)
  7. Whether the Unit Cost is tiered
  8. Single Unit Cost
  9. Tiered Unit Cost (Volume based unit cost)
  10. Selected Price Adjustment
  11. Adjustment value
  12. Selling Price
  13. Unit in Stock
  14. Available Unit
  15. Supplier Name
  16. Manufacturer Name

3.4.1. Product Search Fields

The product search field names are:
  1. 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".
  2. description
  3. productcode
  4. productname
  5. unitprice
  6. unitprice:[0 TO 0]
  7. unitcost
  8. unitcost:[0 TO 0]
  9. volumeunitprice
  10. volumeunitprice:[0 TO 0]
  11. volumeunitcost
  12. volumeunitcost:[0 TO 0]
  13. amount
  14. amount:[0 TO 0]
  15. subtotal
  16. subtotal:[0 TO 0]
  17. adjustmentvalue
  18. adjustmentvalue:[0 TO 0]
  19. sellingprice
  20. sellingprice:[0 TO 0]
  21. availableunit
  22. availableunit:[0 TO 0]
  23. unitinstock
  24. unitinstock:[0 TO 0]
  25. priceadjustment
    Possible values are:
    1. "Fixed Price"
    2. "At Unit Price"
    3. "At Unit Cost"
    4. "Margin USD", or other currency symbol
    5. "Margin %"
    6. "Discount USD", or other currency symbol
    7. "Discount %"
    8. "Markup US", or other currency symbol
    9. "Markup %"
  26. unit
  27. manufacturercompanyname
  28. manufactureraddressline
  29. manufacturercity
  30. manufacturerstate
  31. manufacturerus_state
  32. manufacturerzipcode
  33. manufacturercountry
  34. manufacturerbusinesstelephone
  35. manufacturerfax
  36. manufacturerwebsite
  37. suppliercompanyname
  38. supplieraddressline
  39. suppliercity
  40. supplierstate
  41. supplierus_state
  42. supplierzipcode
  43. suppliercountry
  44. supplierbusinesstelephone
  45. supplierfax
  46. 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):
  1. Qualified (10%)
  2. Needs Assessment (20%)
  3. Solution Evaluation (30%)
  4. Proposal (50%)
  5. Purchasing Decision (70%)
  6. Refine Solution (80%)
  7. Verbal Agreement (90%)
  8. Purchase Order (100%)
  9. Lost (0%)
  10. Canceled (0%)
  11. 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

Borneosoft Sales - Blank Opportunity Details
Figure 4.1. Blank Opportunity Details
  1. Click the Opportunity folder or any of its sub-folders where the new opportunity will be put into.
  2. Click the 'New' button at the toolbar, or click the menu: 'Edit', 'New Item', or click the menu: 'File', 'Create New', 'Opportunity'.
  3. An empty opportunity details dialog box will open (Figure 4.1: Blank Opportunity Details).
  4. Click 'Save' when you finish entering the details.
  5. 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:

  1. Hot
  2. Warm
  3. Cold

4.1.2. Opportunity Source

The possible values are:
  1. Advertisement
  2. Call Center Inquiries
  3. Cold Call
  4. Commercial Database
  5. Conference/Seminar
  6. Direct Mail
  7. E-Newsletter
  8. Email
  9. Existing Customer
  10. Partner
  11. Public Relations
  12. Referral (External)
  13. Referral (Internal)
  14. Search Engine
  15. Virtual/Tradeshow
  16. Website Request
  17. Website Visit
  18. Word of mouth
  19. Yellow Page

4.1.3. Opportunity Sales Stage:

  1. Qualified
  2. Needs Assessment
  3. Solution Evaluation
  4. Proposal
  5. Purchasing Decision
  6. Refine Solution
  7. Verbal Agreement
  8. Purchase Order
  9. Lost
  10. Canceled
  11. 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:
  1. #,###.
    No decimal fraction
  2. #,###.0
    1 decimal fraction
  3. #,###.00
    2 decimal fraction. That
  4. #,###.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:
  1. Half Up
    Rounding mode to round towards "nearest neighbor" unless both neighbors are equidistant, in which case round up.
  2. Half Down
    Rounding mode to round towards "nearest neighbor" unless both neighbors are equidistant, in which case round down.
  3. Half Even
    Rounding mode to round towards the "nearest neighbor" unless both neighbors are equidistant, in which case, round towards the even neighbor.
  4. Up
    Rounding mode to round away from zero.
  5. Down
    Rounding mode to round towards zero.
  6. Ceiling
    Rounding mode to round towards positive infinity.
  7. 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:
  1. Competitor
  2. Supplier
  3. Partner
  4. Sub-Contractor

4.4. Adding Products to Opportunity by Selecting Existing Products

Borneosoft Sales - Selecting Existing Products
Figure 4.2. Selecting Existing Products
  1. Click the Product at the related items title bar.
  2. Click 'Select' button () at the related item toolbar. A dialog box will appear to select existing products (Figure 4.2: Selecting Existing Products).
  3. Check the checkboxes of the products that will be added.
  4. Enter the amount needed in the amount input field at the 'Amount' column.
  5. Optionally, adjust the pricing if the price adjustment is allowed for normal user.
  6. Click 'Accept Selection' button () at the toolbar. The selected products will be added to the opportunity.

4.5. Creating Products from inside Opportunity

Borneosoft Sales - Creating New Products from Inside Opportunity Details
Figure 4.3. Creating New Products
from Inside Opportunity Details
If the products have not been created, they need to be created first. Products can only be created by superuser. They can be created by clicking Products at the related item title bar and clicking 'New' button ( ) at the toolbar ( Figure 4.3: Creating New Products from Inside Opportunity Details ). A blank product details dialog box appears ( Figure 3.1: Blank Product Details).

4.6. Price Adjustment

Borneosoft Sales - Product 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:
  1. 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.
  2. Single Unit Price
  3. 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.
  4. Adjustment
    Adjustment type, i.e., Fixed Price, At Unit Price, At Unit Cost, Margin USD, Margin %, Discount USD, Discount %, Markup USD, or Markup %.
  5. Adjust By
    The value of the adjustment
  6. Selling Price
    It is editable when the adjustment is 'Fixed Price'.
  7. Amount
    The amount requested.
When the pricing is changed some fields are calculated automatically. The calculated fields are:
  1. Price (Tiered)
    It is re-calculated when the tiered unit pricing is changed or the amount changed.
  2. Cost (Tiered)
    It is re-calculated when the tiered unit cost is changed or the amount changed.
  3. 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.
  4. Sub Total
    It is re-calculated by multiplying selling price with the amount requested.
Borneosoft Sales - Product Price Adjustment - Sub Total Calculation
Figure 4.5. Product Price Adjustment - Sub Total Calculation
In this example (see Figure 4.4: Product Price Adjustment ), entering 200 to the amount requested will set sub total to 22,694 (see Figure 4.5: Product Price Adjustment - Sub Total Calculation ).
Borneosoft Sales - Product Added to Opportunity
Figure 4.6. Product Added to Opportunity
Clicking the 'Accept Selection' button ( ) will add the selected product with adjusted price to the opportunity, see Figure 4.6: Product Added to Opportunity.

4.6.2. Working with Products inside Opportunity

Borneosoft Sales - Opportunity with Products
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:
  1. Click the 'Product' at the related items title bar.
  2. Click the input field with light green background, edit or select the value.
  3. Click 'Save' button () at the toolbar.
Borneosoft Sales - Selecting Products for An Opportunity
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.
Borneosoft Sales - Added Product to an Opportunity - Users can Adjust Pricing
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.
Borneosoft Sales - Added Product to an Opportunity - Users can NOT Adjust Pricing
Figure 4.10. Added Product to an Opportunity -
Users can NOT Adjust Pricing
The details of the included product in the opportunity that does NOT allow the users to change product pricing is shown in Figure 4.10: Added Product to an Opportunity - Users can NOT Adjust Pricing. User is only allowed to change the amount.

4.7. Expected and Estimated Revenue Calculation

Borneosoft Sales - Product Expected and Estimated Revenue Automatic 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

Borneosoft Sales - Expanded Opportunity List
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:
  1. Competitor
  2. Supplier
  3. Partner
  4. Sub Contractor
Borneosoft Sales - Opportunity List
Figure 4.13. Opportunity List

4.10. Navigating Opportunity List

There are two types of opportunity list view, the expanded opportunity list where each opportunity's contacts are displayed ( Figure 4.12: Expanded Opportunity List ) and the opportunity list where only the opportunities are displayed ( Figure 4.13: Opportunity List ).
Clicking the 'Expand' or 'Collapse' button ( ) will expand or collapse the opportunity list. The collapsed opportunity list consists of columns:
  1. Opportunity Name
  2. Opportunity's Sales Stage
  3. Opportunity's Expected Close Date
  4. Account Name
  5. Rating
In addition to the columns listed above, the expanded opportunity list consists of columns:
  1. Contact Name
  2. How contact is associated to the opportunity
  3. Business/Work Telephone number
  4. Contact's Email

4.10.1. Opportunity Search Fields

Search fields names for opportunity are:
  1. 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".
  2. description
  3. opportunityname
  4. probability
  5. probability:[0 TO 0]
  6. 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.
  7. 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].
  8. exprevenue
    Expected Revenue.
  9. exprevenue:[0 TO 0]
  10. actrevenue
  11. actrevenue:[0 TO 0]
  12. account
    Account name.
  13. stage
    Sales stage.
    To retrieve specific sales stage, the search value must be surrounded with double quotes, for example, stage:"Needs Assesment".
  14. source
    Opportunity source.
    It is the same as lead source.
  15. rating
    Its possible values are:
    1. Hot
    2. Warm
    3. Cold
  16. contactname
    Contact name.
  17. contactas
    Association between contact and opportunity.
    Its possible values are:
    1. Contact Person
    2. Decision Maker
    3. Project Manager
    4. Executive
    5. Sponsor
    6. Employee
    7. Reviewer
    8. Supplier
    9. Partner
    10. Sub Contractor
    11. Buyer
    12. End User
    13. Test User
    14. Tech. Team Member
    15. Advisor
  18. businesstelephone
    Contact's business telephone.
  19. email
    Contact's email

4.10.2. Searching Opportunity Start, Expected Close and Actual Close Date

  1. 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.
  2. 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].
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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.
  8. 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).
  9. 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).
  10. startdatelongd:Monday
    This is used to search opportunities that start on specific day of the week (Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, or Saturday).
  11. 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

Borneosoft Sales - Opportunity from which The Charts for Single Opportunity is Generated
Figure 4.14. Opportunity from which The Charts
for Single Opportunity is Generated
The charts that uses data sets from a single opportunity can be accessed by viewing the opportunity details and clicking 'View Chart' button ( ). An example of an opportunity where the following charts are generated, is shown in Figure 4.14: Opportunity from which The Charts for Single Opportunity is Generated.

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.
Borneosoft Sales - Expected Revenue Over Time
Figure 4.15. Expected Revenue Over Time
Borneosoft Sales - Estimated Revenue Over Time
Figure 4.16. Estimated Revenue Over Time

4.12.3. Sales Stage Gantt Chart

Borneosoft Sales - 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 ).
Borneosoft Sales - Working Days Spent on Each Sales Stage
Figure 4.18. Working Days Spent
on Each Sales Stage
Borneosoft Sales - Calendar 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.
Borneosoft Sales - No of Days for Each Opportunity Sales Stage As Bar Chart
Figure 4.20. No of Days for Each
Opportunity Sales Stage As Bar Chart
Borneosoft Sales - Percentage of Days for Each Opportunity Sales Stage As Pie 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.
Borneosoft Sales - No of Opportunities for Each Source As Bar Chart
Figure 4.22. No of Opportunities for
Each Source As Bar Chart
Borneosoft Sales - Percentage of Opportunities for Each Source As Pie 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.
Borneosoft Sales - No of Opportunities for Each Rating As Bar Chart
Figure 4.24. No of Opportunities for
Each Rating As Bar Chart
Borneosoft Sales - Percentage of Opportunities for Each Rating As Pie 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.
Borneosoft Sales - No of Opportunities for Each Sales Stage As Bar Chart
Figure 4.26. No of Opportunities for
Each Sales Stage As Bar Chart
Borneosoft Sales - Percentage of Opportunities for Each Sales Stage As Pie 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.
Borneosoft Sales - No of Opportunities for Each Sales Stage By Month
Figure 4.28. No of Opportunities for
Each Sales Stage By Month
Borneosoft Sales - No of Opportunities for Each Sales Stage By Day
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 ).
Borneosoft Sales - Generating Quotation from an Opportunity
Figure 5.1. Generating Quotation
from an Opportunity
Borneosoft Sales - Quotation
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.
Borneosoft Sales - Line Items inside Quotation
Figure 5.3. Line Items inside Quotation
Borneosoft Sales - Contacts in Quotation
Figure 5.4. Contacts in Quotation

5.1. Quotation Fields

The fields that need to be entered in quotation details are:
  1. Company name
    It is derived form the account name that is associated with the opportunity.
  2. Status
    Its possible values are:
    1. Rejected
    2. PO Raised
    3. Revised
    4. Acknowledged
    5. Sent and Waiting Response
    6. Draft
  3. Payment Terms
    Its possible values are:
    1. Mutually Defined
    2. Factoring
    3. Promissory Note
    4. Fixed Fee
    5. Lump Sum
    6. Progressive Discount
    7. Bill of Exchange
    8. Cash Against Documents
    9. Certified Cheque
    10. Discount with Advance Payment
    11. Discount with Prompt Pay
    12. Deposit Required
    13. Basic Commission Terms
    14. Secured Account
    15. Letter of Credit At Sight
    16. Usance Bill
    17. Documents Against Payment
    18. Charge Card
    19. Documents Against Acceptance
    20. Irrevocable Letter of Credit
    21. Cash per Vendor Request
    22. Cash with Order
    23. Cash Discount Terms Apply
    24. Cash
    25. Cash On Arrival
    26. Bank Transfer
    27. Cash On Delivery (COD)
    28. Lease Agreement
    29. Letter of Credit
    30. Cost Plus
    31. Trade Acceptance
    32. Dating Given
    33. Credit Controlled
    34. Contract Basis
    35. Supplier Floor Plan
    36. Sell by Note
    37. Inter-Company Account
    38. Consignment
    39. Partial Advice
    40. Payment Upon Completion
    41. Payment Terms Defined in Consolidated Invoice
    42. Complete Payment
    43. Tenor Payment Terms
    44. Nonstandard
    45. Payment by Installments According to Progress (to be Agreed)
    46. Payment by Installments According to Progress (as Agreed)
    47. Advanced Payment
    48. Late Payment
    49. Adjustment Payment
    50. Available by Negotiation
    51. Available by Negotiation with any Bank
    52. Available by Acceptance
    53. Available by Deferred Payment
    54. Available by Sight Payment
    55. Discount
    56. Payment by Installment
    57. Penalty Terms
    58. United States Funds
    59. Previously Agreed Upon
    60. Ultimo
    61. Not Yet Defined
    62. No Charge
    63. Paid Against Statement
    64. Seller to Advise Buyer
    65. 10 Days After End of Month
    66. Elective
    67. Instant
    68. Proximo
    69. Basic Discount Offered
    70. Extended
    71. Mixed
    72. Discount Not Applicable
    73. Deferred
    74. Fixed Date
    75. End of Month
    76. Basic
  4. Ship Via
    Its possible values are:
    1. FedEx
    2. DHL
    3. UPS
  5. Shipping Cost
  6. Tax Rate
    It is used to calculate sales tax.
  7. Quote Date and Quote Expiry Date
  8. Include FOB
  9. Quote No
  10. Customer PO No
  11. Sales Rep.
    It is initially set to the user who generate the quotation
  12. Recipient
    The recipient detail can be
    1. entered manually,
    2. set to the contact detail of one of the contacts in quotation. The contacts are the same as the contacts in opportunity. To set the recipient detail, click the 'Contacts' at the title bar of the related items, click the contact row, and click 'Recipient' button () at the toolbar (Figure 5.5: Selecting Quotation's Contact as Recipient), or
    3. set to the contact detail of one of the contacts in Contact folder and its sub-folders. To set the recipient detail, click the button () next to the 'Recipient:' in quotation detail. A selection window will appear (Figure 5.6: Selecting Contact as Recipient of the Quotation). Select the contact and click 'Accept Selection' button () at the toolbar (Figure 5.7: Selected Contact as Recipient of the Quotation).
  13. Main/Billing Address
    It is derived form the account name that is associated with the opportunity.
  14. Shipping Address
    It is derived form the account name that is associated with the opportunity.
  15. Description
Borneosoft Sales - Selecting Quotation's Contact as Recipient
Figure 5.5. Selecting Quotation's Contact as Recipient
Borneosoft Sales - Selecting Contact as Recipient of the Quotation
Figure 5.6. Selecting Contact
as Recipient of the Quotation
Borneosoft Sales - Selected 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:
  1. S/N
    The line item serial number.
  2. Product name
    It can be modified.
  3. Delivery Date
    It can be modified
  4. Optional (enabled/disabled)
    If it is enabled, the line item will be optional. Its sub total will not be included in the total.
  5. 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.
  6. Hide Adjustment (enabled/disabled)
    If it is enabled and the adjustment is set, the adjustment will not be displayed.
  7. Hide Price/Amount (enabled/disabled)
    If it is enabled, the line item's price and amount will not be displayed.
  8. Hide Sub Total (enabled/disabled)
    If it is enabled, the line item's sub total will not be displayed.
  9. Adjustment Type
    1. Extra Charge USD
    2. Extra Charge %
    3. Discount USD
    4. Discount %
    5. Handling Charge USD
    6. Handling Charge %
  10. By
    This is the value of the adjustment type.
  11. 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.
  12. Taxable
    If it is enabled the line item is taxable. The tax rate is defined in the quotation.
  13. 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.
  14. 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.
  15. 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.
Borneosoft Sales - Inserting Comment Line Item
Figure 5.8. Inserting Comment Line Item
Borneosoft Sales - Inserted 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.
Borneosoft Sales - Inserting Sub Total Line Item
Figure 5.10. Inserting Sub Total Line Item
Borneosoft Sales - Inserted 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.
Borneosoft Sales - Inserting Accumulated Sub Total Line Item
Figure 5.12. Inserting Accumulated Sub Total Line Item
Borneosoft Sales - Inserted 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:
  1. Click the up-down arrow button () of the line item to be moved.
  2. The background of the up-down arrow button will become red. It indicates that the line item is now movable.
  3. Move the cursor to any line item where the line item to be moved will be inserted (Figure 5.14: Moving Line Item).
  4. Click the up-down arrow button again.
  5. The background of the up-down arrow button returns to normal (Figure 5.15: Moved Line Item).
Borneosoft Sales - Moving Line Item
Figure 5.14. Moving Line Item
Borneosoft Sales - Moved Line Item
Figure 5.15. Moved Line Item

5.2.6. Entering and Removing Delivery Date

Borneosoft Sales - Entering Line Item 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

Borneosoft Sales - Generating Quotation in PDF Format
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 ).
Borneosoft Sales - Example of Generated 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:
  1. System template
    This cannot be modified. It may be updated from time to time when software update is released.
  2. 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.
  3. 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.
Borneosoft Sales - Quotation Template
Figure 5.19. Quotation Template
Borneosoft Sales - Quotation Template Tag
Figure 5.20. Quotation Template Tag
The following list is the quotation tags with their tag values:
  1. Company Name
    {{companyname}}
  2. Company Full Address (Address Line 1, 2, and 3, City, State or US State, Country and Zip Code)
    {{companyfulladdress}}
  3. Company Address (Address Line 1, 2, and 3, and City)
    {{companyaddress}}
  4. Company Address Line 1
    {{companyaddressline1}}
  5. Company Address Line 2
    {{companyaddressline2}}
  6. Company Address Line 3
    {{companyaddressline3}}
  7. Company City
    {{companycity}}
  8. Company State/Province or US State, Zip Code and Country
    {{companystatecountry}}
  9. Company State
    {{companystate}}
  10. Company US State
    {{companyus_state}}
  11. Company Zipcode/Postcode
    {{companyzipcode}}
  12. Company Country
    {{companycountry}}
  13. Company Telephone and Fax
    {{companytelephonefax}}
  14. Company Telephone
    {{companybusinesstelephone}}
  15. Company Telephone Ext.
    {{companybusinessphoneext}}
  16. Company Fax
    {{companyfax}}
  17. Shipping Full Address (Address Line 1, 2, and 3, City, State or US State, Country and Zip Code)
    {{shippingfulladdress}}
  18. Shipping Address (Address Line 1, 2, and 3, and City)
    {{shippingaddress}}
  19. Shipping Address Line 1
    {{shippingaddressline1}}
  20. Shipping Address Line 2
    {{shippingaddressline2}}
  21. Shipping Address Line 3
    {{shippingaddressline3}}
  22. Shipping City
    {{shippingcity}}
  23. Shipping State/Province or US State, Zip Code and Country
    {{shippingstatecountry}}
  24. Shipping State
    {{shippingstate}}
  25. Shipping US State
    {{shippingus_state}}
  26. Shipping Zipcode/Postcode
    {{shippingzipcode}}
  27. Shipping Country
    {{shippingcountry}}
  28. Shipping Telephone, Ext, and Fax
    {{shippingtelephonefax}}
  29. Shipping Business Telephone
    {{shippingbusinesstelephone}}
  30. Shipping Business Telephone Extension
    {{shippingbusinessphoneext}}
  31. Shipping Fax
    {{shippingfax}}
  32. Contact Full Address (Address Line 1, 2, and 3, City, State or US State, Country and Zip Code)
    {{contactfulladdress}}
  33. Contact Address (Address Line 1, 2, and 3)
    {{contactaddress}}
  34. Contact Address Line 1
    {{contactaddressline1}}
  35. Contact Address Line 2
    {{contactaddressline2}}
  36. Contact Address Line 3
    {{contactaddressline3}}
  37. Contact City
    {{contactcity}}
  38. Contact State/Province or US State, Zip Code and Country
    {{contactstatecountry}}
  39. Contact State
    {{contactstate}}
  40. Contact US State
    {{contactus_state}}
  41. Contact Zipcode/Postcode
    {{contactzipcode}}
  42. Contact Country
    {{contactcountry}}
  43. Contact Telephone and Fax
    {{contacttelephonefax}}
  44. Contact Business Telephone
    {{contactbusinesstelephone}}
  45. Contact Business Telephone Extension
    {{contactbusinessphoneext}}
  46. Contact Fax
    {{contactfax}}
  47. Contact Title and Full Name
    {{contacttitlefullname}}
  48. Contact Title
    {{contacttitle}}
  49. Contact Full Name (First Name, Middle Name and Last Name)
    {{contactfullname}}
  50. Contact First Name
    {{contactfirstname}}
  51. Contact Middle Name
    {{contactmiddlename}}
  52. Contact Last Name
    {{contactlastname}}
  53. Contact Suffix Name
    {{contactsuffixname}}
  54. My Company Name
    {{mycompanyname}}
  55. My Company Full Address (Address Line 1, 2, and 3, City, State or US State, Country and Zip Code)
    {{mycompanyfulladdress}}
  56. My Company Address (Address Line 1, 2, and 3, and City)
    {{mycompanyaddress}}
  57. My Company Address Line 1
    {{mycompanyaddressline1}}
  58. My Company Address Line 2
    {{mycompanyaddressline2}}
  59. My Company Address Line 3
    {{mycompanyaddressline3}}
  60. My Company City
    {{mycompanycity}}
  61. My Company State/Province or US State, Zip Code and Country
    {{mycompanystatecountry}}
  62. My Company State
    {{mycompanystate}}
  63. My Company US State
    {{mycompanyus_state}}
  64. My Company Zipcode/Postcode
    {{mycompanyzipcode}}
  65. My Company Country
    {{mycompanycountry}}
  66. My Company Telephone, Ext, Fax and Website
    {{mycompanytelephonefaxwebsite}}
  67. My Company Telephone, Ext, and Fax
    {{mycompanytelephonefax}}
  68. My Company Telephone
    {{mycompanybusinesstelephone}}
  69. My Company Fax
    {{mycompanyfax}}
  70. My Company Website
    {{mycompanywebsite}}
  71. My Company Logo
    {{mycompanylogo}}
  72. Quote No.
    {{quoteno}}
  73. Quote Date
    {{quotedate}}
  74. Quote Expiry Date
    {{quoteexpirydate}}
  75. Payment Terms
    {{paymentterms}}
  76. Ship Via
    {{shipvia}}
  77. FOB
    {{fob}}
  78. Tax Rate
    {{taxrate}}
  79. Sales Tax
    {{salestax}}
  80. Shipping Cost
    {{shippingcost}}
  81. Sales Rep
    {{salesrep}}
  82. 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.
  83. 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.
Borneosoft Sales - Line Items Tag With Delivery Date
Figure 5.21. Line Items Tag
With Delivery Date
Borneosoft Sales - Line Items Tag Without 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 .
Borneosoft Sales - Quotation Template's Header
Figure 5.23. Quotation Template's Header
Borneosoft Sales - Quotation Template's Footer
Figure 5.24. Quotation Template's Footer
Borneosoft Sales - Quotation Page Numbering and Company Logo
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

Borneosoft Sales - 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:
  1. Quotation No
  2. Company name
  3. Quotation Date
  4. Quotation Expiry Date
  5. Quotation Status
    Its possible values are:
    1. Rejected
    2. PO Raised
    3. Revised
    4. Acknowledged
    5. Sent and Waiting Response
    6. Draft

5.5.1. Quotation Search Fields

The quotation search field names are:
  1. 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".
  2. description
  3. companyname
    Customer's company name
  4. status
    Quotation Status
  5. quoteno
    Quotation number
  6. custpono
    Customer PO number
  7. salesrep
    Sales Representative
  8. fob
  9. paymentterms
  10. shipvia
  11. taxrate
  12. taxrate:[0 TO 0]
  13. shippingcost
  14. shippingcost:[0 TO 0]
  15. companyaddress
  16. companycity
  17. companystate
  18. companyus_state
  19. companyzipcode
  20. companycountry
  21. companybusinesstelephone
  22. companyfax
  23. shippingaddress
  24. shippingcity
  25. shippingstate
  26. shippingus_state
  27. shippingzipcode
  28. shippingcountry
  29. shippingbusinesstelephone
  30. shippingfax
  31. contactaddress
  32. contactcity
  33. contactstate
  34. contactus_state
  35. contactzipcode
  36. contactcountry
  37. contactbusinesstelephone
  38. contactbusinessphoneext
    Business telephone extension
  39. contactfax
  40. contactitle
  41. contactfirstname
  42. contactmiddlename
  43. contactlastname
  44. contactsuffixname
  45. contactscreenname

5.5.2. Searching Quotation Date and Quotation Expiry Date

  1. 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.
  2. 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].
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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.
  8. 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).
  9. 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).
  10. 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).
  11. 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:
  1. Click the Account folder or any of its sub-folders where the new account will be put into.
  2. Click the 'New' button at the toolbar, or click the menu: 'Edit', 'New Item', or click the menu: 'File', 'Create New', 'Account'.
  3. An empty account details dialog box will open (Figure 6.1: Empty Account Details).
  4. Select company by clicking the select company button (). A company selection dialog box will appear (Figure 6.2: Selecting Company for an Account).
  5. Select a company and click 'Accept Selection' button ().
  6. 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.
  7. Enter account code and name.
  8. Select the rating of the account. Its possible values are:
    1. Hot
    2. Warm
    3. Cold
  9. Enter the company revenue if it is known or it can be estimated.
  10. Enter the number of employees of the company if it is known or it can be estimated.
  11. Click 'Save' when you finish entering the details.
Borneosoft Sales - Empty Account Details
Figure 6.1. Empty Account Details
Borneosoft Sales - Selecting Company for an Account
Figure 6.2. Selecting Company
for an Account

6.2. Account Fields

The fields that need to be entered in account details are:
  1. Account Code
  2. Account Name
  3. Rating
    Its possible values are:
    1. Hot
    2. Warm
    3. Cold
  4. Annual Revenue
  5. Number of Employee
  6. Company
    An account must be associated with a company. The company details can be selected by clicking company selection button ().
  7. 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

Borneosoft Sales - Account List View
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:
  1. Account Name
  2. Account Code
  3. Company Name
  4. Company's City
  5. Company's Telephone
  6. Company's Fax
  7. Company's Website
  8. Account's Rating
  9. Account's Revenue

6.4. Account Search Fields

The account search field names are:
  1. 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".
  2. description
  3. accountcode
  4. accountname
  5. annualrevenue
  6. annualrevenue:[0 TO 0]
  7. noofemployee:000000000
  8. noofemployee:[000000000 TO 000000000]
  9. rating
  10. Company search field names:
    1. companyname
    2. industrytype
    3. addressline
    4. city
    5. state
    6. us_state
    7. zipcode
    8. country
    9. businesstelephone
    10. fax
    11. website
    12. shippingaddressline
    13. shippingcity
    14. shippingstate
    15. shippingus_state
    16. shippingzipcode
    17. shippingcountry
    18. shippingbusinesstelephone
    19. shippingfax