Is there any way available to compute discounts at the line level for each item on vendor bills?

Hi,

I understand that the discount amount field is populated based on the terms specified in the vendor record.

The requirement is to calculate the discount for all items, excluding certain specified items, and then place this calculated discount amount in the "Discount Amount" field. It's desired to achieve this without creating a custom field.

For example the discount rate is 2%

In Bill there are 3 items

item1 - 100

item2 - 250

item3 - 50

I understand correctly, the standard functionality calculates the discount amount as 8.00.

However, I wish to exclude the calculation of the discount for item3, resulting in a new discount amount of 7.00.