Author: Rose Wadakken

vendor send you an invoice containing items from multiple purchase orders. You can select what items to include in your bill so you can match it with the vendor invoice. Navigate to Transactions > Payables > Bill Purchase Orders Vendor: Select Vendor Check Bill checkbox to mark all purchase orders you need to bill Click SubmitNote: This will route to you to a Bill form where… Continue reading Create Vendor Bill from Selected Lines in Multiple Purchase Orders

Import a Vendor Bill for multiple purchase orders using one CSV file. Prepare the CSV file:a. Create a CSV file with the following columns and copy the details:1. External ID – External ID to be assigned to the vendor bill2. Vendor Name – Name of vendor in NetSuite (Make sure the spelling and format is exactly the same as how it… Continue reading Bill Multiple Purchase Orders in One Bill via CSV Import

User wants use a different Font for their Invoices since the PDF Editor cannot edit PDF files with NotoSans font. User needs to download TTF files for the font they need add to the template. For example is the Arial font. User needs Arial, Arial Bold, Arial Italic, and Arial Italic Bold TTF files.  Upload File Navigate to Documents > Files > File Cabinet… Continue reading Use External Font on Advanced PDF/HTML Template

User updates the Subsidiaries selected in the GL Accounts via CSV Import. Create a CSV file with just 2 columns: Account: Internal ID of the AccountSubsidiary: Internal IDs of SubsidiariesNotes: If all subsidiaries need to be selected, use internal ID of the parent and add Include Children column and enter Yes. If multiple subsidiary, please… Continue reading Update Subsidiaries Selected in the GL Accounts via CSV Import

SuiteApp/Bundle: Fixed Assets Management | Bundle 414815 User wants to import Sub-Assets for a Fixed Asset via CSV. 1. Prepare your CSV file for importing the Sub-Asset Records. Note: Ensure to add a column for Parent Asset and set the value to the Internal ID of your preferred Parent Asset. 2. Once you have prepared the CSV file,… Continue reading Import Sub-Assets via CSV

User on a Custom Role was given a permission to import records via CSV however Setup Center tab is missing. Navigate to Home > Set Preferences Click Appearance Use Classic Interface: Enter Checkmark Click Save

The user wants to create a Workflow Action Script to set the preferred Vendor when creating a new Assembly Item when the Multiple Vendor Feature is enabled in the account.  Upload a new JavaScript (.js) file to the File Cabinet with the following code:  /** @NApiVersion 2.x @NScriptType WorkflowActionScript*/ define([‘N/record’],function(record) {function onAction(context){var itemRec = context.newRecord;var itemId =… Continue reading Workflow Action Script 2.0 to Set the Preferred Vendor when Creating an Assembly/Bill of Materials item

Once an Inbound Shipment has been created for a Purchase Order, no link is available on the Purchase Order to view the Inbound Shipment. We can create a Custom Field on the Purchase Order to manually link the Inbound Shipment. Navigate to Customization > List, Records, & Fields > Transaction Body Fields > New Add a Label, ID, and Description for the Custom Field Set… Continue reading Link Inbound Shipment to Purchase Order

User imports a Journal Entry with line items linked to related assets but receives the error message provided above. 1. The Asset Record linked to the Journal Entry line is not set to inactive Navigate to Fixed Assets > Lists > Assets Click View on the Fixed Asset Record Ensure that the Inactive checkbox is not marked on the Asset Record 2. Ensure that… Continue reading “Invalid custcol_far_trn_relatedasset reference key xxx” on Journal Entry Import

User receives an error “An unexpected error has occurred” when navigating to Transactions > Inventory > Adjust Inventory Worksheet > Import. User may divide the import into batches and limit the CSV lines not to exceed 1,000 lines Currently, Import is supported for Inventory Worksheets with up to 1000 lines Poor performance results during import and in the… Continue reading “An unexpected error has occurred.” Upon Import of Adjust Inventory Worksheet