Budget Import

A budget import record exposes a budget import to REST web services.

You can use the Import Assistant to import budget data directly into NetSuite.

To import a budget, go to Transactions > Financial > Set Up Budgets > Import.

This record:

For help working with this record in the UI, see Importing a Budget and Budget Import.

For information about using the REST API Browser, see The REST API Browser.

Record ID

The record ID for a budget import REST record is budgetimport.

Prerequisites

You need the Set Up Budget permission to import budget data. You don't need the Import CSV File permission.

Usage Notes

Additional period amount fields, such as periodAmount13 - periodAmount24, are only functional when the fiscal year contains the corresponding number of periods. For example, periodAmount13 can only be used if the fiscal year has 13 periods. The extra period amount fields are ignored during import if the periods don't exist.

Each budget import record represents a single account line on the Budget record in the UI. For example, if a Budget record in the UI includes period amounts for five accounts, there will be five corresponding budget import records.

Code Sample

The following code sample shows how to create a new budget:

            POST - {{host}}/services/rest/record/v1/budgetImport/ 
{
"account": {"id": "54"},
"accountingBook": {"id": "1"},
"amount": 999.0,
"budgettype": true,
"category": {"id": "1"},
"currency": {"id": "1" },
"periodamount1": 111.0,
"periodamount2": 111.0,
"periodamount3": 111.0,
"periodamount4": 111.0,
"periodamount5": 111.0,
"periodamount6": 111.0,
"periodamount7": 111.0,
"periodamount8": 111.0,
"periodamount9": 111.0,
"subsidiary": { "id": "1"},
"year": { "id": "630"}

} 

          

Related Topics

General Notices