If we upload the 2025 revenue budget in NetSuite (not the FP&A tool) at the customer-sales item level of detail, will we be able to load quantities into NetSuite through the current quantity field without using a statistical account. The budget will be at the same level of detail as a customer invoice. what is the best way to deal with this?

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that NetSuite's base budgeting module is primarily dollar/currency based and does not directly support budgeting at the item quantity level. However, some users have mentioned using statistical accounts for quantities for budgeting and reporting, although not at the item level, but at the General Ledger (GL) level. If you want to load quantities into NetSuite through the current quantity field without using a statistical account, you might face some challenges as this is not a standard feature. However, you could potentially use a workaround by creating a separate budget category labelled as 'quantity' or something similar, and then load your data via CSV. Please note that this might require more pre-work in Excel as the CSV import process in NetSuite requires a specific template/field ordering. As for dealing with the budget at the same level of detail as a customer invoice, you might need to consider customizing your reports to pull through both budget and actuals for the stat + GL line, and use formulas to get ratios i.e., budget per unit, spend per unit, and the variance. This could help you to check for stock forecasting accuracy as well as checking KPIs for hitting quantity sales. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******