How can I associate NetSuite TRANSACTION_LINES with REVENUE_RECOGNITION_SCHEDULES via ODBC?

Question

How can I associate NetSuite TRANSACTION_LINES with REVENUE_RECOGNITION_SCHEDULES via ODBC?

I have researched the Connect Schema. While it says that it should be possible to join REVENUE_RECOGNITION_SCHEDULES.JOURNAL_ID TO TRANSACTIONS.TRANSACTION_ID, it breaks down if I try to look for individual invoices.

commenting to save for reference later – sawyer Jan 19 '18 at 17:01 — sawyer, Jan 19 '18 at 17:01

score 1 · Accepted Answer · answered Apr 21 '15 at 15:53

1

The TRANSACTION_LINES view has a column called SCHEDULE_ID which matches the corresponding SCHEDULE_ID in the REVRECSCHEDULES view.

SELECT 
    T.TRANID
    ,R.SCHEDULE_ID
FROM TRANSACTIONS AS T
INNER JOIN 
    TRANSACTION_LINES AS TL
    ON T.TRANSACTION_ID = TL.TRANSACTION_ID
INNER JOIN 
    REVRECSCHEDULES AS R
    ON TL.SCHEDULE_ID = R.SCHEDULE_ID
WHERE
    T.TRANSACTION_TYPE = 'Invoice'
    AND T.TRANID = 'R0356788'

answered Apr 21 '15 at 15:53

Mike Robbins

3,184
15
20

I did not find this in the documentation and it is vital to calculating revenue. Thank you Mike. – Tarzan Apr 21 '15 at 16:11

How can I associate NetSuite TRANSACTION_LINES with REVENUE_RECOGNITION_SCHEDULES via ODBC?

1 Answers1