accountingnerd – NetSuite Professionals

RE: NetSuite Development Access

Beginner Asked on December 16, 2022 in How To's.

You can join the SuiteCloud Developer Network (SDN). https://www.netsuite.com/portal/developers/sdn.shtml

You’ll get access to a release, QA, and dev account, as well as a demo account.

119 views
1 answers
0 votes

RE: How to use the Electronic Bank Payments Bundle to pad the end of a NACHA file?

Beginner Asked on January 10, 2022 in SuiteApps.

Here’s what I found in the helpfile in NetSuite for the company bank details setup:

Complete the fields on the DD Template Details subtab.

Field	Description
Immediate Origin	Enter your company’s 10-digit number assigned by the bank.
Routing Number	Enter the bank’s transit routing number.
Account Number	Enter your company’s bank account number.
Immediate Destination Name	Enter the name of the bank’s site where the payment will be processed.
Create Balanced Files	Check this box to include a contra record line in the payment file to create a balanced file. Check whether your bank requires this for EFT transactions.
Company ID	Enter your company’s tax Id or the company number assigned by your bank.
Bank Account Type	Select Checking or Savings to indicate the bank account type.
Add Pad Blocks	Check this box to add lines with “9” characters at the end of the payment file when the total number of records is not a multiple of 10. Check whether your bank requires this option for EFT transactions.

Field

Description

Immediate Origin

Enter your company’s 10-digit number assigned by the bank.

Routing Number

Enter the bank’s transit routing number.

Account Number

Enter your company’s bank account number.

Immediate Destination Name

Enter the name of the bank’s site where the payment will be processed.

Create Balanced Files

Check this box to include a contra record line in the payment file to create a balanced file. Check whether your bank requires this for EFT transactions.

Company ID

Enter your company’s tax Id or the company number assigned by your bank.

Bank Account Type

Select Checking or Savings to indicate the bank account type.

Add Pad Blocks

Check this box to add lines with “9” characters at the end of the payment file when the total number of records is not a multiple of 10. Check whether your bank requires this option for EFT transactions.

616 views
1 answers
0 votes

RE: Importing Issue

Beginner Asked on June 16, 2020 in Accounting.

accounting

The reason for the error is that NetSuite doesn’t recognize what you are doing as an update to an existing account. You should look at the chart of accounts and see if there is any other account that has the same account number as the one that you are trying to update. If you are doing an update, you can try to specify the internal ID or external ID of the record to ensure that you are updating the correct record.

674 views
1 answers
0 votes

RE: Allocate Revenue Arrangement Page

Beginner Asked on May 26, 2020 in Revenue Recognition.

NetSuite normally performs the allocation automatically, so processing 11,000 records is outside the standard and normal process. Not helpful, I know.

Allocation can be run by a script, so you could create a scheduled script/ MapReduce / Workflow Action script to perform the allocation automatically. I’ve done that a few times for customers who had some interesting allocation procedures.

Here’s the basic workflow action script version:

/**
* @NScriptType WorkflowActionScript
* @NApiVersion 2.0
*/
define(["require", "exports", "N/log", "N/action"], function (require, exports, log, action) {
Object.defineProperty(exports, "__esModule", { value: true });
exports.onAction = function (ctx) {
var result = action.execute({ recordType: 'revenuearrangement', id: 'allocate', params: { recordId: ctx.newRecord.id } });
log.audit('Revenue Arrangement Reallocated', "{result: " + JSON.stringify(result) + "}");
};
});