Sales Commissions Based on Receipts
Display Paid Invoices between 2 dates filtered on the Sales Rep code.
Step 1
Main Menu
Debtors
Enquiry
Invoices
Paid Invoices
Step 2
The Browse box will now display all paid invoices in the system.
Click on 'Query'
Enter From Date Paid >=
To Date Paid <=
Rep Code =
OK
Click on 'Do Total' (at top of browse box).
Step 3
You now have the total payments, including GST for that period, for that Rep.
Step 4
Hardcopy
Click on 'Send To'
Select 'Printer'
Alternative – File Copy
Click on 'Send To'
Select 'File'
Document format CSV (we don't have Excel on the Server).
Take Note of the location of the File Name.
Save
Outside of Minder, import (don't just open) this file into Excel and add the calculations required. Once we have LibreOffice on the server, you can do it all there.