Split freight lines into multiple through SLA
We are using Oracle Receivables (and not Oracle Sales Order Managment). We are interfacing invoices from an external system via an interface.
We have a requirement to split freight revenue to multiple revenue lines.
e.g. if there are two revenue lines as follows:
Revenue Line 1: 100 (GL Revenue Code: 20.Revenue.Product A)
Revenue Line 2: 200 (GL Revenue code: 20.Revenue . Product
Freight : $10 (Freight charge Account: 20.Freight.000)
We want to allocate freight account as follows based on revenue:
Revenue Line 1: 100 (GL Revenue Code: 20.Revenue.Product A)
Revenue Line 2: 200 (GL Revenue code: 20.Revenue . Product
Freight for Line 1: 3.33 ((10*100)/300 ) (Freight charge Account: 20.Freight.Product A)
Freight for Line2: 6.67 ((10*200)/300) (Freigth charge Account: 20.Freight.Product