Sage 100

 View Only

  • 1.  Using a Commission Amount instead of Commission Rate

    Posted 04-10-2025 10:45

    Hi Again,

    Hope everyone is ready for Spring (and the Tariffs crazy)!

    I have a customer that is asking if they can enter a commission dollar amount instead of a rate % on a Sales Order for the Salesperson Commission.

    Any ideas would be greatly appreciated.

    Have a great day. 
    Thanks Jacquie.



    ------------------------------
    Jacqueline Hoyte
    Director of Client Services
    Integrated Data Technology, Inc.
    ------------------------------


  • 2.  RE: Using a Commission Amount instead of Commission Rate

    Posted 04-10-2025 12:38

    Maybe someone has an enhancement.



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------



  • 3.  RE: Using a Commission Amount instead of Commission Rate

    Posted 04-10-2025 12:51

    1. Ignore the Sage SP Commission programming / feature entirely.  Add a UDF for the amount, flow to the invoice / invoice history, then use custom reports.  (Watch for multiple invoices from the same SO... perhaps have a script to reset the SO UDF when an invoice is posted against it, creating a backorder).

    2. Or, enter a flat amount in the SO header (UDF), then script an override calculation of the SO header Commission Rate (pre-write, Standard SO only).  Cross your fingers and toes and hope the correct amount gets properly written to the AR_SalepersonCommission table during invoicing.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



Related Content