How to resolve error “INVALID_FLD_VALUE The field custrecord_ste_backend_inv_error_details contained more than the maximum number ( 4000 ) of characters allowed.”

Scenario: An error keeps showing when we enter each detail in the Tax Registrations subtab of vendor, or customer records. The error-mentioned field is from the Suite Tax Engine bundle and is a locked one. We have recently migrated to SuiteTax and the new subsidiary implementation is ongoing. The error started after SuiteTax Migration. The… Continue reading How to resolve error “INVALID_FLD_VALUE The field custrecord_ste_backend_inv_error_details contained more than the maximum number ( 4000 ) of characters allowed.”

Customers/Vendors of inactive subsidiaries

REQUIREMENT We have customers and vendors that have a primary subsidiary in which will be inactivated really soon. Also, note that these customers and vendors have remaining balances with this subsidiary. I would like to ask what will happen to these customers and vendors once the subsidiary will be inactivated. Also, can the primary subsidiary… Continue reading Customers/Vendors of inactive subsidiaries

Map Reduce script to link Manufacturer records(custom) with Vendors

Map reduce script that will process all Vendor RFQ record lines that had a response entered in the previous day. Manufacturer record is a custom record. define([‘N/search’, ‘N/record’, ‘N/runtime’], function (search, record, runtime) {     /**      * @description Function to get authorized vendor id      * @param {*} manufacturerId     … Continue reading Map Reduce script to link Manufacturer records(custom) with Vendors

Vendor sync from NetSuite to multiple TrackTrace

Vendor sync from NetSuite to multiple TrackTrace. It is to be done based on subsidiaries included in the subsidiary sublist. define([‘N/record’, ‘N/search’, ‘N/ui/serverWidget’, ‘../../Common Library/jj_tracktracerx_ns_utility.js’, ‘../../Config Module/jj_cm_tracktracerx_api_config.js’],     /**    * @param{record} record    * @param{search} search    * @param{serverWidget}    * @param{jjUtil} jjUtil    * @param{TrackTrace} TrackTrace    */     (record, search,… Continue reading Vendor sync from NetSuite to multiple TrackTrace

Unable to get New (+) icon in vendor record to create new customer from the vendor

According to SuiteAnswers ID 46558, this may be due to the Vendor being in multiple subsidiaries. Please be advised that the + icon in the Other Relationships is available only when the Vendor is assigned to one specific subsidiary and on edit mode. To resolve this, here are the steps we may take 1. Open the vendor… Continue reading Unable to get New (+) icon in vendor record to create new customer from the vendor

Adding Vendor name when processing Allocation Schedules

Requirement: When we run and post allocation schedules, the process works on all related invoices and performs credit and debit on the related department with the allocation schedule. The issue is that it does that without bringing in the vendor’s name. What happens is that when we try to analyze our P&L by vendor spending,… Continue reading Adding Vendor name when processing Allocation Schedules

Error Handling: Represents Subsidiary must be different to Subsidiary

Sometimes, an incorrect Vendor record might be created in NetSuite, and it becomes necessary to mark this record as inactive. Attempting to mark the Inactive checkbox directly on the Vendor record and saving it can sometimes result in the error message: “Represents Subsidiary must be different to Subsidiary.” To successfully inactivate the incorrect Vendor record,… Continue reading Error Handling: Represents Subsidiary must be different to Subsidiary

How to Update the Existing Entity Bank Details of Employee or Vendor Records via CSV Import

The Entity Bank Details is another Custom Record from the Electronic Bank Payments bundle, but the difficulty in performing a CSV Import for this Custom Record is identifying a unique identifier. This article shows how to display the Internal ID for the Entity Bank Details record and use it for the CSV Import file Step by… Continue reading How to Update the Existing Entity Bank Details of Employee or Vendor Records via CSV Import