Differentiate between Goods Value Line and Discount line on AR Invoices
For reporting & analysis purposes, we need to display an OM invoice line as following:
item code quantity value discount net
Discounts calculated using Oracle Advanced pricing is saved as a line in "ra_customer_trx_lines_all" without any differentiator from the goods value except the fields:
interface_line_attribute11 --- populated with price adjustment ID when it is a discount
interface_line_attribute6 -- populated with Order line for all lines (goods and discount)
Is the above reliable enough for reporting?
What to do when interface_line_attribute11 is not populated in a return transaction?
Moreover, if the selling price was modified/adjusted on the Sales Order, the adjustment is saved in a separate line and cannot be differentiated too. Such adjustment shall be unique so as to be able to decide in the report whether to add it to sell value or to discount value