Billing Schedule Details with Workbook or SuiteQL
I’ve got the following SuiteAnalytics Connect query that returns the billing schedule for a sales order without tax (the UI shows the amounts WITH tax). I can’t seem to replicate this query with SuiteQL as the
billingscheduletable doesn’t have the same amount fields. Can this be done with SuiteQL, a workbook, or a saved search?
SELECT SUM(BS.BILL_AMOUNT_FOREIGN), BS.BILL_DATE FROM BILLING_SCHEDULE BS INNER JOIN TRANSACTION_LINES TL ON BS.TRANSACTION_ID = TL.TRANSACTION_ID AND BS.TRANSACTION_LINE_ID = TL.TRANSACTION_LINE_ID INNER JOIN ITEMS I ON TL.ITEM_ID = I.ITEM_ID WHERE BS.TRANSACTION_ID = 495276 GROUP BY BS.BILL_DATE ORDER BY BS.BILL_DATE