Report Builder (rtm) - Driver Commission Report in Sales Invoice Listing
In this step by step tutorial for beginner, learn how to create a Driver Commission Report for the Month in Sales Invoice Listing.
This report calculates the commission rate as long as the invoice is created, with no payment required. The driver commission is calculated per trip, and each item will have its own commission rate.
Summarize the information as below :
Location as the Driver Name,
Commission Rate from Maintain Stock Item,
Formula calculate the commission = Commission Rate x Quantity.
𝐓𝐢𝐦𝐞 𝐒𝐭𝐚𝐦𝐩𝐬
00:00-00:32 Introduction
00:33-01:26 Step 1 : Create DIY Field & Brief on Default Sorting
01:27-01:58 Step 2 : Create Available Pipeline - Sort by Location
03:57-05:06 Step 3 : Change Report Data Pipeline to newly created pipeline
05:07-05:30 Step 4 : Set Group by Location Custom Field
05:31-06:53 Step 5 : Adjust Component Position and Add a New Label
06:54-07:29 Step 6 : use Variable capture Due Date from Customer Invoice
07:30-10:02 Step 7 : Commission Rate Calculation
10:03-10:34 Step 8 : Variable Calculation Sequence
10:35-11:03 Step 9 : Use DBCalc to Sum Up Field
11:04-13:02 Step 10 : Create Available Pipeline - Capture Description from Document_Location
𝐂𝐨𝐧𝐧𝐞𝐜𝐭 𝐰𝐢𝐭𝐡 𝐮𝐬
🌐Official Website : www.sql.com.my
📘Facebook : / sqlestream
📸Instagram : https://www.instagram.com/sqlestream/...
🟥xiaohongshu ID : Sqlestreamhq
📺 Watch the full tutorial here:
🔗https://www.sql.com.my/webstore/custo...
#SQLAccount #ReportBuilder #Customization #SalesInvoiceListing #DrivercommisisonReport