Back to Course
Commission Reporting in Zoho Analytics (for both Zoho Books and Zoho CRM!)
0% Complete
0/0 Steps
-
Think About Your Commission Structure4 Topics
-
Build Your First Commission Report3 Topics
-
What If My Commissions Structure Is More Complex?8 Topics
-
Planning Out Our Commissions Use Case
-
Our First SQL Query, Calculating the Commissionable %
-
Understanding the Invoice and Customer Payments Data
-
Calculate Commissions Awarded for Payments
-
Understanding Credit Note Refunds and How They Play into Our Report
-
Calculate Your "Negative" Commissions Using Refunds
-
Consolidate Code and Finish Your SQL Query
-
Commissions Review
-
Planning Out Our Commissions Use Case
Lesson 3, Topic 3
In Progress
Understanding the Invoice and Customer Payments Data
Lesson Progress
0% Complete
Make sure you understand which tables you need for the coming SQL code! Identify which columns of data you’ll use for your JOINs.