AR Transaction details with receipt details custom OTBI report
Summary
Need to link Receipt Application subject area to transaction details subject areaContent
Hi,
I have created a custom OTBI report with all standard AR receipt details along with it's application details however i am unable to get the transaction amount in the report. Please help.
Below is the query i have prepared for the same.
SELECT distinct ACR.RECEIPT_NUMBER,
to_char(ACR.RECEIPT_DATE,'DD-MON-YYYY') REC_DATE,
ACR.CURRENCY_CODE CURRENCY,
ROUND (ACR.AMOUNT,2) REC_AMOUNT,
ACR.COMMENTS REC_EMPL_ID,
RM.NAME RECEIPT_METHOD,
RCT.TRX_NUMBER INV_NUMBER,
ACR.STATUS,
to_char(RCT.TRX_DATE,'DD-MON-YYYY') INV_DATE,
Tagged:
0