This content has been marked as final. Show 3 replies
I would suggest being more specific in your request of field names.
Account Number (customer?)
Project Name - pa_projects_all
Receipt Amount - ?
Invoice Number - AP or AR?
Date - expenditure item date? project creation date? Invoice date?
Too many fields to determine which one you are referring to.
You can get
Account number ( table : GL_CODE_COMBINATIONS. SEGMENT1||'.'||SEGMENT2||'.'||SEGMENT3||'.'||SEGMENT4||'.'||SEGMENT5 -- no.of segment1 as per your organization acount code setup)
Project Name ( PA_PROJECTS_ALL.SEGMENT1)
Receipt Amount ( RCV_SHIPMENT_HEADERS.RECEIPT_NUM ) --- THIS IS FOR PO RECEIPT
AP Invoice Number ( AP_INVOICES_ALL.INVOICE_NUM)
AP INV.Date (AP_INVOICES_ALL.INVOICE_DATE)
AR Invoice Number (RA_CUSTOMER_TRX_ALL.TRX_NUMBER)
AR INV.Date (RA_CUSTOMER_TRX_ALL.TRX_DATE)
Go to Projects > Billing > Revenue, select ur project, got to Lines then, on the tool bar Help > Diagnostics > Examine > Block - System, Field- Last Query, Value - Is ur output.