In the meanwhile, I will talk to my IT team to tweak the code handling Salesmen provisions etc.

Cheers!

Joe

Salesman-A - Provision-1=5%           Breakpoint=200,000              Provision-2=10

This is because, I want salesmen to get 5% provision (commission) on all sales, until the 200,000 marker is reached. Any sale over 200,000 will attract a commission of 10%.

But FA calculates all sales @5% irrespective of whether it is less or more than 200,000, which is wrong.

Why is it not calculating the commission on invoices that should attract 10% commission?

And, secondly, on a related note:

How can I make FA to debit the Commission Expense Account and credit the Sales Commission Payable A/c? Because I can't see the commissions calculated by FA being shown in the Trial Balance at this time.

I think, a facility should be provided when setting up Sales Persons, where it should ask:

Specify Commission Expense Account: 61013009 (which will be common for all salesmen.

Specify Salesperson Commission Payable A/c: 21020001 (Specific to Salesman-A)
                                                                         21020002 (Specific to Salesman-B)

Under the Salesman, in Sales tab, you can set the salesman to 0%. Breakpoint 1000 and then 1%. Further operations are not possible.

If you want more sophisticated sales reports you can select the Excel as destination and use columns for further calculations.

/Joe

Many thanks Joe.

Regards,
- pedma -

If you want more sophisticated sales reports you can select the Excel as destination and use columns for further calculations.

/Joe

I'm new to FA. I've installed FA 2.3.4 under LAMP, but still don't know how to set the bonus for sales ? Example: If one salesman can sell above $1000 in a month, he will get $10 bonus or 1% bonus. If he can sell above $2000, he will get  $10 + $15  ($10 for first $1000 & $15 for the second $1000). Is it possible in FA ?

Please help
Best Regards,
- pedma -