Percentage calculation on the Vendor payable amount
I am putting up a scenario and the requirement related to the vendor payment. It is as follows :
It is an agricultural business. Company is making down payment to vendors at the time of purchasing goods from them. They pay the balance after the end of season say after 1 or 2 months. While making the payment, they calculate 16% commission on the remaining amount and pay the same over and above the balance payment to the vendor.
a. They want that 16% commission to be calculated by the system and make the posting with the consolidated payment.
b. They want it in bulk and hence through automatic payment program.
Kindly suggest at the earliest.
Thanks And Regards