Viindoo demo handbook for trading and distribution

Part II. Sales and CRM

This part answers the questions of the manager and the sales team: how a customer's price request goes from an opportunity to a quotation, what price a regular customer and a reseller get, how much margin each quotation earns, how to ask for approval when a quotation has a low margin, and what the system does by itself when the customer agrees (deliver from the warehouse, assemble at the Assembly Workshop, or order from the supplier). The part ends with the sales and CRM reports and a practice exercise.

This part uses two customers of Tân Việt Số: Công ty CP Kính Kỹ thuật Nam Cường (a regular customer on the "Standard Price List", payment in 15 days) and Nhà máy Nội thất Kim Sơn Hà (a reseller on "Reseller Price (5% off)", payment in 30 days). Your company creates every document in this part yourself; the document numbers in the screenshots (S00216, S00217, HN/OUT/00081, XLR/MO/00071, P00266...) come from the trial run made while writing the handbook. When you follow the lessons, the system assigns new numbers. The selling prices, costs and gross margin percentages of the products in the lessons will match if you choose the same products and quantities as the lesson.

Lesson 9. Read the running sales and CRM configuration

About 15 minutes. By the end of this lesson your company knows what the system has switched on for sales, who the two price lists are for, which stages an opportunity goes through, how the approval request for quotations is configured, and what you lose if a setting is turned off. This lesson is read-only; nothing is changed.

Step 1 - Open the sales settings

Click Sales, open the Configuration menu, and click Settings. In the left column of the settings screen click Sales, then scroll down to the Pricing section.

PathSales > Configuration > Settings
Sales settings, Pricing section: Discounts, Pricelists and Margins are ticked

What you should see: in the Pricing section the three boxes Discounts, Pricelists and Margins are ticked. Scroll down to the Quotations & Orders section and you will also see Online Signature and PDF Quote builder ticked; Quotation Templates, Sale Warnings and Lock Confirmed Sales are not ticked.

The table below shows what each setting does now and what you lose if it is not switched on:

Setting Status What you lose if it is off
Pricelists On Every customer uses a single selling price; there is no separate price for resellers.
Discounts On The Disc.% column disappears from the quotation lines, so you cannot discount an individual line. The reseller price of Kim Sơn Hà also appears in this column (next lesson).
Margins On The Cost, Margin and Margin (%) columns disappear from the lines, and so does the Margin line in the quotation totals; the salesperson cannot tell whether an order makes a profit or a loss before closing it.
Online Signature On The customer has no Accept & Sign button on the quotation page and has to confirm in another way.
PDF Quote builder On You cannot add an opening page, product descriptions or a closing page to the PDF quotation.
Delivery Methods On The shipping fee cannot be calculated on the order.
Quotation Templates Off Every quotation is typed line by line from scratch, with no default set of products. Switch it on when you sell repeated machine bundles.
Sale Warnings Off There is no warning in the order for a customer or a product.
Lock Confirmed Sales Off A confirmed order can still have its lines edited. Switch it on when you want to freeze confirmed orders.

The system does not lock the selling price: the salesperson can still edit the unit price on a quotation line, even though the price is taken from the price list by default.

Step 2 - See the two price lists

Click Products and choose Pricelists.

PathSales > Products > Pricelists
List of two price lists: Standard Price List and Reseller Price (5% off)

What you should see: two rows, Standard Price List and Reseller Price (5% off), both in the currency VND.

Step 3 - Open Reseller Price (5% off)

Click the row Reseller Price (5% off).

PathSales > Products > Pricelists > Reseller Price (5% off)
Reseller price list with one rule: All Products, 5 % discount on sales price

What you should see: the Sales Prices tab has exactly one rule: Apply on "All Products", Price "5 % discount on sales price". The Standard Price List has no rule at all: customers use the selling price written on the product. If you want resellers to buy a product group at a different rate, add a rule line here.

Step 4 - See which customer uses which price list

Click Contacts, open Công ty CP Kính Kỹ thuật Nam Cường, and click the Sales & Purchase tab. Do the same for Nhà máy Nội thất Kim Sơn Hà.

PathContacts > Công ty CP Kính Kỹ thuật Nam Cường > Sales & Purchase
Nam Cường record: Standard Price List, 15-day terms
Kim Sơn Hà record: Reseller Price (5% off), 30-day terms

What you should see: in the SALES section, Nam Cường has Pricelist "Standard Price List (VND)" and Payment Terms "15 Days"; Kim Sơn Hà has "Reseller Price (5% off) (VND)" and "30 Days". When you create a quotation for a customer, the system uses these two fields as the default.

