How to link Account Receivables (AR) module with Costing to get item cost for an invoice line
Summary:
Hello
Which table should I use/link with 'RA_CUSTOMER_TRX_LINES_ALL' to get the cost price of an invoice line in AR?
Content (please ensure you mask any confidential information):
I am working on a BI project whereby I need to calculate gross profit (Sales Amount - Cost Amount).
For example: I have a manual transaction on Oracle Fusion.
I can obtain the total sales value from 'RA_CUSTOMER_TRX_LINES_ALL' table. Now I need to find the total cost for that particular invoice line.
Which table should I use/link with 'RA_CUSTOMER_TRX_LINES_ALL' to get the total cost price for that particular invoice line?
0