Sage 100

 View Only
  • 1.  v4.5.3 - Client wants to pay commisson based on cu

    Posted 05-09-2012 05:21
    v4.5.3 - Client wants to pay commisson based on customer AND the item being sold. Is this possible? To me it appears the only options by the item (all customers) or by the salesman (all items and customers). Otherwise, we have to get creative. Thoughts. Thanks in advance.


  • 2.  RE: v4.5.3 - Client wants to pay commisson based on cu

    Posted 05-09-2012 07:50
    Been there, done that (or at least I've done something very similar). It is actually pretty easily accomplished through scripting. The UDT is not something that a customer would want to look at because we only have one field available as a key and what you are talking about is a two field key lookup. Could they be convinced to do Product Line/Customer? 4.5 has pricing by Product Line/Customer, and so it would just be a matter of adding a UDF to that table and then either use BOI or scripting to bring in the commission rate.