1 Topic by ccmacachor (edited by ccmacachor 11/16/2020 10:55:26 am)

  • From: Philippines, Calabarzon
  • Registered: 07/30/2020
  • Posts: 33

Topic: Setting up commissions

If the commission is based on an amount beyond a certain minimum, can sales person be set up as follows?

For example: Total amount collected from customer is $5,000 Any amount in excess of $3,000 goes to the salesman as commission. The sales policy gives the salesman the discretion to sell above or below the suggested selling price of $5,000, provided it is not lower than $3,000.

Provision: 0%
Breakpoint: $3,000
Provision 2: 100%

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Setting up commissions

This can be programmed as a trigger in the mysql database itself irrespective of what FA computes and enters in the DB. Beware of amendments and deletions.

Nice slab feature for FA 2.5.

apmuthu's Website

  • From: Philippines, Calabarzon
  • Registered: 07/30/2020
  • Posts: 33

Re: Setting up commissions

Thank you very much. We will consider this.

Celito