Step 5 - See the stages of the sales pipeline

Click CRM, open the Configuration menu, choose Pipeline, and click Stages.

PathCRM > Configuration > Pipeline > Stages
Four stages: New, Qualified, Proposition, Won

What you should see: four stages in the order New, Qualified, Proposition, Won. Only Won has the Is Won Stage? column ticked: an opportunity that reaches this stage counts as won. The CRM reports split their columns by exactly these four stages.

Step 6 - See the sales teams

Click CRM, open the Configuration menu, and click Sales Teams.

PathCRM > Configuration > Sales Teams
List of sales teams: Sales, Project Sales, Website

What you should see: the list of teams, in which the Sales team has Administrator as its Team Leader. A team is attached to quotations and to opportunities; the sales reports split their columns by team (see the reports lesson). Without teams the reports cannot compare sales channels.

Step 7 - See the approval type "Quotation"

Click Approval, open the Configuration menu, and click Approval Types. In the list click the row Quotation.

PathApproval > Configuration > Approval Types
List of approval request types, including the row Quotation (Quotation / Sales Order)
Quotation type: request lines enabled, extra approval step approved by Administrator

What you should see: the Quotation type has Type "Quotation / Sales Order", Enable Request Lines ticked (every quotation line becomes a line of the request), and in the EXTRA APPROVAL STEPS section one step "Specific Approvers" with Administrator.

The system only reminds you when a quotation has an approval request that is not finished. It does not force approval by a gross margin percentage threshold and does not lock the Confirm button of the quotation; a hard block is additional development.

Lesson 10. From a CRM opportunity to a quotation with cost and margin

About 20 minutes. By the end of this lesson your company has created an opportunity for Nam Cường, moved it through the stages, scheduled activities, created a quotation straight from the opportunity, switched on the cost and margin columns to read the profit of each line and of the whole order, and then created a quotation for the same goods for Kim Sơn Hà to see how the reseller price differs from the standard price.

Step 1 - Open the sales pipeline

Click CRM, open the Sales menu, and click My Pipeline.

PathCRM > Sales > My Pipeline
Sales pipeline as cards in four stage columns

What you should see: opportunities as cards arranged in the four columns New, Qualified, Proposition and Won; the top of each column shows the total expected revenue. The top row of buttons has New and Generate Leads; the top right corner has the view buttons (kanban, list, calendar, pivot, graph, cohort, map, activity). In the screenshot the pipeline is filtered to the salesperson Administrator, which is what My Pipeline shows when Administrator is the logged-in user.

Step 2 - Quickly add an opportunity

Click the + sign in the New column. In the company field at the top of the card type Nam Cường and choose Công ty CP Kính Kỹ thuật Nam Cường. In the opportunity name field type Nam Cường - bộ chuyển mạch POE và máy lắp ráp DPC-9100. In the revenue field type 60000000. Click Add.

PathCRM > Sales > My Pipeline
Quick-add card filled in with the company, opportunity name and revenue 60,000,000

What you should see: the new card sits in the New column and shows the opportunity name, the revenue 60,000,000 ₫ and the company Nam Cường.

Step 3 - Open the opportunity

Click the card you just created.

PathCRM > Sales > My Pipeline
Opportunity screen: the New Quotation, Won and Lost buttons and the stage bar

What you should see: the opportunity screen has the buttons New Quotation, Won, Enrich and Lost; the stage bar starts at New; Contact is Nam Cường, Salesperson is the logged-in user, and the Probability field is filled in automatically. The screenshot was taken after the opportunity had been won, so it shows the WON stamp and the stage bar at Won; your own opportunity starts at New.

Step 4 - Schedule an activity

In the chatter on the right click Activity. In the Schedule Activity box choose Call, type Gọi xác nhận cấu hình bộ chuyển mạch POE in Summary, and click Mark Done. Open the box again, choose To-Do, type Chốt lịch giao hàng với khách, and click Save.

Paththe opportunity screen, the chatter, the Activity button
Schedule Activity box: the activity types To-Do, Email, Call, Meeting, Document
Chatter showing the completed call and the scheduled to-do

What you should see: the box has five activity types, a Due Date field, an Assigned to field and three buttons Save, Mark Done and Discard. After you finish, the chatter logs the completed call with its summary and shows the pending activity Chốt lịch giao hàng với khách under Planned Activities. A completed activity is counted in the Activities report in the reports lesson. In the screenshot the pending activity is already overdue and the chatter also lists the later stage changes, because the opportunity has moved on since.

