Looking for some help as we seemed to have hit a bit of a standstill in our exploration of commissions schedules and alternate sales amounts.
We have been trying to work on using the built-in fields for commissions purposes, and moving off of calculating permissions on average cost, rather on item defined costs.
We set item-defined costs, added the Estimated GP and other fields to the sales order, set the preference to calculate through the sales order (under Setup), etc. We then had to script the ASA to be equal to the Est GP, because the system won't use that field, so we wrote a script to trigger afterSubmit to perform a search on the transaction with the Est GP in the results and then setting the Alternate Sales Amount equal to that (which was not so straightforward, being that the field is not exposed in SuiteScript). In any event, we have that all working.
Where we are finally stumped is now in the commission schedule. Apparently, only the Bookings (or Collections) options are available - and not Billings. It is essential for us that we only calculate commissions based on Billings and posting transactions, and not on Sales Orders.
Is there any way to have the system use Estimated Gross Profit on Billings? We don't want actual gross profit, based on average cost; and we don't want to change our actual accounting costing methods; we are only interested in utilizing item defined costs for commissions purposes and for estimating gross profit and assigning a number (ASA) to store that amount and to use that exact amount as the "GP" for the billed/posted transaction.