accountingnerd's Profile



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

    You can join the SuiteCloud Developer Network (SDN).

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

    • 1 answers
    • 0 votes
  • 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.


    • 1 answers
    • 0 votes
  • Beginner Asked on June 16, 2020 in 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.

    • 1 answers
    • 0 votes
  • 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: } });
    log.audit('Revenue Arrangement Reallocated', "{result: " + JSON.stringify(result) + "}");
    • 1 answers
    • 0 votes
  • You can use the Nerdly Multicompany Automation for this.

    If this shameless self-promotion is a violation of community rules, then feel free to delete this comment.

    • 4 answers
    • 0 votes
  • Beginner Asked on March 25, 2020 in SuiteCloud.

    Not knowing everything about the use case, this may not be helpful, but saved searches already log when a search is exported:

    RE: Run Script on Save Search in UIScreenshot of saved search execution log

    • 2 answers
    • 0 votes