Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Using the actuals and budget to create a forecast
Hi There
I was wanting to create a report in Netsuite which shows the following:
For the months that have elapsed, the actual figures are shown and for out months (future months) the budget figures are shown.
The report layout will look like the following:
The year projected figure (highlighted yellow in the above screencap) will be calculated as the sum of all of the ytd actuals + the sum of the monthly budgets for the future months.
Is this something that can be done in Netsuite?
So far, I have looked into customising existing financial reports as well as analytics workbooks though it doesn't appear to be an option with either of these.