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 billingschedule table 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
Rookie Asked on May 5, 2021 in Workbooks.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor