Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
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,
0