Step 5 - Move the opportunity through the stages

On the stage bar click Qualified, then click Proposition.

Paththe opportunity screen, the stage bar at the top
Opportunity at the Qualified stage
Opportunity at the Proposition stage

What you should see: the selected stage is highlighted and shows the time spent in it; the Probability field changes with the stage (in the screenshots, other open opportunities show 35 % at Qualified and 70 % at Proposition); the chatter records every stage change.

Step 6 - Create a quotation from the opportunity

Click New Quotation.

Paththe opportunity screen, the New Quotation button
New quotation opened from the opportunity: customer Nam Cường, Standard Price List, 15-day terms

What you should see: the new quotation screen already has Customer (Nam Cường, with the address), Pricelist "Standard Price List (VND)", Payment Terms "15 Days" and Expiration filled in; the status bar shows Quotation, Quotation Sent, Sales Order. You do not have to retype the customer's details.

Step 7 - Add two product lines

Click Add a product, type TL-SG3218PE, choose [CS-PK-TP-LINK TL-SG3218PE-VN] 16port POE TP-LINK TL-SG3218PE, and in Quantity type 2. Click Add a product again, type IN-PS-MDR-40-24-MEA, choose Computer Power Supply IN-PS-MEA-24V-40W-VN, and set Quantity to 4.

Paththe quotation screen, the Order Lines tab, the Add a product button
Two lines with unit prices taken from the Standard Price List and the totals

What you should see: the unit prices 2,710,000 and 1,939,000 are filled in from the Standard Price List, tax 10 %, and Amount 5,420,000 and 7,756,000. The totals show Untaxed Amount 13,176,000, VAT 10% 1,317,600 and Total 14,493,600; at the bottom is Margin 3,264,000 (24.77%).

Step 8 - See the delivery warehouse of the quotation

Click the Other Info tab and look at the DELIVERY section.

Paththe quotation screen, the Other Info tab
Other Info tab: the warehouse is Kho Hà Nội

What you should see: Warehouse is "Kho Hà Nội": goods that are in stock on this quotation will be delivered from that warehouse. The same tab has Salesperson, Sales Team and Opportunity (a link back to the opportunity you just created). Click the Order Lines tab again to continue.

Step 9 - Switch on the cost and margin columns

At the end of the header row of the order lines table click the column-selection icon. Tick Cost, Margin and Margin (%).

Paththe quotation screen, the Order Lines tab, the column-selection icon at the end of the header row
List of columns you can switch on: Cost, Margin and Margin (%) are not ticked yet

What you should see: the list of columns (Product Variant, Product, Description, Routes, Unit, Lead Time, Cost, Margin, Margin (%), Taxes, Disc.%, Tax Incl.). The three profit columns are off by default; once ticked they appear on the table immediately.

Step 10 - Save the quotation and read the margin

Click the save icon (the cloud) next to the quotation name.

Paththe quotation screen, the save icon next to the quotation name
Quotation S00216 saved, with the Cost, Margin and Margin (%) columns

What you should see: the quotation has a new number (S00216 in the trial run). The switch row: cost 2,108,000, margin 1,204,000, 22.21 %. The computer power supply row: cost 1,424,000, margin 2,060,000, 26.56 %. The line formula: Margin = Amount minus Cost times Quantity (first line: 5,420,000 minus 2,108,000 times 2 is 1,204,000). At the bottom of the quotation, the Margin of the whole order is the sum of the two lines: 3,264,000 (24.77%). The screenshot shows the order after it has been confirmed, which is why the status bar is at Sales Order.

The cost comes from the cost recorded on the product. Every internal user sees these three columns; the customer only sees the selling price (see the preview step in the next lesson).

Step 11 - Create the same quotation for the reseller

Click Sales, open the Orders menu, click Quotations, and click New. Choose the customer Nhà máy Nội thất Kim Sơn Hà, add exactly the same two lines as above (2 switches, 4 computer power supplies), switch on the three profit columns, and save.

PathSales > Orders > Quotations
Kim Sơn Hà quotation: reseller price, Disc.% shows 5.00 and the margin is lower

