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,
BUILTIN.DF(CATEGORY) AS "BUDGETCATEGORY",
BUILTIN.DF(BI.DEPARTMENT) AS DEPARTMENT,
BUILTIN.DF(BI.LOCATION) AS LOCATION,
BUILTIN.DF(CSEG_1000_FUNDTYPE) AS FUNDTYPE,
BUILTIN.DF(CSEG_1000_SOURCEF) AS SOURCEF,
BUILTIN.DF(CSEG_1000_ACTIVITY) AS ACTIVITY,
BUILTIN.DF(CSEG_1000_CATEGORY) AS CATEGORY,
BUILTIN.DF(CSEG_1000_SUBCAT) AS SUBCAT,
BUILTIN.DF(CSEG_1000_UNIT) AS UNIT,
BUILTIN.DF(CSEG_1000_GROUP) AS GROUP_EXPENSE,
BI.amount,
BI.periodamount1,
BI.periodamount2,
BI.periodamount3,
BI.periodamount4,
BI.periodamount5,
BI.periodamount6,
BI.periodamount7,
BI.periodamount8,
BI.periodamount9,
BI.periodamount10,
BI.periodamount11,
BI.periodamount12
FROM
BUDGETIMPORT BI
LEFT JOIN ACCOUNT ACC
ON ACC.ID = BI.ACCOUNT