Our automated sync program runs nightly, updating the commission database from NetSuite. It syncs a subsets of required master data, like sales reps and customers. It also syncs subsets of whatever commission transactions you have, like invoices, credit memos, and returns. When the new transactions are loaded, the program applies the commission multipliers to the transaction based your rules, including splitting commissions between sales reps or event different rep types. It will flag "problem transactions" to be reviewed by your commission administrator if needed. The program can be easily set to exclude syncing transactions for conditions such as house accounts and internal order types.