This Report may be used to calculate commission payable on invoices. The
report is based on Invoices. If you mention agent name then agent name
is picked up from Invoice information. If you do not mention the agent
name while making invoice, then that invoice shall not be considered even
if you have attached an agent with the party in master. The following
options are available to calculate commission.
1. You may calculate commission based on any of the following values:
(a) Assessable value
(b) Sale Amount (includes Excise Duty/Cess etc.)
(c) Bill Amount (Final Bill amount)
(d) Item Wise Commission
A setting is available to change the base value as shown below:-
2. You may also calculate commission based on quantity. A setting to
open quantity column is available. If you open the quantity column you
will be prompted to enter rate of commission per unit. This rate will be
applied on total quantity of each invoice. This method is suitable only if
quantity dealt in is similar/same.
3. You may calculate commission for each invoice at a different rate.
This may be done by including commission rate column in this module.
A setting is available to activate this option. Once this column is invoked
a populate button appears. You may fill commission rates for all the
bills by clicking on this button. You may then change commission rates
for some specific bills.
4. You may calculate commission for any category / group of parties.
Parties can be selected by clicking on agent / filter combo.
5. Full Half System: sometimes you may want to calculate
commission on half amount. You will be prompted to enter half / full for
each invoice. This option may be activated from configurations /
settings.
6. Block System: sometimes you may want to pay commission on
selected bills. For this purpose you may enter block numbers. A setting
is available to activate this option.
7. Margin Rate: Sometimes you may want to calculate commission on
the reduced base value. Margin rate may be used for this purpose.
8. Packing Amount: If you don't want to pay commission on packing
amount you may make the necessary settings.
Item Wise Commission(Ref. EMM CEE CEE SPORTS)
Some times commission is paid at different rates on different items. In
such a case commission rate should be entered with each item while
making an invoice. The required column for entering commission is
"ICOMMRATE". If you want to deduct discount from Gross amount on
which commission is to be paid then you must use BOTTOM_DISCOUNT
columns to specifying discount on each item. Commission shall be
calculated on (Quantity * Rate) - ((Quantity * Rate) * Discount / 100).
Applying commission on each bill & credit to Agent Account
while posting:
Some times you may want to credit the commission to the agent account
while making an invoice. For this purpose you should specify *Comm* in
DocProperties. You must also open the agent name prompt in DocInputs.
In this case when you save an invoice you will be shown an additional
window in which agent's name will be specified. You will be also prompted
to enter commission rate. Based on this commission amount will be
calculated and a linked voucher shall be generated. You should specify the
account for commission in "DocCodeComm" in DocTypes. If commission
amount is 0 no linked voucher shall be generated. You may specify any
amount as commission if commission rate is 0(Zero) or not specified.
When voucher is passed and the agent's account is linked with TDS you
will be further asked if you want to mark this payment for TDS or you may
deduct the TDS in the same voucher.
Amount on which commission is calculated can be assessable value or sale
amount or bill amount. This is determent from the relevant setting in
commission module as discussed above.
If TDS is being deducted "TDS Payable" account must exist in master.
