Hi everyone, I have a question: I'm currently trying to create a report with HTML rendering in Suitelet. The report is a budget report using a standard budget. I'm currently using SuiteQL to retrieve data from the "Budgetimport" table. However, there's a problem: the data in that table isn't grouped according to the custom segments applied to the Budget Import records. It only groups by default segments like Department and Location. How can I save and group the data according to the custom segments as well? Thank you.

I haven't used the budgetimport table - i do use the budgetsmachine and budgets table to get what i need. Select * from budgetsmachine bl LEFT JOIN budgets b ON bl.budget = b.id

Okay, thank you, but there is no Custom Segment column in those two tables, so I tried querying from the Budgetimport table, but the data didn't match. Because the request is for budget data to be filtered based on custom segments as well.

strange... doesn't look like my custom segments are pulling through - i've never had to use them for budgeting, frustrating they don't appear to be available via Squiteql