This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Has anyone had luck querying budgets?  I’m looking to pull uploaded budget numbers by period.

are you just looking for the right tables to pull from?

Thanks Mark. When I run select * FROM Budgets I get a “Total” column that represents the total for the entire year. - I want to break it down by month. I imaging I’d have to dig into something like budgetsMachine but not sure that is the correct thinking.

I haven't done this before, but it looks like you are right that you'd need to join with `budgetsmachine` (to get budget by accounting period) or `budgetsmachinenoaccountingperiod` (to get budget by month). Have you tried something like:
 `SELECT * from budgets, budgetsmachine WHERE budgets.id=budgetsmachine.budget`

Yep - just need to knock the rust off of my SQL mindset.  This is what looks like it will work…`SELECT * from budgets, budgetsmachine WHERE budgets.id=budgetsmachine.budget AND ( RowNum &lt;= 100 )`

My next obstacle is pulling a GL Impacting Custom Segment into the results. It looks like NetSuite assigned the custseg_n490_* where “_n490_” seems arbitrary and thus the field may be troublesome to access