Required Prorated amounts on AR Invoice Lines to be posted to GL.
Hi,
Currently we are on Oracle EBS 12.2.6 and have the below requirement to be achieved.
For example, I have a USD Sales order with three lines: one for $100, another for $75, and a third for $60. The salesperson discounts the order line for $75 by 100 percent.
| Selling Price | Discount Amount | Invoice Amount | Revenue Amount | |
|---|---|---|---|---|
| Line 1 | 100 | 0 | 100 | 68.09 |
| Line 2 | 75 | 75 | 0 | 51.06 |
| Line 3 | 60 | 0 | 60 | 40.85 |
| Totals | $235 | $75 | $160 | $160.00 |
Here Sales order or AR Invoice created will have line values as under invoice amount column . As a standard functionality, we see the same amounts for each line when posted to GL for Revenue journal lines.
We have a need of having the Revenue journal lines posted the values as that under Revenue Amount column in the table above to GL without the change in invoice amount values in AR Invoice.
0