What you should see: Pricelist is automatically "Reseller Price (5% off) (VND)" and Payment Terms "30 Days". The Unit Price is still 2,710,000 and 1,939,000, but the Disc.% column shows 5.00, so the Amount of the first line is 5,149,000 (5,420,000 minus 5 %). The totals: Untaxed Amount 12,517,200, Total 13,768,920, Margin 2,605,200 (20.81%). For the same goods the reseller pays less and your margin is lower than with the regular customer: the switch row is at 18.12 % compared with 22.21 %.

Lesson 11. Ask for low-margin approval, send the quotation, confirm three kinds of orders, and cancel

About 35 minutes. By the end of this lesson your company has created a quotation with a very low margin and asked for approval, seen that the system only reminds and does not block confirmation, viewed a quotation the way the customer sees it, confirmed three kinds of orders (stock goods delivered from Kho Hà Nội, an assembled machine built to order at the Assembly Workshop, and a server ordered to order) and seen which documents each one creates, then cancelled a quotation and marked an opportunity as lost.

Step 1 - Create a low-margin quotation

Click Sales, open the Orders menu, click Quotations, and click New. Choose the customer Công ty CP Kính Kỹ thuật Nam Cường, add one line TL-SG3218PE with quantity 1, and in the Disc.% column type 20. Switch on the three profit columns and save.

PathSales > Orders > Quotations
Quotation with a 20 % discount: margin 60,000, only 2.77 % left

What you should see: Unit Price 2,710,000, Cost 2,108,000, Disc.% 20.00, Amount 2,168,000. The Margin of the line is only 60,000 and Margin (%) is 2.77 %; the bottom of the quotation also shows Margin 60,000 (2.77%). The system does not block the quotation or raise an error because of the low margin: this is the point where an approver steps in. The screenshot was taken before saving, so the title still reads New instead of a quotation number.

Step 2 - Ask for approval of the quotation

At the top of the quotation click the gear icon next to the quotation number and choose Get Approved. In the Submit for Approval box check that Approval Request Type is "Quotation", and click Create Approval Request.

Paththe quotation screen, the gear next to the quotation number, Get Approved
Submit for Approval box: type Quotation and the source record is the open quotation
New approval request in the Draft status, with the Submit button

What you should see: the box states that the quotation is configured as "One record per approval request", which means one request for each line; the Source Records tab lists the open quotation. Click Create Approval Request and a new request opens, with a code such as APVL00004, the status Draft, the title "Báo giá cho S00231 từ Administrator", and the buttons Submit and View Quotation; the Sales Orders button at the top leads back to the quotation.

Step 3 - Submit the request

Click Submit.

Paththe approval request screen, the Submit button
Request in the To Approve status, next approver is Nguyễn Hải Sơn

What you should see: the status bar moves to To Approve; Next Approver(s) is Nguyễn Hải Sơn (the Director, the direct manager of the employee). The person who submitted sees the buttons Cancel, Withdraw, Force Approval and Force Refuse; the Approve button only shows for the person chosen to approve, that is Nguyễn Hải Sơn when he logs in. The history of who approved and when is stored on the request itself.

Step 4 - Go back to the quotation and confirm it, without being blocked

Click View Quotation. The quotation now carries the stamp WAITING FOR APPROVAL. Click Confirm.

PathSales > Orders > Quotations
Quotation with the WAITING FOR APPROVAL stamp, the Confirm button still works
After confirming: status Sales Order, the WAITING FOR APPROVAL stamp is still there

What you should see: before you click, the quotation is at Quotation, the Confirm button is still usable, and the chatter notes that an approval request was created. After you click, the quotation moves to Sales Order (the Delivery button appears at the top) while the yellow stamp WAITING FOR APPROVAL stays. The system only reminds and does not block confirmation: if your company wants a hard block, that is additional development.

Step 5 - View the quotation as the customer sees it

Open the Nam Cường quotation from the previous lesson again (two lines, total 14,493,600) and click Preview.

PathSales > Orders > Quotations
Customer quotation page: unit price, tax, total and the Accept & Sign button

What you should see: the customer's quotation page with the Tân Việt Số logo, the untaxed amount, the VAT 10 %, the total, the payment terms "15 Days", the Accept & Sign button and a button to view the details. The customer does not see the cost and margin. The blue strip at the top says that this is a preview of the customer portal; click the link in it to go back to edit mode. Nothing is sent outside. The customer page is shown in the website language, which is Vietnamese on this demo system, so its labels appear in Vietnamese in the screenshot.

Step 6 - Print the PDF and open the email to the customer

On the quotation click Print: the system downloads the file "Quotation - Sxxxxx.pdf" straight away. Then click Send: the email box opens; when you have looked at it, click Discard.

