I have 2 budget records. I am getting the internal...
# suitescriptn
NickSuite
11/18/2021, 6:02 AMI have 2 budget records. I am getting the internal IDs using saved search. I am using SuiteQL to get the monthly amount details. It is working fine when the budgets have different field values for department, class, business unit (custom segment). But when every value is same except the business unit, it returns empty result for the other budget record (with valid internal ID). Why?
b
battk
11/18/2021, 6:18 AMshare the code
n
NickSuite
11/18/2021, 6:34 AM Copy code
var queryResults = query.runSuiteQL({
query: 'Select budgets.id, budgets.account, budgets.total, budgetsMachine.period, budgetsMachine.amount from budgets INNER JOIN budgetsMachine ' +
'ON budgetsMachine.budget = budgets.id WHERE budgets.id = ' + budgetId + ';'
});NickSuite
11/18/2021, 6:35 AMIt works for budget ID 97, but not for 109. They have same values except the business unit - which is a custom segment. Weird, isn't it?
b
battk
11/18/2021, 9:33 AMpotentially a permission issue
n
NickSuite
11/18/2021, 11:02 AMrunning as admin in a suitelet
NickSuite
11/18/2021, 11:02 AMworks for other budget records if the classifications are different.
s
Sam L
11/18/2021, 2:13 PMTried a left join rather than inner join - might be that the budget is missing an entry for the budgetmachine table. Won't solve it, but at least it will give you something to go on
n
NickSuite
11/18/2021, 2:32 PMbudgetmachine table is not created without the budget. It is actually the lines on the budget. Amount by period sublist.
7 Views