Sage 100

I looked in SAGE 100 embedded help, and in the SAGE Knowledgebase, but could not find the answer. Before I spend a lot of time with test transactions, can someone confirm that Salesperson commission that are paid based on paid invoices are NOT reduced if the customer take a cash discount (when they are paying early). The system is designed to calculate commison on the full invoice amount. Is that correct? If the client wants to calculate commissions based on the net invoice balance after cash discounts, they will need a modification.

I sense that you are correct though I can't verify other than to say that when you pay commission only on paid invoices that Sage won't flag the invoice commission for payment onto the report until the entire balance is paid.

Will be interesting to hear outcome. From a salesman perspective, why should they be penalized because customer took a discount that management offered them to pay early.

You are correct. I've had to do a custom report for a client before based on this. Cheap so and so's.

Thanks for your responses. Most likely, the client will be not be willing to pay for a custom report or a modification. The salespersons will continue to earn their entitled commissions.

We do have this... https://development.dsdinc.com/enh/downloads/R125600.pdf

@NicoleRonchetti Thank you! This DSD SAGE 100 Enhancement looks like it will fit the bill, when the client is ready. Right now the distribution volume is small, so a manual override process is working. But for 2019 - 2020 the distribution volume could increase (think Wayfair or Amazon) and this Enhancement will be needed.

Cash Receipts Journal update will take any discounts applied during Cash Receipts entry and reduce the amount subject to commission and the commission amount for that invoice. Because the commission rate on the commission record for an invoice may be taken from the total screen of the invoice at the time of update, but the salesperson's commission is actually calculated in a line item basis, the following formulas will be used to proportionally reduce the commission amount and amount subject to commission.

If they nickel and dime their employees, think what they'll do to their vendors. Kinda like Wayne's bathroom test...