Paththe quotation screen, the Print button and the Send button
First page of the PDF quotation: logo, customer, lines and totals
Email box for sending the quotation: recipient, subject, body and the PDF attachment

What you should see: the PDF has the company logo and address, the customer, the quotation date, the expiry date, the salesperson, the lines (with the discount % if any), the untaxed amount, the tax, the total and the payment terms; it is printed in the customer's language, which is Vietnamese for this customer, so the screenshot shows Vietnamese labels, and the print has no cost or margin. The Send box has the customer in To, a Subject such as "Công ty TNHH Công nghệ Tân Việt Số Báo giá (Ref ...)", the body of the email and the file "Báo giá - Sxxxxx.pdf" attached. Only click Send inside the box when you really want the email to go to the customer's address; in this lesson you click Discard, so no email leaves the system.

Step 7 - Mark the quotation as sent

Click the gear next to the quotation number and choose Mark Quotation as Sent.

Paththe quotation screen, the gear next to the quotation number, Mark Quotation as Sent
Quotation in the Quotation Sent status

What you should see: the status bar moves to Quotation Sent; the chatter records "Quotation sent". Use this when you have already sent the quotation to the customer by another channel.

Step 8 - Confirm the stock-goods order

On the two-line Nam Cường quotation (goods in stock at Kho Hà Nội), click Confirm.

PathSales > Orders > Quotations
Nam Cường order after confirmation: the Delivery 1 button, status Sales Order

What you should see: the status is Sales Order, the Order Date is the moment of confirmation, the lines table gains the columns Delivered and Invoiced (0.00), and at the top there is a Delivery button with the number 1. The chatter records "Quotation confirmed".

Step 9 - Open the delivery from Kho Hà Nội

Click the Delivery button.

Paththe sales order screen, the Delivery button
Delivery order HN/OUT: source location HN/Tồn kho, two lines Available

What you should see: a transfer such as HN/OUT/xxxxx, Operation Type "Kho Hà Nội: Delivery Orders", Source Location "HN/Tồn kho", Source Document the sales order number, the status Ready, and both lines marked Available with quantities 2 and 4. The warehouse keeper validates this transfer to deduct the stock (see the Inventory part). The "Available" figure changes with the real stock at the time your company does the lesson.

Step 10 - Move the opportunity to Won

Open the opportunity you created in the previous lesson and click Won.

PathCRM > Sales > My Pipeline
Opportunity at the Won stage, Probability 100 %

What you should see: the stage bar is at Won, the probability is 100 %, and the opportunity card sits in the Won column of the pipeline. Confirming the sales order does not move the opportunity to Won by itself: the salesperson clicks Won to close it.

Step 11 - Create a quotation for a machine assembled to order

Create a new quotation for Nhà máy Nội thất Kim Sơn Hà, add the line DPC-9100-THP (choose [DPC-9100-THP] All-in-One Computer Set DPC-9100), quantity 1. Click the Other Info tab and in the Warehouse field choose Xưởng lắp ráp. Save.

PathSales > Orders > Quotations
Assembled-machine order: the warehouse is Xưởng lắp ráp, reseller price list

What you should see: Warehouse reads "Xưởng lắp ráp". Because Kim Sơn Hà is a reseller, Pricelist is "Reseller Price (5% off) (VND)"; the machine line has the price 31,979,000, Disc.% 5.00, Amount 30,380,050, Cost 25,583,000, Margin 4,797,050 (15.79%) and Total 33,418,055 (tax included). An assembled machine has a bill of materials; the warehouse must be Xưởng lắp ráp for the system to create the manufacturing order there.

Step 12 - Confirm and see the manufacturing order created by itself

Click Confirm, then click the Manufacturing button (number 1).

Paththe sales order screen, the Confirm button, then the Manufacturing button
Assembled-machine order after confirmation: two buttons, Delivery 1 and Manufacturing 1
Manufacturing order XLR/MO created by itself: product, bill of materials and the components to consume

What you should see: after confirmation the order has two buttons, Delivery (a transfer out of the Assembly Workshop that waits until the machine is assembled) and Manufacturing (the manufacturing order). The order has a code such as XLR/MO/xxxxx and the status Confirmed; Product is the DPC-9100 machine, quantity 1, Bill of Material is the machine's bill of materials, and the Components tab lists the components to consume (chassis set, CPU, RAM and SSD drive, one of each). Component Status tells you whether the Workshop has all the components; "Not Available" means the Workshop must first be supplied with components (by purchase or transfer) before assembling (see the Purchasing part and the Assembly to order part). Your company does not need to click Produce All in this lesson.

