Sage 100

 View Only
  • 1.  Split Commission

    Posted 07-25-2022 17:26
    Edited by Kenny Daniel 07-25-2022 17:39
    Without getting into any customizations, is there any report in Sage100 that will accurately show the amount of an invoice when split between Salepersons? All reports, including Salesperson Commision, show the Invoice Total for the Salesperson, even when its split. It's confusing when wanting to get total sales per Salesperson. Is there anything that will show the amount attributed to each Salesperson? Customer wants a report that will show the split amount of an invoice in order to calculate total sales per Salesperson. I know it's an easy fix in Crystal but I'm finding it hard to believe there isn't something like this already in Sage100   TIA

    ------------------------------
    Kenny Daniel
    TechnoClarity, Inc.
    ------------------------------


  • 2.  RE: Split Commission

    Posted 07-26-2022 09:11
    I don't think so. One of my customers is a heavy user of split commissions. They  use the split to calculate the $$ owed to each salesperson. It sounds like you want to allocate a portion of each sale to the salespeople on the invoice/split commission for the purposes of analyzing how much in sales a salesperson is deemed responsible for? 

    Seems like a Crystal Report would be needed.


    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Moodus, CT
    ------------------------------



  • 3.  RE: Split Commission

    Posted 07-27-2022 01:18
    I created a Sage Intelligence report for clients to accommodate this.  One of my clients has different split commissions by ship to code, with exceptions that DSD created a customization for.

    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------



  • 4.  RE: Split Commission

    Posted 07-30-2022 09:45
    I ended doing a custom Crystal report. Thank you both.

    ---------------------------------
    Kenny Daniel
    TechnoClarity, Inc.
    ---------------------------------