createAccountData()

Function Declaration	`function createAccountData(options)`
Type	Object function
Description	Create a new account data set.
Returns	accountData

options is a JavaScript object with the following input parameters:

Parameter	Type	Required	Description	Since
accountId	String	Yes, for bank reconciliation	The raw ID of the external account, which the plug-in uses to link the imported account to a valid account in NetSuite.	2020.2
employeeId	String	May be required for employee expenses	The NetSuite employee ID, if provided. To link corporate card expense accounts to employee accounts, the employee ID or cardholder name must be provided.	2020.2
cardHolder	String	May be required for employee expenses	The cardholder name for credit cards. To link corporate card expense accounts to employee accounts, the cardholder name or employee ID must be provided.	2020.2
dataAsOfDate	String	No	The date when data from a financial services provider was last updated. This can correspond to a file date, statement date, or other declared “last updated” timestamp from the data source. NetSuite currently accepts the ISO 8601 extended local date format. When dataAsOfDate is set, the following fields are populated from the most recent imported account statement containing a statement date: Bank Balance and Balance As Of on the Match Bank Data page Statement End Date and Ending Statement Balance on the Reconcile Account Statement page If no account statements contain a statement date, the following takes place: The Bank Balance and Balance As Of fields are not populated. The Statement End Date and Ending Statement Balance fields are populated with the current date, and the closing balance from the last reconciliation statement, respectively. Note: If you use a default parser to upload a file without an account statement date, NetSuite uses the most recent imported transaction date to set the statement date. This date may or may not correspond to the real account statement date. The date must be in the format YYYY-MM-DD. For example, 2018-05-28.	2020.2
openingBalance	Number	No	The amount of money in the account at the start of an accounting period.	2020.2
closingBalance	Number	No	The amount of money left in the account at the end of an accounting period.	2020.2
currentBalance	Number	No	The current amount of money in the account.	2020.2
dueBalance	Number	No	The amount of money owed on an account.	2020.2

Parameter

Type

Required

Description

Since

accountId

String

Yes, for bank reconciliation

The raw ID of the external account, which the plug-in uses to link the imported account to a valid account in NetSuite.

2020.2

employeeId

String

May be required for employee expenses

The NetSuite employee ID, if provided.

To link corporate card expense accounts to employee accounts, the employee ID or cardholder name must be provided.

2020.2

cardHolder

String

May be required for employee expenses

The cardholder name for credit cards.

To link corporate card expense accounts to employee accounts, the cardholder name or employee ID must be provided.

2020.2

dataAsOfDate

String

The date when data from a financial services provider was last updated. This can correspond to a file date, statement date, or other declared “last updated” timestamp from the data source.

NetSuite currently accepts the ISO 8601 extended local date format.

When dataAsOfDate is set, the following fields are populated from the most recent imported account statement containing a statement date:

Bank Balance and Balance As Of on the Match Bank Data page
Statement End Date and Ending Statement Balance on the Reconcile Account Statement page

If no account statements contain a statement date, the following takes place:

The Bank Balance and Balance As Of fields are not populated.
The Statement End Date and Ending Statement Balance fields are populated with the current date, and the closing balance from the last reconciliation statement, respectively.

Note:

If you use a default parser to upload a file without an account statement date, NetSuite uses the most recent imported transaction date to set the statement date. This date may or may not correspond to the real account statement date.

The date must be in the format YYYY-MM-DD. For example, 2018-05-28.

2020.2

openingBalance

Number

The amount of money in the account at the start of an accounting period.

2020.2

closingBalance

Number

The amount of money left in the account at the end of an accounting period.

2020.2

currentBalance

Number

The current amount of money in the account.

2020.2

dueBalance

Number

The amount of money owed on an account.

2020.2

Example

          var account = context.createAccountData({
    accountId: '101',
    account: '5430001',
    account: 'ALICE GREEN',
    dataAsOfDate: '2019-12-19',
    openingBalance: 100.0,
    closingBalance: 120.0,
    currentBalance: 125.0,
    dueBalance: 10.0
});
  
var transaction = account.createNewTransaction({...});

Example

Related Topics