Tag: CSV file

Creating CSV files from a saved search

REQUIREMENT Needs to create CSV file of the saved search result and send the results to the client using a scheduled script. SOLUTION We will use the task module to convert the saved search results to the CSV file and send the CSV file as email attachment using map reduce script.

PROPOSAL FOR SALES ORDER CSV FILE CREATION

Proposal Summary   This proposal summarizes the functionality for creating sales order scv files and uploading them to an external SFTP server  Requirement   Create a daily CSV (Flat) File to push approved sales orders to an external SFTP site where an integration partner (MNP) will pick the file up and process it into their system. Retail… Continue reading PROPOSAL FOR SALES ORDER CSV FILE CREATION

CSV Import-To update the Class field value on Expense Line under Vendor Bills

Scenario Create multiple file CSV Import to update the Class field value on Expense Line under Vendor Bills Solution Create a CSV Import file: Primary File Internal ID Expense File Internal ID Line ID Class Expense Category Navigate to Setup > Import/Export > Import CSV Records Import Type = Transactions Record Type = Vendor Bill/Supplier Bill Select Multiple files to upload Primary File – Vendor… Continue reading CSV Import-To update the Class field value on Expense Line under Vendor Bills

Common NetSuite CSV import errors and how to solve them

Invalid Field Mapping: Error: This error occurs when the CSV file contains column headers that do not match the field names in NetSuite. Solution: Ensure that the column headers in your CSV file match the field names exactly as they appear in NetSuite. Check for any typos or extra spaces. You can use the NetSuite… Continue reading Common NetSuite CSV import errors and how to solve them

Could not find any records by this name

The error occurs when updating child matrix items. In the CSV file, enter a separate column for the parent matrix item and another for the child matrix item. The CSV file will look like the following: Item Name/Number Subitem of Department Child item Parent item — In the Item Name/Number column, the Parent : Child… Continue reading Could not find any records by this name

Proposal For Order Import Feature

Proposal Summary This proposal covers the implementation of Order import feature in the Balaji Cricket Website Requirement The Cricket website needs to have an order import feature. The CSV file for import needs to have the below 4 columns: Door Code (Address Line 3) SKU (External ID) QTY PO It should be able to bulk… Continue reading Proposal For Order Import Feature