Month: February 2023

Unable to Edit and Save Journal Entry > error: The account (xxx) is an inactive account. Please correct the import file and resubmit.

The number that is displayed on the error message refers to the Internal Id of the Inactive account which is included in the Journal Entry. 1. Navigate to Home > Set Preferences 2. Under the General tab, set the Show Internal Ids box to True 3. Click Save 4. Go to your Chart of Accounts by navigating to Setup > Accounting > Chart of Accounts or Lists > Accounting > Accounts or Reports > Financial > Chart of Accounts 5. Look… Continue reading Unable to Edit and Save Journal Entry > error: The account (xxx) is an inactive account. Please correct the import file and resubmit.

CSV Import: Vendor Bill > Error: Multiple rows in your primary CSV file have the same value for the key column. Please edit this file to eliminate rows with duplicate key column values. for field “ExternalId”

Scenario: Customer imports vendor bill with expense line items using multiple files and External ID as the reference key, yet encounters an error: Multiple rows in your primary CSV file have the same value for the key column. Please edit this file to eliminate rows with duplicate key column values. for field “ExternalId” after field mapping and… Continue reading CSV Import: Vendor Bill > Error: Multiple rows in your primary CSV file have the same value for the key column. Please edit this file to eliminate rows with duplicate key column values. for field “ExternalId”

Adding Months to date in workflow

When we want to add months to a date in the ‘after field edit’ trigger it is unable to get the ‘ADD_MONTHS’ function in the formula field. So to add months to the date after the field edit, nlapiDateToString(nlapiAddMonths(nlapiStringToDate(nlapiGetFieldValue(‘custrecord_date’)),{custrecord_month}),’date’) custrecord_date: Id of the date fieldcustrecord_month: Id of the month field eg: add ‘6’ months with… Continue reading Adding Months to date in workflow

Automated Bank Data Import for Bank Feeds

The Bank Feeds SuiteApp uses the Financial Institution Connectivity Plug-in to perform an automated process that retrieves bank data and imports them into your NetSuite account. The first time a format profile is saved: NetSuite requests to download the last 60 calendar days of available bank data from your financial institution into NetSuite. A schedule… Continue reading Automated Bank Data Import for Bank Feeds

Sublist item selection method for items rendered in a custom suitelet page

We can select an item from a sublist using the index. If we use the line index we can use the selectLine() function for this.We can also calculate the index value using the line Id. The line id is usually one value greater than the index value. But this can be different if some items… Continue reading Sublist item selection method for items rendered in a custom suitelet page

Updating Imported Bank Feeds Data

Aside from the automated daily import, we can also update our bank data in NetSuite by manually initiating the system to retrieve the latest bank transactions from your financial institution. Perform any of the following actions to initiate the import process: Update the Bank Feeds Format Profile Records – Update the provisioned format profile records… Continue reading Updating Imported Bank Feeds Data