We have two big vendors who are offering 2% discount for all current month if we are paying on the last day of the month. Therefore, the 2% discount is on the total of all purchase invoices and return invoices together before GST. For purchases invoices, 2% discount will automatically apply. However, it does not automatically apply for return invoices.

For Example: Invoice # 1 $105.00 Discount $2.00 NetPmt $103.00
Credit Note #1 ($10.50) Discount($0.20)NetPmt (10.30)
Total Payment should be $92.70

The discount $2.00 will be automatically in, but the ($0.20) won't be in unless manually entered. We normally have at least 50 invoices and returns to pay for each supplier. How can we make the system calculate discount for credit invoices?

Thanks,

Mavis