Step 13 - Create and confirm a quotation for a server ordered to order

Create a new quotation for Công ty CP Kính Kỹ thuật Nam Cường, add the line ESC8000A-E13-WOCPU089Z (choose AI Server ASUS ESC8000A-E13 Asus, not the Barebone line), quantity 1. Leave the warehouse at its default, Kho Hà Nội. Save, then click Confirm.

PathSales > Orders > Quotations
Server order after confirmation: two buttons, Delivery 1 and Purchase 1

What you should see: the order has a Delivery button (a transfer out that waits for the goods to arrive) and a Purchase button (number 1). This server has no assembly bill of materials but it has a supplier, so the system switches to purchasing to order. The selling price is 136,292,000 before tax, total 149,921,200; Cost 112,638,000, Margin 23,654,000 (17.36%).

Step 14 - See the supplier request for quotation created by itself

Click the Purchase button.

Paththe sales order screen, the Purchase button
Request for quotation P00266 sent to the supplier, one server line, draft status

What you should see: a new Request for Quotation (a code such as Pxxxxx) in the status RFQ, the Vendor already filled in (in the trial run: Công ty CP Nhật Hải Tech), Deliver To "Kho Hà Nội: Receipts", one server line of 1 set, the unit price taken from the vendor price list (112,638,000) and a total of 123,901,800; the Sale button at the top leads back to the sales order. Every sales order creates its own request. Your company only looks at it here; sending and confirming the request is the job of the purchasing staff (see the Purchasing part), so do not click Confirm Order in this lesson.

Step 15 - Cancel a quotation

Create a new quotation for Kim Sơn Hà with one line IN-PS-MDR-40-24-MEA, quantity 1, and save. Click Cancel. In the Confirmation box that asks "Are you sure you want to cancel this order? This may affect related documents or processes." click Ok.

PathSales > Orders > Quotations
Confirmation box for cancelling the order
Quotation in the Cancelled status, with the Set to Quotation button

What you should see: the quotation moves to the status Cancelled; the remaining buttons are Print, Preview and Set to Quotation (to reopen it if the customer changes their mind). A cancelled quotation creates no transfer, manufacturing order or purchase request.

Step 16 - Mark an opportunity as lost

In the sales pipeline quickly add an opportunity for Nhà máy Nội thất Kim Sơn Hà named Kim Sơn Hà - nguồn máy tính cho dây chuyền ghế, revenue 8000000. Open the card, click Lost, choose the reason Too expensive, and click Mark as Lost.

PathCRM > Sales > My Pipeline
An open opportunity before it is marked lost
Mark Lost box with three reasons and a note field
The reason Too expensive selected
Opportunity with the LOST stamp, Lost Reason Too expensive, and the Restore button

What you should see: the Mark Lost box lists the reasons Too expensive, We don't have people/skills, Not enough stock and a Closing Note field. After you mark it, the opportunity carries the LOST stamp, the Lost Reason field reads "Too expensive", the probability goes back to 0 and the Restore button appears. A lost opportunity is archived and disappears from the sales pipeline; the Restore button brings it back.

Lesson 12. Sales and CRM reports

About 20 minutes. By the end of this lesson your company knows which report answers each management question about sales and CRM, and can read the margin by customer, salesperson and product. This lesson is view-only and creates no documents. The figures in the reports change with the date and with the documents people are working on in the system, so the lesson only describes how to read them.

Report name Path Question it answers
Sales Analysis Sales > Reporting > Sales What are the revenue and margin of each month, split by sales team (Sales, Project Sales, Website)?
Sales Analysis By Customers Sales > Reporting > Customers Which customers bring the most revenue and margin? How much lower is the margin on resellers than on regular customers?
Sales Analysis By Salespersons Sales > Reporting > Salespersons How much does each salesperson sell and how much margin do they bring in?
Sales Analysis By Products Sales > Reporting > Products Which products sell best and which earn the most margin?
Forecast CRM > Reporting > Forecast How much revenue is expected to close in each month (multiplied by probability)? How many opportunities have no closing date yet?
Activities CRM > Reporting > Activities How many calls and to-dos has each salesperson completed, by month and by type?
Pipeline Analysis CRM > Reporting > Pipeline Which stage are the opportunities in, how much are they worth, by expected closing month? The cohort and map views are below.
Leads Analysis CRM > Reporting > Leads How are leads and opportunities created by month and by sales team?
Sales pipeline cohort CRM > Sales > My Pipeline, the Cohort view For opportunities created in the same week, what percentage has closed after how many weeks?
Opportunity map CRM > Sales > My Pipeline, the Map view Where are the opportunities, by customer address?
Activities on opportunities CRM > Sales > My Pipeline, the Activity view Which activities does each opportunity have, of which type, and due when?
My Activities CRM > Sales > My Activities What do I have to do today, on which opportunity?
My Quotations CRM > Sales > My Quotations In which status are the quotations I created?
Approver Workload, Approval Analysis, Overview Approval > Reports How many approval requests (including low-margin quotations) are waiting, approved or refused?
Invoice & Bill Analysis Accounting > Reporting > Management > Invoice & Bill Analysis How much has been invoiced (see the Accounting part).

