Discussions
Why Budget Import Data Not Grouping Per Custom Segment ?
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.
Query :
SELECT
BUILTIN.DF(ACCOUNT) as account,
BUILTIN.DF(YEAR) as year,