You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!