OK, so I've tried to use the commissions module, but I can't, because (1) I need to pay on a multiple of revenue on certain line items on certain transaction (perfect for ASA) but (2) ASA does not work for Cash Sales or Invoices, which is how our workflow is setup in some cases.
So, I am OK using Excel to calc our commissions, using a Saved Search to calc the ASA (via a formula). The problem is, I can't figure out how to report the amount paid for invoices.
I need something like this:
ORDER # SALES AMOUNT ASA (Formula) TYPE AMT PAID IN MONTH
12345 $1,500.00 $3,000.00 Invoice $750.00
In the above example, I'd pay on 50% (750/1500) of the $3000 ASA. Again, I understand this is all in the commissions module, but I can't use it!
I have tried a transaction search on (invoice/cash sale) and tried a joined search on payment, but it doesn't work because the ASA formula needs to access the line items...so Main Line=false [but then I can't get to the payment info I think].
I've also tried a transaction search on customer payments, but can't get the line items on the invoice transaction to do the ASA calc.
Anybody have any ideas?
Thanks!
Dan