Receivables - EBS (MOSC)

MOSC Banner

Split freight lines into multiple through SLA

edited Dec 15, 2017 4:02AM in Receivables - EBS (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center