I have my salesmen listed as follows:
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)