Microsoft® Excel® 2010
Platform: Sage 50 U.S
This solution is used to rapidly calculate the commission due to each member of your sales force. Commissions are calculated based on paid invoices and therefore suits businesses taking a more conservative approach to paying commissions. This solution has three performance variants:V1.0 Amount due with values against each Invoice, Customer and Salesperson, Total Amount for Paid and Unpaid Invoices and Days to Pay (limited to invoices paid for the past 15 days).
V1.1 A total amount due to each SalesPerson. V1.2 Amount due with values against each Invoice, Customer and Salesperson, Total Amount for Paid and Unpaid Invoices and Days to Pay. All of these variants contain common dynamic features: The option for using a UDF in Sage Peachtree to store and retrieve SalesPerson Commisions, swiftly adding and removing report dimensions such as Customer and SalesPerson and swiftly filtering by SalesPerson and Customer.