Step 1 - Read the margin by month and by team

Click Sales, open the Reporting menu, and click Sales. Click the Pivot icon in the top right corner. Click Measures, tick Untaxed Total and Margin, and untick Qty Ordered.

PathSales > Reporting > Sales
Sales Analysis as a pivot: rows are months, columns are sales teams, measures Untaxed Total and Margin

What you should see: the rows are the order months, the columns are the teams (Sales, Project Sales, Website) plus a Total column; each group has two measures, Untaxed Total and Margin. By default the report opens as a chart of the quantity ordered, so you need to switch to Pivot and change Measures as above to see the margin. The default filter is sales orders in the last 365 days.

Step 2 - Read the margin by customer

Click Sales, open the Reporting menu, and click Customers. Switch to Pivot, choose the Measures as in step 1, and click the Margin column header twice to sort from high to low.

PathSales > Reporting > Customers
Pivot by customer, sorted by margin from high to low

What you should see: each row is a customer (filtered to the last 365 days), the customer with the highest margin is at the top, and the columns are split by sales team. To find Nam Cường or Kim Sơn Hà, type the customer name in the search box. Divide the Margin by the Untaxed Total of a customer to get that customer's margin percentage; resellers are usually lower than regular customers because the reseller price is 5 % off.

Step 3 - Read the margin by salesperson

Click Sales, open the Reporting menu, click Salespersons, switch to Pivot, and choose the measures as above.

PathSales > Reporting > Salespersons
Pivot by salesperson

What you should see: each row is a salesperson (and a row "None" for orders with no salesperson assigned), and the columns are split by team. A quotation a salesperson creates while doing this lesson lands in that person's own row.

Step 4 - Read the margin by product

Click Sales, open the Reporting menu, click Products, switch to Pivot, and choose the measures as above.

PathSales > Reporting > Products
Pivot by product, sorted by margin from high to low

What you should see: each row is a product (with its code in square brackets), sorted by margin. The table is wide; scroll sideways to see the columns of the other teams.

Step 5 - See the CRM revenue forecast

Click CRM, open the Reporting menu, and click Forecast.

PathCRM > Reporting > Forecast
Forecast as cards by expected closing month

What you should see: the columns by expected closing month; the first column is "None" for opportunities without a closing date. The total at the head of a column is the expected revenue multiplied by probability: an open opportunity is counted by its current probability, and a won opportunity (a card with the WON stamp) is counted in full. In the screenshot, the 60,000,000 opportunity of Nam Cường has an expected closing date of 15 November, so it sits in the November 2026 column. By default only your own opportunities are shown; remove the filters to see the whole team. For an opportunity to land in the right month, fill in Expected Closing on the opportunity screen.

Step 6 - See the activities report

Click CRM, open the Reporting menu, and click Activities.

PathCRM > Reporting > Activities
Activities report: number of completed activities by month

What you should see: a chart of the completed activities by month (the default filter is the trailing 12 months). The report only counts activities that were marked done with Mark Done; when no activity has been completed, the screen shows an empty-state message with a faded sample chart. The call completed in the previous lesson is counted in the October 2026 column.

Step 7 - See the pipeline analysis and the leads analysis

Click CRM, open the Reporting menu, and click Pipeline; then open Leads.

PathCRM > Reporting > Pipeline > CRM > Reporting > Leads
Pipeline Analysis: opportunity value by stage, split by closing month
Leads Analysis: number of records by creation month, split by team

What you should see: the pipeline report draws the opportunity value for each stage (New, Qualified, Proposition, Won), each colour is an expected closing month, and the line is the cumulative total. The leads report counts records by creation month and by team. Both also have pivot, list, cohort and map views in the top right corner.

