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

Why the entity name is not available under Name Column When Entering a Journal Entry Line

Scenario When creating a Journal Entry, user can specify on the Name field the supplier or Customer at the line level. In some instance, a particular entity may not be listed or found from the Name drop-down menu.  Example: 1. Navigate to Transactions > Financial > Make Journal Entries 2. Subsidiary: Select Company A 3. Notice that Currency field is automatically set to USD (the primary currency) 4. Under Lines tab, add a row with these… Continue reading Why the entity name is not available under Name Column When Entering a Journal Entry Line