Add Freight as a charge if the Order Amount or Ordered quantity is less than a defined number
We are on Oracle EBS 12.2.10 version.
At the time of booking a sales order, we normally know what the freight terms are. We use either Prepaid or Due. For Prepaid, there is no charge line is created and for Due (Prepay & Add) a charge line is created. We also use a 3rd party TMS (Transportation Management System) tool and a custom integration populates this charge line with actual freight charge.
We now have new business scenario and wondering how to address this. In this scenario freight should be added as separate charge if the order / invoice amount is less than $X and Ordered / Shipped quantity is < Y KGs. If this condition is met, we want the freight terms to default to Due otherwise Paid.