Step 8 - See the cohort view and the activity view of the pipeline

Click CRM, open the Sales menu, and click My Pipeline. In the top right corner click the Cohort icon, then the Activity icon (the clock).

PathCRM > Sales > My Pipeline
Cohort: rows are the creation week, columns are the weeks to the closing date, cells are percentages
Activity view: opportunities in rows, activity types in columns

What you should see: in the Cohort view, each row is a week in which opportunities were created, with its Count; the columns "+ 0", "+ 1", ... are the number of weeks from creation to the closing date, and each cell shows the percentage that has closed. When all opportunities were created in the same week (as in the sample data) there is only one row; the more weeks of creation, the more the table shows how long opportunities take to close. In the Activity view each opportunity has a row, and a pending activity sits in the column of its type (for example "Chốt lịch giao hàng với khách" in the To-Do column); the Schedule activity link at the bottom adds one quickly. The Map view (the pin icon) places the opportunities on a map by customer address and needs an internet connection to load the map background.

Lesson 13. Practice exercise: a day in the life of a salesperson

About 30 minutes, with no step-by-step screenshots; do the tasks in order, then compare with the "Self-check" section. The lesson reuses the actions of the three previous lessons, on new documents of your company.

Scenario. Nhà máy Nội thất Kim Sơn Hà and Công ty CP Kính Kỹ thuật Nam Cường both ask for the price of three TL-SG3218PE POE switches. Your company compares the prices for the two customers, tries a low-margin quotation, closes one order and sees what the system does, then loses an opportunity.

Task 1 (5 minutes). In CRM > Sales > My Pipeline add the opportunity Kim Sơn Hà - ba bộ chuyển mạch POE for Kim Sơn Hà, revenue 30,000,000. Move it to Qualified and Proposition, fill in Expected Closing as the 15th of next month, and schedule a To-Do activity "Gửi báo giá".

Task 2 (6 minutes). From the opportunity click New Quotation, add 3 TL-SG3218PE switches, switch on the three profit columns, and save. Write down Pricelist, Payment Terms, Disc.%, Total and Margin.

Task 3 (5 minutes). Create a second quotation for Nam Cường with exactly 3 TL-SG3218PE switches. Write down the same figures as in task 2 and compare the two quotations.

Task 4 (5 minutes). Create a third quotation for Nam Cường, 1 TL-SG3218PE switch, Disc.% 20. Use Get Approved, Create Approval Request and Submit. Then go back to the quotation and click Confirm.

Task 5 (4 minutes). Confirm the Kim Sơn Hà quotation (task 2). Open the delivery from the Delivery button. Cancel the second Nam Cường quotation.

Task 6 (3 minutes). Open the Kim Sơn Hà opportunity and click Won. Add a small opportunity for Nam Cường and mark it Lost with the reason Not enough stock.

Task 7 (2 minutes). Open Sales > Reporting > Customers, switch to Pivot, find the two customers, and read their Margin and Untaxed Total; open CRM > Reporting > Forecast and find the Kim Sơn Hà opportunity.

Self-check:

  • Task 2: the Kim Sơn Hà quotation has Pricelist "Reseller Price (5% off) (VND)", Payment Terms "30 Days", Unit Price 2,710,000, Disc.% 5.00, Untaxed Amount 7,723,500 and, if the product cost is still 2,108,000, Margin 1,399,500 (18.12%).
  • Task 3: the Nam Cường quotation has Pricelist "Standard Price List (VND)", "15 Days", Disc.% 0.00, Untaxed Amount 8,130,000 and Margin 1,806,000 (22.21%). Kim Sơn Hà is about 4 percentage points lower than Nam Cường on the same goods.
  • Task 4: the line has only 60,000 of margin left (2.77%); the request is in To Approve with the next approver Nguyễn Hải Sơn; the quotation can still be confirmed and carries the stamp WAITING FOR APPROVAL.
  • Task 5: the delivery has the form HN/OUT/xxxxx, Source Location "HN/Tồn kho"; the cancelled quotation has the status Cancelled and has no Delivery button.
  • Task 6: the won opportunity is in the Won column with a probability of 100 %; the lost opportunity has the LOST stamp and Lost Reason "Not enough stock".
  • Task 7: in Forecast the Kim Sơn Hà opportunity sits in the column of the month of Expected Closing and has the WON stamp; in the report by customer, the Kim Sơn Hà row has a Margin divided by Untaxed Total that is that customer's margin rate.
Zalo